The following sections describe the process of enabling the standard PMX stored procedure with Microsoft SQL (section 3.4.1.1) and SAP HANA (section 3.4.1.2).

After the configuration is done, you need to enable the (custom) stored procedures in the stored procedure of SAP named “SBO_TransactionNotification”.

When applying the Produmex Add-on the first time to a database, you also need to adapt the stored procedure “SBO_SP_TransactionNotification”.

1. Open SQL Server Management Studio and connect to your database server.

2. Expand the Databases folder and locate the database to which you want to apply the Produmex Add-on.

3. Open this database directory and open the “Programmability\Stored Procedures” subdirectory.

4. Locate the “dbo.PMX_SP_TransactionNotification” stored procedure, right-click it and select “Modify”.

5. Locate the “Produmex Logex Addon Code” at the end of this stored procedure (see illustration below)

6. Copy the “Produmex Logex Addon Code”.
Now paste the code into the “dbo.SBO_SP_TransactionNotification” stored procedure as follows.

7. Locate the “dbo.SBO_SP_TransactionNotification” stored procedure, right-click it and selectModify.

8. Paste the “Produmex Logex Addon Code” at the end of it. With a new installation you will see a marked area like “– ADD YOUR CODE HERE”.

9. Uncomment the SP by clicking on the Uncomment button in SQL Management Studio.

10. Execute the SBO_SP_TransactionNotification stored procedure.

Continue with section 3.4.2. Enable a custom stored procedure.

After the configuration is done you need to enable the (custom) stored procedures in the stored procedure of SAP named “SBO_TRANSACTIONNOTIFICATION”.

When applying the Produmex Add-on the first time to a database you will also need to adapt the stored procedure “SBO_SP_TRANSACTIONNOTIFICATION”

1. Open the SAP HANA Studio and connect to your SAP HANA server.

2. Expand the “Catalog” folder and locate the schema to which you want to apply the Produmex Add-on.

3. Right-click on this schema and select “SQL Console” to open a new SQL console.

Keep this SQL console open during the whole process.

4. Expand the schema directory and open the “Procedures” subdirectory.

5. Locate the “SBO_SP_TRANSACTIONNOTIFICATION” stored procedure, right-click it and select “Open Definition”.

6. Open its content by opening the Create Statement tab:

7. Copy the content into the SQL console.

8. Locate the “PMX_SP_TransactionNotification” stored procedure, right-click it and select “Open Definition”.

9. Open its content by opening the Create Statement tab, and locate the “Produmex Logex Addon Code” at the end of this stored procedure (see illustration below).

10. Copy the “Produmex Logex Addon Code”.

11. This code should now be pasted into the SQL console, where you have already pasted the content of the “SBO_SP_TRANSACTIONNOTIFICATION” stored procedure. Paste the “Produmex Logex Addon Code” at the end of it. With a new installation you will see a marked area like “– ADD YOUR CODE HERE”.

12. Uncomment the copied code by removing the leading '–' from each line.

13. Add the following line on the top of your SQL console:
DROP PROCEDURE SBO_SP_TransactionNotification;

The SQL console should look like this:

14. Execute the code in your SQL console to modify the SBO_SP_TRANSACTIONNOTIFICATION procedure.