Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Introduction (Calendar Reports Configuration) • Adding and Updating Business Partner Contacts • SAP Business One Inventory Transfer with Bins • Introduction (Bizweaver) • IIS Configuration • Introduction (Record Submission) • SAP Business One Service Layer using Bizweaver v2.5 and higher • SAP Business One Enumerators • downloads • Introduction (SAP Business One Integration on SQL Server)
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:50]
runger [Environment and Installation & Upgrade Information] 		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======
Line 12: Line 15:
 Information regarding Bizweaver environment requirements, as well as installation and upgrade information is found using the following links. Information regarding Bizweaver environment requirements, as well as installation and upgrade information is found using the following links.
  
-  * [[Bizweaver Environment Requirements|Bizweaver Environment Requirements]] +  * **[[Bizweaver Environment Requirements|Bizweaver Environment Requirements]]** 
-  * [[Installation and Upgrade Instructions]] +  * **[[Installation and Upgrade Instructions]]**
- +
-======End User Help====== +
-  * [[User Help and Tips|User Help and Tips]]+
  
 ====== 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 28: 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.1571079026.txt.gz · Last modified: 2019/10/14 14:50 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