Database Setup

Before proceeding with the installation of the Boomi Integration Platform, an empty database must be created, and a user assigned to that database that has full rights to the database. The user must be able to create/drop and alter all tables, indexes, primary keys, etc. on the database. Below are some database and user requirements that must be met before proceeding with the installation.

Database Size Requirements

• New and empty database
• At least 500 MB initial space is required
• Recommended that database be configured to automatically grow in size

User Permissions Requirements

The user that is assigned to the database must have full rights on the database including but not limited to:

• Create/Drop/Alter Tables
• Create/Drop/Alter Indexes
• Insert/Update/Delete/Select

Other Requirements

• Collation - Be sure the database is created with a case-insensitive, accent-insensitive collation. For example, in MS SQLServer use collation Latin1_General_CI_AI.

If you are installing on MySQL 4.1 or higher, please follow the MySQL Setup instructions.