Wiki

Scale Your Enterprise

User Tools

Site Tools


bw:sqlws_config

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
bw:sqlws_config [2019/10/07 15:33]
akoehler [Create Control Procedure]
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%> <WRAP center round tip 60%>
-New in v2.4+New in Bizweaver version 2.4
 </WRAP> </WRAP>
  
Line 37: 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 43: Line 43:
   * Right-click on "Assemblies"; select "New Assembly".   * Right-click on "Assemblies"; select "New Assembly".
  
-{{:bw:sqlws_config_assembly.png?600|SQL Assembly}}+{{  :bw:sqlws_config_assembly.png?600  |SQL Assembly}}
  
   * 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 "Permission Set".+  * Select "External Access" from the drop-down for "Permission Set".
   * Click [OK] to register the assembly.   * Click [OK] to register the assembly.
  
Line 67: Line 67:
 AS EXTERNAL NAME [SQLWSCall].[StoredProcedures].[spCallBizweaverWS] AS EXTERNAL NAME [SQLWSCall].[StoredProcedures].[spCallBizweaverWS]
 </code> </code>
 +
 +<WRAP center round help 80%>
 +A sample of the configuration to call Bizweaver is found **//[[bw:call_bizweaver_from_sql#Calling Bizweaver Using POST|here]]//**.
 +</WRAP>
 +
bw/sqlws_config.1570476817.txt.gz ยท Last modified: 2019/10/07 15:33 by akoehler