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:33]
runger [Configuration for Versago Multi-Select Report Processing] 		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%>
bw/call_bizweaver_web_service_from_sql_server.1576254831.txt.gz · Last modified: 2019/12/13 11:33 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