bw:sqlws_config
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
bw:sqlws_config [2019/09/11 11:44] runger [Create Assembly] |
bw:sqlws_config [2020/04/07 15:23] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ======Configure SQL to call Bizweaver WebService===== | ======Configure SQL to call Bizweaver WebService===== | ||
| + | <WRAP center round tip 60%> | ||
| + | New in Bizweaver version 2.4 | ||
| + | </ | ||
| + | |||
| ===== Obtain the DLL executable file===== | ===== Obtain the DLL executable file===== | ||
| Line 33: | Line 37: | ||
| =====Create Assembly===== | =====Create Assembly===== | ||
| - | Create an Assembly in the Target (SAP) database | + | Create an Assembly in the **Target** (SAP or VersagoData) database |
| * Expand the folder tree for the target (SAP) database. | * Expand the folder tree for the target (SAP) database. | ||
| Line 39: | Line 43: | ||
| * Right-click on " | * Right-click on " | ||
| - | {{: | + | {{ : |
| * Browse to folder where the SQLWSCall.dll is located and select it. | * Browse to folder where the SQLWSCall.dll is located and select it. | ||
| * This will be the same folder as in the previous steps. | * This will be the same folder as in the previous steps. | ||
| * The Assembly Name and Assembly Owner are set automatically. | * The Assembly Name and Assembly Owner are set automatically. | ||
| - | * Select "Unrestricted" from the drop-down for " | + | * Select "External Access" from the drop-down for " |
| * Click [OK] to register the assembly. | * Click [OK] to register the assembly. | ||
| =====Create Control Procedure===== | =====Create Control Procedure===== | ||
| - | Create the following stored procedure in the target (SAP) database | + | Create the following stored procedure in the target (SAP) database. |
| <code sql> | <code sql> | ||
| CREATE PROCEDURE [dbo].[spCallBizweaverWS] | CREATE PROCEDURE [dbo].[spCallBizweaverWS] | ||
| - | @wsMethod NVARCHAR (MAX), @wsUrl NVARCHAR (MAX), @wsPort NVARCHAR (MAX), @wsContent NVARCHAR (MAX), @wsAuthToken NVARCHAR (MAX), @wsTaskId INT, @wsStartAfter INT, @wsParameters NVARCHAR (MAX) | + | @wsMethod NVARCHAR (MAX), |
| + | @wsUrl NVARCHAR (MAX), | ||
| + | @wsPort NVARCHAR (MAX), | ||
| + | @wsContent NVARCHAR (MAX), | ||
| + | @wsAuthToken NVARCHAR (MAX), | ||
| + | @wsTaskId INT, | ||
| + | @wsStartAfter INT, | ||
| + | @wsParameters NVARCHAR (MAX) | ||
| AS EXTERNAL NAME [SQLWSCall].[StoredProcedures].[spCallBizweaverWS] | AS EXTERNAL NAME [SQLWSCall].[StoredProcedures].[spCallBizweaverWS] | ||
| </ | </ | ||
| + | |||
| + | <WRAP center round help 80%> | ||
| + | A sample of the configuration to call Bizweaver is found **// | ||
| + | </ | ||
| + | |||
bw/sqlws_config.1568216660.txt.gz · Last modified: 2019/09/11 11:44 by runger
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
