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. |