5. Adding a New Database to an Existing Installation

This section describes the steps of adding a new database to an existing installation.

1. Start the Produmex Suite Installer and go to the General tab.

2. Click on the green + button and set the connection details (see section 3.1.1. General tab).

3. Test the SBO and the direct connection by clicking on the …test… buttons.

4. Go to the tab of the server you want to connect the database to.

5. Click the Update Connection String button.

The connection strings assigned to the selected environment are added to every configuration file that belongs to that environment.

Note:

• Passwords provided in the connection string is encrypted.
• Already added connection strings are not removed from the configuration files.

6. Click on the Config button of the Produmex Tools and run the Produmex Database Upgrade tool on the new database (see section 3.3.1. Configuring the Produmex Tools).

7. Adjust stored procedures (see section 3.4. Adaptation of stored procedures).

8. 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

9. Check if the Add-On Loader is assigned to the new company database.