Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • SQL Configuration to Call a Bizweaver Workflow
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:26]
runger [Create a custom stored procedure in the target (SAP or VersagoData) database] 		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>
  
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%>
Line 69: Line 73:
 </WRAP> </WRAP>
  
-======Configuration for Versago Multi-Select Report Processing====== +======Configuration for Automatic Versago Multi-Select Report Processing====== 
-<wrap em>Contact Third Wave support for assistance with this configuration</wrap>+The processing of records selected in a Versago multi-select report can be initiated using a SQL database trigger.
  
-Create a trigger on the table where records are saved by your Versago multi-select report. +<WRAP center round help 80%> 
- +A sample of the trigger code used to automatically initiate processing is found **//[[bw:bizweaver_multiselect_trigger|here]]//**. 
-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. +</WRAP>
- +
-<code SQL Trigger.txt> +
-create TRIGGER [dbo].[twbs_tr_<TriggerName>] +
-ON [dbo].[<TableName] +
-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> +
- +
-The following video illustrates this process. +
- +
-{{ :versago:versago_db_trigger_demo.mp4?800 |DB Trigger Demo}}.+
  
  
bw/call_bizweaver_web_service_from_sql_server.1576254408.txt.gz · Last modified: 2019/12/13 11:26 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