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.
2. Go the tab of the server
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.