User Tools

Site Tools


implementation:wms:install_standardstoredprocedure

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
implementation:wms:install_standardstoredprocedure [2019/09/17 13:27]
vise upgrading to 19.2
implementation:wms:install_standardstoredprocedure [2020/01/17 14:35] (current)
vise
Line 1: Line 1:
 ==== 3.4.1. Enable the standard PMX stored procedure ==== ==== 3.4.1. Enable the standard PMX stored procedure ====
 +
 +The following sections describe the process of enabling the standard PMX stored procedure with Microsoft SQL (section [[implementation:​wms:​install_standardstoredprocedure#​with_microsoft_sql_server| 3.4.1.1]]) and SAP HANA (section [[implementation:​wms:​install_standardstoredprocedure#​with_sap_hana| 3.4.1.2]]). ​
 +
 === 3.4.1.1. With Microsoft SQL Server === === 3.4.1.1. With Microsoft SQL Server ===
  
-After the configuration is done you need to enable the (custom) stored procedures in the stored procedure of SAP named “SBO_TransactionNotification”.+After the configuration is doneyou 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”+When applying the Produmex Add-on the first time to a databaseyou also need to adapt the stored procedure “SBO_SP_TransactionNotification”.
  
-1. Open SQL Server Management Studio” and connect to your database server.+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. 2. Expand the “Databases” folder and locate the database to which you want to apply the Produmex Add-on.
Line 14: Line 17:
 4. Locate the “dbo.PMX_SP_TransactionNotification” stored procedure, right-click it and select “Modify”. ​ 4. Locate the “dbo.PMX_SP_TransactionNotification” stored procedure, right-click it and select “Modify”. ​
  
-{{:​implementation:​5.1.1.png?​nolink|}}+{{:​implementation:​5.1.1.png?​nolink|Enable the standard PMX stored procedure}}
  
 5. Locate the “Produmex Logex Addon Code” at the end of this stored procedure (see illustration below) 5. Locate the “Produmex Logex Addon Code” at the end of this stored procedure (see illustration below)
    
-{{:​implementation:​5.1.2.png?​nolink|}}+{{:​implementation:​5.1.2.png?​nolink|Enable the standard PMX stored procedure}}
  
 6. Copy the “Produmex Logex Addon Code”. \\ 6. Copy the “Produmex Logex Addon Code”. \\
Line 25: Line 28:
 7. Locate the “dbo.SBO_SP_TransactionNotification” stored procedure, right-click it and select''​Modify''​. 7. Locate the “dbo.SBO_SP_TransactionNotification” stored procedure, right-click it and select''​Modify''​.
    
-{{:​implementation:​5.1.3.png?​nolink|}}+{{:​implementation:​5.1.3.png?​nolink|Enable the standard PMX stored procedure}}
  
 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”. 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”.
Line 31: Line 34:
 {{ :​implementation:​install:​boyum:​25._add_your_code_here.png |}} {{ :​implementation:​install:​boyum:​25._add_your_code_here.png |}}
  
-9. Uncomment the SP by clicking on the ''​Uncomment''​ button in SQL management studio.+9. Uncomment the SP by clicking on the ''​Uncomment''​ button in SQL Management Studio. 
 + 
 +{{:​implementation:​5.1.5.jpg?​nolink|Enable the standard PMX stored procedure}}
  
-{{:​implementation:​5.1.5.jpg?​nolink|}}+10Execute the SBO_SP_TransactionNotification stored procedure
  
-After these modificationsExecute the SBO_SP_TransactionNotification ​stored procedure.+Continue with section [[implementation:​wms:​install_standardstoredprocedure#​Enable_a_custom_stored_procedure|3.4.2. Enable a custom ​stored procedure]].
  
 === 3.4.1.2. With SAP HANA === === 3.4.1.2. With SAP HANA ===
Line 47: Line 52:
 2. Expand the “Catalog” folder and locate the schema to which you want to apply the Produmex Add-on. 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+3. Right-click on this schema and select “SQL Console” to open a new SQL console.
  
-{{:​implementation:​hanastudio5.png?​nolink|}}+{{:​implementation:​hanastudio5.png?​nolink|Enable the standard PMX stored procedure}}
  
 Keep this SQL console open during the whole process. Keep this SQL console open during the whole process.
Line 57: Line 62:
 5. Locate the “SBO_SP_TRANSACTIONNOTIFICATION” stored procedure, right-click it and select “Open Definition”. ​ 5. Locate the “SBO_SP_TRANSACTIONNOTIFICATION” stored procedure, right-click it and select “Open Definition”. ​
  
-{{:​implementation:​hanastudio3.png?​nolink|}}+{{:​implementation:​hanastudio3.png?​nolink|Enable the standard PMX stored procedure}}
  
 6. Open its content by opening the //Create Statement// tab: 6. Open its content by opening the //Create Statement// tab:
  
-{{:​implementation:​hanastudio4.png?​nolink|}}+{{:​implementation:​hanastudio4.png?​nolink|Enable the standard PMX stored procedure}}
  
 7. Copy the content into the SQL console. 7. Copy the content into the SQL console.
Line 67: Line 72:
 8. Locate the “PMX_SP_TransactionNotification” stored procedure, right-click it and select “Open Definition”. 8. Locate the “PMX_SP_TransactionNotification” stored procedure, right-click it and select “Open Definition”.
  
-{{:​implementation:​hanastudio1.png?​nolink|}}+{{:​implementation:​hanastudio1.png?​nolink|Enable the standard PMX stored procedure}}
  
 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). 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).
    
-{{ :​implementation:​install:​boyum:​26._produmex_logex_addon_code_hana.png |}}+{{ :​implementation:​install:​boyum:​26._produmex_logex_addon_code_hana.png |Enable the standard PMX stored procedure}}
  
 10. Copy the “Produmex Logex Addon Code”. 10. Copy the “Produmex Logex Addon Code”.
Line 82: Line 87:
 ''​DROP PROCEDURE SBO_SP_TransactionNotification;''​ ''​DROP PROCEDURE SBO_SP_TransactionNotification;''​
  
-Now the SQL console should look like this:+The SQL console should look like this:
  
-{{ :​implementation:​install:​boyum:​27._produmex_logex_addon_code_hana_2.png |}}+{{ :​implementation:​install:​boyum:​27._produmex_logex_addon_code_hana_2.png |Enable the standard PMX stored procedure}}
  
 14. Execute the code in your SQL console to modify the SBO_SP_TRANSACTIONNOTIFICATION procedure. 14. Execute the code in your SQL console to modify the SBO_SP_TRANSACTIONNOTIFICATION procedure.
implementation/wms/install_standardstoredprocedure.1568726868.txt.gz · Last modified: 2019/09/17 13:27 by vise