This is an old revision of the document!

6. Adding a new database to an existing installation

To modify the existing configuration or to add a new database, follow these steps:

1. Add new connection

Go to the General tab of Produmex Suite Installer.

  • To add a new database, click on the green + button. Set the connection details as described in: 3.1.1. General tab
  • To modify the connection of an already set database, change the configurations.

It is recommended to test the SBO and the direct connection before continuing by clicking on the ‘Test’ buttons.

Add new connection

2. Go the tab of the server

Go to the tab of the server you would like to connect the database.

Update connection string

3. Update connection string

Press the ’Update connection string’ button. The connection strings assigned to the selected environment will be added to every configuration file that belongs to that environment.

The connection strings will be added to the following configuration files:

  • Produmex Tools configuration
  • Produmex License Server Configuration
  • Produmex ScaleComm Configuration
  • Produmex Fat Client Configuration

Please note: Already added connection strings will not be removed from the configuration files.

4. Run database upgrade

Run the database upgrade on the new database.

On the tab of the server select the ‘Produmex Tools’ component and click on the ‘Config’ button. On the opening Produmex Tools form select the new database and click on the ‘Run’ button.

For more information please see: 3.2.1. Produmex tools configuration

5. Adjust stored procedures

For more information about enabling the stored procedures please see: Adaptation of stored procedures

It’s important to check if the references between the company database/schema and the Produmex database/schema are set correctly and are pointing to the right database.

Check the following stored procedures:

  • SBO_SP_TransactionNotification/SBO_SP_TRANSACTIONNOTIFICATION
  • PMX_SP_TransactionNotification/PMX_SP_TRANSACTIONNOTIFICATION
  • additional stored procedures if the customization requires their modification

If you are using SAP HANA, also check the references in the following stored procedures:

  • PMX_SP_TRANSACTIONNOTIFICATIONCHECKS
  • PMX_SP_TRANSACTIONNOTIFICATIONSTOCK

6. Assign Add-on Loader

Make sure that the Add-On Loader is assigned to the new company database.

Admin Detach Close

This topic does not exist yet

You've followed a link to a topic that doesn't exist yet. If permissions allow, you may create it by clicking on Create this page.