SQL scripts for creating system tables

Use the scripts described in the following table to create Marketing Platform system tables manually, when your company policy does not allow you to use the installer to create them automatically.

The scripts are shown in the order in which you must run them.

Table 1. Scripts for creating system tables
Datasource Type Script Names

IBM® DB2®

  • ManagerSchema_DB2.sql

    If you plan to support multi-byte characters (for example, Chinese, Japanese, or Korean), use the ManagerSchema_DB2_unicode.sql script.

  • ManagerSchema__DB2_CeateFKConstraints.sql
  • active_portlets.sql

Microsoft™ SQL Server

  • ManagerSchema_SqlServer.sql
  • ManagerSchema__SqlServer_CeateFKConstraints.sql
  • active_portlets.sql

Oracle

  • ManagerSchema_Oracle.sql
  • ManagerSchema__Oracle_CeateFKConstraints.sql
  • active_portlets.sql

If you plan to use the scheduler feature that enables you to configure a flowchart to run at predefined intervals, you must also create the tables that support this feature. To create the scheduler tables, run the appropriate script, as described in the following table.

Table 2. Scripts for enabling the HCL Marketing Software Scheduler
Data Source Type Script Name
IBM DB2 quartz_db2.sql
Microsoft SQL Server quartz_sqlServer.sql
Oracle quartz_oracle.sql

When to use the create system tables scripts

You must use these scripts when you install or upgrade Marketing Platform if you have not allowed the installer to create the system tables automatically, or if you have used ManagerSchema_DropAll.sql to delete all Marketing Platform system tables from your database.