When you install Marketing Platform, you can
select the option where the installer creates the Marketing Platform system tables automatically. Alternatively,
you can manually create the system tables.
Procedure
Complete the following tasks to create and populate the system tables
manually:
-
Run the HCL®
installer as described in
installing_platform_gui_mode.html, but with
the following differences in your choices when it launches the Marketing Platform installer.
- Select Manual database setup.
- Deselect the Run Platform configuration checkbox.
-
After the installer finishes, create the system tables manually by running the following SQL
scripts appropriate for your database type against your Marketing Platform system table database, as described in SQL scripts for creating system tables.
Run the scripts in this order.
-
ManagerSchema_DBType.sql
If you plan to support multi-byte characters (for example, Chinese, Japanese, or Korean) and your
database is DB2®, use the
ManagerSchema_DB2_unicode.sql script.
-
ManagerSchema__DBType_CeateFKConstraints.sql
-
active_portlets.sql
-
quartz__DBType.sql
-
Run the populateDB utility to populate the system tables with default users and roles.
Use this command:
populateDb -n Manager
See populateDb for complete details on using this utility.
-
Run the HCL
installer again, making the
following selections when it launches the Marketing Platform installer.
