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:20]
runger 		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 ======
  
-  * [[bizweaver application overview|Bizweaver Application Overview]]+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]]//**.
  
-====== Execute a Workflow ====== +===== Workflow Tools =====
- +
-There are three methods to execute a Bizweaver workflow: test/debug mode, “run now,” and scheduled. The results are the same for all methods. +
- +
-===== Test/Debug Mode ===== +
- +
-The Bizweaver **Test Run Tool** allows a developer to execute a workflow in a step-by-step manner. Variable values can be examined at each step to confirm that they are what is expected. More information on this tool is found **//[[bw:test_run_tool|here]]//**. +
- +
-===== Run Now ===== +
- +
-The “Run Now” option is used to execute a workflow while in Bizweaver. There are two ways to use this option. +
- +
-First, the currently active workflow can be executed by clicking the “Run now” link as shown below. +
- +
-{{:bw:introimage13.png?300x29}} +
- +
-Second, right-click on any workflow in the Workflow List area, and select the “Run now” option. +
- +
-In both cases, the workflow is executed immediately. No feedback is provided while the workflow is executing (as seen in the Test Run tool). +
- +
-==== Run Now Log ==== +
- +
-At the end of the execution a “Task Execution Status” window is automatically displayed showing the log information for the workflow. +
- +
-{{:bw:introimage14.png?576x377}} +
- +
-In general, you will only need to scan the log records for information in the “Message” column. These will typically be error messages that may need attention. +
- +
-Click on the //Open Log File// link to open a text file of log information. This file will have more technical information and can be saved for further review. +
- +
-Click the [**Close & Delete Log Records**] button to delete the log information from the Bizweaver logging table, and close the window. +
- +
-Click the [**Close**] button to close the window. An additional dialog will allow you to delete the log records here as well. +
- +
-Note that the log records can be retained if desired. This can be helpful if you are doing reporting from the Bizweaver log table. See **//[[bw:application_introduction#appendix_c_bizweaver_activity_logging|Appendix C – Activity Logging]]//** for more information. +
- +
-===== Scheduled Execution ===== +
- +
-Bizweaver workflows can be automatically executed based on a schedule. This is the most common, and most efficient, way to execute workflows. See **//[[bw:workflow_schedules|Workflow Schedules]]//** for more information. +
- +
-====== Workflow Variables ====== +
- +
-“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**. +
- +
-**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]] +Follow the below link to find a detailed list of all the tools that are used with in Bizweaver. 
-  * [[SAP Business One Integration for HANA Databases]]+
  
-=====Additional Technical Information=====+Discussions of the various tools used to build a workflow are found **//[[bw:workflow_tools|here]]//**
  
-  * [[Call Bizweaver Web Service from SQL Server]]+===== Executing a Workflow =====
  
-  * [[Import Export Tool|Import/Export Tool]] +Follow the below link to read further on Executing a Workflow.
-      * [[Moving from Test to Production]]+
  
-  * [[FTP and Bizweaver]]+Details for executing a workflow are found **//[[bw:executing_a_workflow|here]]//**.
  
-  * [[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.1571077248.txt.gz · Last modified: 2019/10/14 14:20 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