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:30]
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>
  
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====== 
 +The processing of records selected in a Versago multi-select report can be initiated using a SQL database trigger.
  
 <WRAP center round help 80%> <WRAP center round help 80%>
-A sample of the trigger code used in a VersagoData table is found **//[[bw:bizweaver_multiselect_trigger|here]]//**.+A sample of the trigger code used to automatically initiate processing is found **//[[bw:bizweaver_multiselect_trigger|here]]//**.
 </WRAP> </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_<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.1576254650.txt.gz · Last modified: 2019/12/13 11:30 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