Preparing for the Decision Center data export

Prepare for the data export of your on-premises Decision Center web application.

Before you begin

The dbdump tool is required to export the Decision Center data repository.

About this task

Follow this procedure to prepare for the export of your on-premises Decision Center database.

Procedure

  1. Download the decisioncenter-dbdump.war_.zip External link opens a new window or tab file.
  2. Decompress decisioncenter-dbdump.war_.zip and extract decisioncenter-dbdump.war.
  3. Deploy the decisioncenter-dbdump.war.
    For example, on Liberty, copy the WAR file to the apps directory: <InstallDir>\wlp\usr\servers\<ODMVersion>\apps
  4. On your application server, map the user who does the export to a group that is mapped to the rtsAdministrator role.
    The dbdump web app uses basic authentication. Make sure you map the rtsAdministrator role to an existing user and group during the deployment of the .war file. For more information, see Deploying the Decision Center WAR files.

What to do next

Two export options are presented here, but you apply them later, as described in Moving Decision Center data. You can also do them right now if downtime is not an issue.

There are two ways you can use the dbdump tool to export the Decision Center database.

Option 1: Browse to http://<host>:<port>/decisioncenter-dbdump/

  1. Provide the JNDI name of the data source. The default value is jdbc/ilogDataSource.
  2. Optionally, click the Lookup button to display details about the data source.
  3. Provide the Decision Center schema name. The option "use data source default" indicates that the same schema name as the one computed by the Decision Center web application is used to retrieve the data tables.
  4. Do not check "Exclude definitions".
  5. Choose one of the following options to generate a compressed file of the Decision Center database.
    • Click Direct download. The file download starts shortly. No file is saved to the server.
    • Click Save on server to export the file directly to the server. When the export is complete, a link is generated.

Option 2: Use the following type of URL to initiate the download: http://<host>:<port>/decisioncenter-dbdump/services/download?<parameters...>

Where <parameters...> corresponds to the following arguments:

  • ds: the data source JNDI name (e.g. ds=jdbc/ilogDataSource)
  • schemaName: the name of the schema (e.g. schemaName=DCREPO)
  • useDefaultSchemaName: the request to use the default schema name with useDefaultSchemaName=true

If you encounter any problem, refer to the troubleshooting section of the technote Decision Center: Database export utility External link opens a new window or tab.

Go to Installing containerized ODM.