Step 7. Modify the Message Manager database/query file

Edit online

About this task

You need to change the database type in the install_dir\tmgr_vn.n\mmgr\update.mdq file to match the database type for your installation, for example Microsoft SQL Server or Oracle. Trading Manager is configured to use Microsoft Access as its database. If you have built your prototype environment using Microsoft Access, you must convert from Access to your database type in preparation for your production environment.

The Message Manager default database definition is an open database connectivity (ODBC) database for the Windows platform. See the Partner Manager documentation for more information.

Each Partner Manager client must have an ODBC System data source name (DSN) for both test and production servers.

To modify the update.mdq database/query file perform the following steps:

See the Database Interface Designer documentation for information on defining databases.

Procedure

  1. Open the Database Interface Designer.
  2. Open the Update.mdq file in install_dir\tmgr_vn.n\mmgr.
  3. Expand Update to show the TmrcMgrDB database definition; select TmrcMgrDB.
  4. From the Database menu, select Edit.

    The Database Definition window opens.

  5. Expand the Adapter setting.
  6. From the Type drop-down list, select the appropriate database type.

    The database-specific fields appear in the Database Definition window.

  7. Specify the Platform from the drop-down list.
  8. Enter the appropriate information for the selected database.
  9. Click OK to set these database settings.
  10. From the File menu, choose Save to save the database/query file.