Run the SQL Script to Create the Tables

Use this activity to run the provided or generated SQL script to create the IMS Integration Hub database tables and associations.

Activity Steps

SQL Server

  1. Create a new database.
  2. Run the SQL script in a SQL Server database scripting environment against the new database.
  3. Create appropriate logins for the IMS Integration Hub database.

Oracle

  1. Create a new schema.
  2. Run the SQL script in an Oracle database scripting environment against the new schema.
  3. Create appropriate logins for the IMS Integration Hub database.

Note: Although IMS Integration Hub can be configured to have users log on with Windows authentication, having a specified database server username and password is recommended for most installations.