Database scripts

If you choose to use the Model Builder to build only the model, the database administrator must create the database before you can define the model. There are two sample scripts:

• Ctrain_ModelCreate_SqlServer.sql
• Ctrain_ModelCreate_Oracle.sql

The sample scripts are located on the CPM Server computer in the ProgramData\Infor\CPM\Architect\Database Creation Scripts directory.

The script performs these steps:

• Creates the tablespaces. The production and authorized databases share the tablespace used for the dimension data.
• Creates the administrative users for the production and authorized databases. The user names are automatically used as schema names.
• Creates the roles.
• Assigns the appropriate roles to the users.

The Model Builder user must be added as a SQL login mapped to the production and _A databases if you are loading structure and data through Model Builder.