Connecting the Dynamic Workload Console to a new node or database

Move Dynamic Workload Console data to a new node or database by exporting data to an XML file to be imported in the new instance.

About this task

If you want to move the Dynamic Workload Console to a new node or database, you need to export the settings from an existing instance and create an XML file that can be imported into another Dynamic Workload Console node or database. If in your current environment you are using Derby, you can use this procedure to move to another supported database, because Derby is no longer supported starting from version 10.2.3.
Note: The migration of the roles from the Dynamic Workload Console Version 9.4 to Version 10.2.3 is not supported. You have to recreate the roles in the latest version.
To export the Dynamic Workload Console settings from the previous installation, perform the following procedure:

Procedure

  1. From the navigation toolbar, click Administration > Manage Settings.
  2. In the Manage Settings panel, click Export Settings and save the XML file to a directory of your choice.
  3. Optionally, edit the file using an XML editor and save it.
  4. Optionally, export your custom boards: from the dashboard to be exported, click on the options menu next to the name of the dashboard and select Export. A JSON file is downloaded.
  5. Browse to the datasource_<db_vendor>.xml file located in one of the following paths:
    On UNIX operating systems
    DWC_home/usr/servers/dwcServer/configDropins/templates
    On Windows operating systems
    DWC_home\usr\servers\dwcServer\configDropins\templates
  6. Copy the datasource_<db_vendor>.xml to the path for your operating system:
    On UNIX operating systems
    DWC_DATA_dir/usr/servers/dwcServer/configDropins/overrides
    On Windows operating systems
    DWC_home\usr\servers\dwcServer\configDropins\overrides
  7. Configure the datasource_<db_vendor>.xml file based on the specifics of your environment.
  8. Only if you are moving from an Oracle database to a different database, browse to the following files:
    • DWC_DATA_dir>/usr/servers/dwcServer/apps/DWC.ear/DWCRest.war/META-INF/orm.xml
    • DWC_DATA_dir/usr/servers/dwcServer/apps/DWC.ear/Reporting.war/META-INF/orm.xml
    • DWC_DATA_dir/usr/servers/dwcServer/apps/DWC.ear/TWSWebUI.war/META-INF/orm.xml
    and replace the contents of the <schema> tag with <schema>TDWC</schema>.
  9. Copy the settings file generated from the procedure to the workstation where the new Dynamic Workload Console is to be installed.

What to do next

You can now proceed with the upgrade, either direct or parallel, based on the procedure you have chosen. You will import the settings and boards when you install or upgrade the new Dynamic Workload Console.

If you need to connect the master domain manager to a new database, see Connecting the master domain manager to a new database.