Configuring Business Data Services to Use a Separate Database

If you want to configure Business Data Services (BDS) to use a separate database to the ActiveMatrix BPM runtime database, in a different location, use the Edit TIBCO ActiveMatrix BPM Instance wizard to stop the ActiveMatrix BPM application. After moving the database, rerun the wizard to update ActiveMatrix BPM and restart the application.

Procedure

  1. On the machine on which ActiveMatrix BPM is running, run TIBCO Configuration Tool:

    TIBCO_HOME\bpm\n.n\bin\tct

    where TIBCO_HOME is the directory into which ActiveMatrix BPM is installed and n.n is the ActiveMatrix BPM version number.

  2. In the TIBCO Configuration Folder dialog, ensure that an appropriate folder is selected, and click OK.
  3. In the Create new configurations dialog, click Edit TIBCO ActiveMatrix BPM Instance.
    The Edit TIBCO ActiveMatrix BPM Instance wizard is started.
  4. On the Welcome page, ensure that the correct environment name and application name are displayed. In the Edit Action to be Performed list, select Stop AMX-BPM Product Application.
  5. On the Administrator Server Configuration page, ensure that the details are correct, and click Next.
  6. On the Summary page, click Configure.
  7. When the specified ActiveMatrix BPM application has been stopped, click Close.
  8. Move the ActiveMatrix BPM BDS database so that it is separate, using whichever method you prefer, as long as the database remains unchanged: it must retain exactly the same structure, including users, permissions, data dictionary, and data contents. Special care may be needed to correctly move all binary data used by the ActiveMatrix BPM system.
  9. In the TIBCO Configuration Tool Create new configurations dialog, click Edit TIBCO ActiveMatrix BPM Instance.
    The Edit TIBCO ActiveMatrix BPM Instance wizard is started.
  10. On the Welcome page, ensure that the correct environment name and application name are displayed. In the Edit Action to be Performed list, ensure that Edit AMX-BPM Application is selected.
  11. On the Administrator Server Configuration page, ensure that the details are correct, and click Next.
  12. On the Select Edit Configurations page, select the Edit the database used by the AMX-BPM system check box, then click Next.
  13. On the Runtime Database Configuration page, click Next.
  14. On the BDS Database Configuration page, select the Use different database to other AMX-BPM components check box, and enter the details of the new BDS database. Click Test Connection to check that the database can be accessed using the details on this page. Click Next.

    For the URL format to use, see "JDBC Connection String Formats".

  15. On the Summary page, click Configure.
  16. When the specified ActiveMatrix BPM application has been edited and restarted, click Close.
  17. In the Create new configurations dialog, click Close.