bizweaver:exec_sql
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
bizweaver:exec_sql [2024/09/09 13:43] dlee created |
bizweaver:exec_sql [2024/09/09 14:35] (current) dlee [Create Control Procedure] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ======Called from SQL===== | ======Called from SQL===== | ||
| + | A dynamic link library (SQLWSCall.dll) provided by Third Wave Business Systems is required for this functionality to work. The file is installed in C:\Program Files\Bizweaver\BWPortal\BWSQLSP when Bizweaver is installed. | ||
| - | ===== Obtain the DLL executable file===== | + | =====Initialize |
| - | * The file is installed in C:\Program Files\Bizweaver\BWPortal\BWSQLSP when Bizweaver is installed. | + | |
| - | * The file can be downloaded from https:// | + | |
| - | + | ||
| - | =====Initialize | + | |
| Execute the following SQL statements against the **Master** database | Execute the following SQL statements against the **Master** database | ||
| Line 34: | Line 31: | ||
| =====Create Assembly===== | =====Create Assembly===== | ||
| - | Create an Assembly in the **Target** (SAP or VersagoData) | + | Create an Assembly in the **calling** database |
| - | * Expand | + | * In MS SQL Management Studio, expand |
| * Expand the " | * Expand the " | ||
| * Right-click on " | * Right-click on " | ||
| Line 43: | Line 40: | ||
| * 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. | ||
| * The Assembly Name and Assembly Owner are set automatically. | * The Assembly Name and Assembly Owner are set automatically. | ||
| * Select " | * Select " | ||
| Line 50: | Line 46: | ||
| =====Create Control Procedure===== | =====Create Control Procedure===== | ||
| - | Create the following stored procedure in the target (SAP) database. | + | Create the following stored procedure in the calling |
| <code sql> | <code sql> | ||
| Line 65: | Line 61: | ||
| </ | </ | ||
| - | <WRAP center round help 80%> | + | * @wsMethod: POST |
| - | A sample of the configuration | + | * @wsUrl: |
| - | </WRAP> | + | |
| + | | ||
| + | * @wsAuthToken: token generated in Bizweaver' | ||
| + | * @wsTaskId: workflow id | ||
| + | * @wsStartAfter: | ||
| + | * @wsParameters: | ||
| + | * Example: the variable name in the Bizweaver workflow is vgo_BatchID (case sensitive) | ||
| + | <code sql> | ||
| + | SET @wsParameters = ' | ||
| + | </ | ||
| + | |||
| + | |||
| + | |||
| + | =====Calling Bizweaver Using spCallBizweaverWS==== | ||
| + | <code sql> | ||
| + | |||
| + | DECLARE @Arguments NVARCHAR(MAX) | ||
| + | SET @Arguments = ' | ||
| + | |||
| + | EXECUTE [dbo].[spCallBizweaverWS] | ||
| + | @wsMethod=' | ||
| + | , | ||
| + | , | ||
| + | , | ||
| + | , | ||
| + | , | ||
| + | , | ||
| + | , | ||
| + | |||
| + | END | ||
| + | </code> | ||
| ---- | ---- | ||
| **[[bizweaver: | **[[bizweaver: | ||
bizweaver/exec_sql.1725903795.txt.gz · Last modified: 2024/09/09 13:43 by dlee
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
