Dashboard > Boomi Integration Platform > ... > Installation Guide > Database Setup
Log In   View a printable version of the current page.  
  Boomi Integration Platform  
  Database Setup
Added by Mitchell Stewart, last edited by Adam Arrowsmith on May 29, 2007  (view change)
Labels: 
(None)

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.

Powered by Atlassian Confluence, the Enterprise Wiki. (Version: 2.2.1a Build:#515 May 19, 2006) - Bug/feature request - Contact Administrators