Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace:
bw:call_bizweaver_web_service_from_sql_server

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:call_bizweaver_web_service_from_sql_server [2019/12/13 11:19]
runger 		bw:call_bizweaver_web_service_from_sql_server [2020/12/18 13:25] (current)
akoehler [To Begin]
Line 1: Line 1:
-======Initial Configuration======+======SQL Configuration to Call a Bizweaver Workflow======
 <WRAP center round alert 60%> <WRAP center round alert 60%>
 The following actions should only be performed by persons familiar with SQL Server Management Studio and understand how to manipulate objects in a database. The following actions should only be performed by persons familiar with SQL Server Management Studio and understand how to manipulate objects in a database.
Line 5: Line 5:
  
 =====To Begin===== =====To Begin=====
 +<WRAP center round alert 60%>
 +The Bizweaver Web Service needs to be installed either from a Versago or Bizweaver installation to have the below file path available. If "Skip this Step" is selected during installation, the applications will need to be reinstalled to access the path.
 +</WRAP>
   * Download DLL executable from [[https://portal.twbs.com]] to the SQL Server server.  The DLL executable is also automatically placed in __C:\Program Files\Bizweaver\BWPortal__ by the Bizweaver installation.   * Download DLL executable from [[https://portal.twbs.com]] to the SQL Server server.  The DLL executable is also automatically placed in __C:\Program Files\Bizweaver\BWPortal__ by the Bizweaver installation.
  
-=====Initialization=====+=====Master Configuration=====
 <WRAP center round info 60%> <WRAP center round info 60%>
 Execute the SQL statements that follow against the **Master** database.  These steps, until the "Configure Target Database" section, MUST be performed on the server where SQL Server is located. Execute the SQL statements that follow against the **Master** database.  These steps, until the "Configure Target Database" section, MUST be performed on the server where SQL Server is located.
Line 52: Line 55:
  
 <WRAP center round info 60%> <WRAP center round info 60%>
-The remaining steps, which create & update various SQL Stored Procedures, can be done from any instance of SQL Server Management Studio that has access to the target (SAP) database.+The remaining steps, which create & update various SQL Stored Procedures, can be done from any instance of SQL Server Management Studio that has access to the target database.
 </WRAP> </WRAP>
  
-====Create a custom stored procedure in the target (SAP or VersagoData) database====+====Create a custom stored procedure in the target database====
 This procedure handles the web service call to Bizweaver.  It is used for both POST and GET transactions. This procedure handles the web service call to Bizweaver.  It is used for both POST and GET transactions.
 <code sql> <code sql>
Line 64: Line 67:
  
 ======Configuration for SAP Business One======= ======Configuration for SAP Business One=======
 +The processing of records added or updated in the SAP application can be initiated using a SQL stored procedure.
  
 <WRAP center round help 80%> <WRAP center round help 80%>
 A sample of the code used in SAP Business One to call a Bizweaver workflow is found **//[[bw:call_bizweaver_from_sql|here]]//**. A sample of the code used in SAP Business One to call a Bizweaver workflow is found **//[[bw:call_bizweaver_from_sql|here]]//**.
 +</WRAP>
 +
 +======Configuration for Automatic Versago Multi-Select Report Processing======
 +The processing of records selected in a Versago multi-select report can be initiated using a SQL database trigger.
 +
 +<WRAP center round help 80%>
 +A sample of the trigger code used to automatically initiate processing is found **//[[bw:bizweaver_multiselect_trigger|here]]//**.
 </WRAP> </WRAP>
  
Line 74: Line 85:
 <wrap em>Contact Third Wave support for assistance with this configuration</wrap> <wrap em>Contact Third Wave support for assistance with this configuration</wrap>
  
-The following video illustrates this process. 
  
-{{ :versago:versago_db_trigger_demo.mp4?800 |DB Trigger Demo}}. 
  
  
  
-======Configuration for Versago Multi-Select Report Processing====== 
-<wrap em>Contact Third Wave support for assistance with this configuration</wrap> 
  
-Create a trigger on the table where records are saved by your Versago multi-select report. 
- 
-Values in <YourValue> are specific to your installation and need to be changed accordingly.  The < and > symbols are removed when the desired value is entered. 
- 
-<code SQL Trigger.txt> 
-create TRIGGER [dbo].[twbs_tr_VersagoPayments] 
-ON [dbo].[Versago_Payments] 
-AFTER INSERT 
-AS 
-declare @vgo_Batchid nvarchar(8), @arguments nvarchar(100) 
---- 
-SELECT @vgo_BatchID = vgo_BatchID FROM inserted 
-BEGIN 
--- 
-SET @Arguments = '{"vgo_BatchID":' + '"' + @vgo_BatchID + '"' + '}' 
--- 
-EXECUTE [dbo].[spCallBizweaverWS] 
-@wsMethod='POST' 
--- add your URL.  Be sure to use http or https as appropriate. 
-,@wsURL='https:<YourURL>' 
-,@wsContent='application/json' 
--- Add your Auth Token from Bizweaver 
-,@wsAuthToken='<YourBizweaverToken>' 
--- Add your workflow ID from Bizweaver 
-,@wsTaskId='<YourWorkflowID>' 
-,@wsStartAfter='' 
-,@wsParameters= @Arguments 
--- Add your port number 
-,@wsPort='<YourPort>' 
-END 
-</code> 
  
  
bw/call_bizweaver_web_service_from_sql_server.1576253997.txt.gz ยท Last modified: 2019/12/13 11:19 by runger

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
CC Attribution-Noncommercial 4.0 International Valid HTML5 Valid CSS Driven by DokuWiki