Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Setup • Versago & Bizweaver Templates • Supported Browser Platforms • sap_business_one_integration_for_sql_server_databases • Introduction (Email) • Introduction to Error Handling • TWBS CC Web Order Import Integration Information • Introduction (Bizweaver) • Report Data Source Types
bizweaver:sql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision 		Previous revision
bizweaver:sql [2024/09/24 14:58]
dlee created 		bizweaver:sql [2024/09/24 15:37] (current)
dlee [SQL Tips]
Line 1: Line 1:
 ====== SQL/HANA Tool ====== ====== SQL/HANA Tool ======
  
- 
-===== Connection Types ===== 
  
 SQL Server versions 2008 and higher are supported as well as SAP HANA databases. The SQL connection setup process is described in the **//[[:bizweaver/connections|Connection Manager]]//** section. SQL Server versions 2008 and higher are supported as well as SAP HANA databases. The SQL connection setup process is described in the **//[[:bizweaver/connections|Connection Manager]]//** section.
Line 11: Line 9:
  
   - **Connection** Sets a connection to a database is selected from the drop-down list.   - **Connection** Sets a connection to a database is selected from the drop-down list.
-      - The SQL Command tool uses a previously defined SQL/HANA connection to connect to the desired database.+      * The SQL Command tool uses a previously defined SQL/HANA connection to connect to the desired database.
   - **Command Type** selected from the drop-down list.   - **Command Type** selected from the drop-down list.
-      - See the “**//[[bw2:sql_command_tool#Command Types|SQL Command Types]]//**” section below for more information.+      * See the //Command Types// section below for more information.
   - **SQL Command** Enter a SQL statement in this area.   - **SQL Command** Enter a SQL statement in this area.
  
-====== Command Types ====== +===== Command Types =====
- +
-===== SQL Server =====+
  
 Four SQL Server command types are supported: Four SQL Server command types are supported:
  
-  * **//[[bw2:sql_command_tool#Reader (SQL Server and HANA)|Reader]]//** +  * **Reader (SQL Server and HANA)** 
-  * **//[[bw2:sql_command_tool#Non-Query (SQL Server only)|Non-Query]]//** +  * **Non-Query (SQL Server only)** 
-  * **//[[bw2:sql_command_tool#Post Execution Query (SQL Server only)|Post Execution Query]]//** +  * **Post Execution Query (SQL Server only)** 
-  * **//[[bw2:sql_command_tool#Stored Procedure (SQL Server only)|Stored Procedure]]//**   +  * **Stored Procedure (SQL Server only)**  
- +
-===== HANA =====+
  
 Only the **Reader** function is supported for HANA databases at this time. Only the **Reader** function is supported for HANA databases at this time.
Line 71: Line 65:
  
  
-{{ :bw2:bizweaversqltool2.png |}} 
  
 =====Stored Procedure (SQL Server only) ===== =====Stored Procedure (SQL Server only) =====
Line 86: Line 79:
  
  
-====== User Notes ======+===== User Notes =====
  
   - Any “calculated” value in a SQL statement must have an alias assigned for it to be available in Bizweaver. This applies to numeric calculations, concatenated text values, CASE values, and any other instance where the value is not a column name in a table. Standard syntax rules apply for assigning alias names.   - Any “calculated” value in a SQL statement must have an alias assigned for it to be available in Bizweaver. This applies to numeric calculations, concatenated text values, CASE values, and any other instance where the value is not a column name in a table. Standard syntax rules apply for assigning alias names.
Line 94: Line 87:
  <code>'WorkFlow(GetData).Get({FIELD_ItemCode})'</code>  <code>'WorkFlow(GetData).Get({FIELD_ItemCode})'</code>
  
-====== SQL Test Run Option ======+===== SQL Test Run Option =====
 Bizweaver version 2.3 introduces the **Execute** option in the SQLCommand tool.  This option allows you to test SQL functions without running through the entire workflow.  It also allows you to test SQL steps where the input involves variables from previous steps.  The example here uses the following SQL statement. Bizweaver version 2.3 introduces the **Execute** option in the SQLCommand tool.  This option allows you to test SQL functions without running through the entire workflow.  It also allows you to test SQL steps where the input involves variables from previous steps.  The example here uses the following SQL statement.
  
Line 117: Line 110:
 </WRAP> </WRAP>
  
-====== SQL System Variables ======+===== SQL System Variables =====
  
 ^ Name           ^ Description         ^ ^ Name           ^ Description         ^
Line 130: Line 123:
  
  
-======SQL Tips======+=====SQL Tips=====
   * **[[bw2:sql tools|Strip HTML Tags From Input String]]**   * **[[bw2:sql tools|Strip HTML Tags From Input String]]**
  
bizweaver/sql.1727204336.txt.gz · Last modified: 2024/09/24 14:58 by dlee

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