Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • SAP Business One Service Layer using Bizweaver v2.4 • Introduction (SAP Business One Integration on SQL Server) • SAP Business One Service Layer using Bizweaver v2.5 and higher • Introduction (Record Submission) • business_partner_for_service_layer
bw:bizweaver

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:bizweaver [2019/10/14 14:32]
runger [Building a Workflow] 		bw:bizweaver [2022/01/26 11:49] (current)
akoehler [Bizweaver Tips]
Line 4: Line 4:
 The Bizweaver application is set of tools used to automate data acquisition, data manipulation, file management activities, as-well-as providing data integration into SAP Business One.  The various tools provided by Bizweaver are linked together as a set of sequential steps called a workflow. The Bizweaver application is set of tools used to automate data acquisition, data manipulation, file management activities, as-well-as providing data integration into SAP Business One.  The various tools provided by Bizweaver are linked together as a set of sequential steps called a workflow.
  
 +<WRAP round tip 70%>
 +For helpful videos on Bizweaver please check the [[https://www.youtube.com/channel/UC-Titg9AuQOGVmfYhOVoRkg|Third Wave YouTube Channel]].
 +</WRAP>
 ====== Audience ====== ====== Audience ======
  
-This Wiki section is intended for developers of Bizweaver workflows.  Knowledge of standard SQL (Microsoft T-SQL) statements is required.+This Wiki section is intended for system administrators and developers of Bizweaver workflows.  End users should not typically have direct access to the Bizweaver application.
  
 ======Environment and Installation & Upgrade Information====== ======Environment and Installation & Upgrade Information======
-  * [[Bizweaver Environment Requirements|Bizweaver Environment Requirements]] 
-  * [[Installation and Upgrade Instructions]] 
  
-======End User Help====== +Information regarding Bizweaver environment requirements, as well as installation and upgrade information is found using the following links. 
-  * [[User Help and Tips|User Help and Tips]]+ 
 +  * **[[Bizweaver Environment Requirements|Bizweaver Environment Requirements]]** 
 +  * **[[Installation and Upgrade Instructions]]**
  
 ====== Bizweaver Application Overview ====== ====== Bizweaver Application Overview ======
  
 An overview of the Bizweaver application can be found **//[[bizweaver application overview|here]]//**. An overview of the Bizweaver application can be found **//[[bizweaver application overview|here]]//**.
 +
 +====== Key Configuration Functions ======
 +
 +  * **//[[bw:bizweaver_general_settings|General Settings for Bizweaver]]//**
 +  * **//[[bw:global_connections|Global Connections]]//**
  
 ====== Building a Workflow ====== ====== Building a Workflow ======
Line 25: Line 33:
 Details for building a workflow are found **//[[bw:building_a_workflow|here]]//**. Details for building a workflow are found **//[[bw:building_a_workflow|here]]//**.
  
-Discussions of the various tools used to build a workflow are found **//[[bw:workflow_tools|here]]//**+===== Workflow Tools =====
  
-====== Executing a Workflow ======+Follow the below link to find a detailed list of all the tools that are used with in Bizweaver. 
  
-Details for executing a workflow are found **//[[bw:executing_a_workflow|here]]//**.+Discussions of the various tools used to build a workflow are found **//[[bw:workflow_tools|here]]//**
  
 +===== Executing a Workflow =====
  
-====== Workflow Variables ======+Follow the below link to read further on Executing a Workflow.
  
-“Variables” are data values that are held in memory during the execution of a workflow. There are two types of variables in Bizweaver: **User Variables** and **Step Variables**. +Details for executing a workflow are found **//[[bw:executing_a_workflow|here]]//**.
- +
-**User Variables** are defined by the user. These values can be defined in the Variables tool or they can be created using the **//[[bw:vbscript_tool|VBScript]]//** tool. +
- +
-**Step Variables** are special references created by the Bizweaver application. Most Bizweaver workflow tools create these variables as the step is executed. An example of this would be a reference to an output column from a SQL Command: Reader step. +
- +
-Bizweaver variables are available to other workflow steps that follow the step where they are created. +
- +
-More information is found on the **//[[bw:using_variables|Using Variables]]//** page. +
- +
-====== Bizweaver Activity Logging ====== +
- +
-As noted earlier in this document, actions from the Test Run tool are logged in text files. However, when a schedule executes a workflow, or using the “Run now” option, step information is logged to the SQL database used by Bizweaver. +
- +
-Transaction logging data is found in the table **VGO_SYNC_PROC_LOG**. An entry is made for each workflow step that is executed. In addition to workflow and step information, any errors reported from Bizweaver steps is recorded. This provides a mechanism for reporting execution issues. +
- +
-The log table can be accessed via SQL Management Studio or from a report in Versago. Following is a SQL Select statement to access this information. +
- +
-<code sql> +
-select +
- +
-t0.JobID, t0.TaskID, t1.TaskName, t0.StepType, t0.Step, t0.[Time], t0.Message +
- +
-from vgo_sync_proc_log t0 +
- +
-inner join VGO_SYNC_TASKS t1 on t0.TaskID = t1.TaskID +
-</code> +
-The log information for a specific workflow can also be accessed using the “View Job Log” function described in the “Icon Bar” section of this document. +
- +
- +
- +
-=====General Information===== +
-  * [[Global Connections]] +
-  * [[Error Handling]] +
-  * [[Using Variables]] +
- +
-=====Tools===== +
- +
-  * [[SQL Command Tool]] +
-  * [[Looping Tool]] +
-  * [[File Operations Tool]] +
-  * [[File Reader Tool]] +
-  * [[File Writer Tool]] +
-  * [[Decision Tool]] +
-  * [[Email Tool]] +
-  * [[VBScript Tool]] +
-  * [[Crystal Reports Tool]] +
-  * [[Pause Tool]] +
-  * [[Web Service Tool]] +
-  * [[DataBuilder Tool]] +
-  * [[ExchangeConnector Tool]] +
-  * [[External Application Execution Tool]] +
- +
-  * [[SAP Business One Integration for SQL Server Databases]] +
-  * [[SAP Business One Integration for HANA Databases]] +
- +
-=====Additional Technical Information===== +
- +
-  * [[Call Bizweaver Web Service from SQL Server]] +
- +
-  * [[Import Export Tool|Import/Export Tool]] +
-      * [[Moving from Test to Production]] +
- +
-  * [[FTP and Bizweaver]]+
  
-  * [[HANA SQL Tips]] +===== Renaming Bizweaver Databases =====
-  * [[SQL Server Tips]]+
  
 +Follow the below link to read further on renaming Bizweaver databases
  
 +Details for renaming Bizweaver databases are found **//[[renaming_bizweaver_databases|here]]//**.
  
 +===== Bizweaver Tips =====
 +Follow the below link to read further on Bizweaver tips
  
 +Details for Bizweaver tips **//[[bw2:bizweaver_tips|here]]//**.
  
 +===== Bizweaver Template =====
 +Follow the below link to read further on the Versago Bizweaver Template
  
 +Details for the Versago Bizweaver Template **//[[versago:template|here]]//**.
  
  
    
bw/bizweaver.1571077925.txt.gz · Last modified: 2019/10/14 14:32 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