Differences

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

--- bw:global_connections [2020/06/17 13:15]
runger [HANA Connections] - update for v2.5
+++ bw:global_connections [2021/05/10 14:21] (current)
akoehler [SAP Service Layer Connections]
@@ Line 69: / Line 69: @@
 ===== HANA Connections =====
-HANA connections are used to connect Bizweaver to SAP HANA databases.  These connections are typically used to __read_ data only, although insert/update/delete can be accomplished as well.
+HANA connections are used to connect Bizweaver to SAP HANA databases.  These connections are typically used to __read__ data only, although insert/update/delete can be accomplished as well.
 In Bizweaver v2.5 there are two options available: Single container (single tenant) and Multi Container (multi-tenant). The setup is very similar for both, and each one is illustrated below.
-{{  :bw:gcimage4.png?400  }}
+====Single Tenant====
+{{ :bw:hana_db_connection_single.png?400 |HANA single tenant}}
+  * Enter the **Server name** to which you are connecting.
+    * This will typically be a server/IP address & port number.
+    * The standard port number for HANA single tenant databases is **30015**.
+    * The server and port are separated by a colon ( : ).
+  * Select the //Single Container// **mode**.
+  * Enter the **HANA Username** and **Password** to access the HANA database.
+    * Creating a database user specifically for Bizweaver connections is recommended (although it is not required) as it can aid in troubleshooting connection issues.
+  * Enter the name of the **Database** to which you are connecting.
+  * Enter the **HANA Timeout** period
+    * The value is expressed in seconds.
+    * The default value of 30 is appropriate for most installations.
+      * This value is set on each database connection, so it can be different for each database if needed. The timeout value is used when the workflow is executed on a schedule or using the “Run now” option.
+    * Increase the value if you see connection timeouts occurring in HANA logs.
+====Multi-Tenant====
+{{ :bw:hana_db_connection_multi.png?400 |HANA multi-tenant}}
   * Enter the **Server name** to which you are connecting.
     * This will typically be a server/IP address & port number.
-    * The standard port number for HANA databases is 30015.
+    * The standard port number for HANA multi-tenant databases is **30013**.
+    * The server and port are separated by a colon ( : ).
+  * Select the //Multiple Containers// **mode**.
+  * Enter the **Tenant Database** name.
+  * Enter the **HANA Username** and **Password** to access the HANA database.
+    * Creating a database user specifically for Bizweaver connections is recommended (although it is not required) as it can aid in troubleshooting connection issues.
   * Enter the name of the **Database** to which you are connecting.
-  * Enter the **HANA Username** and **Password** to access the SQL Server database.
-    * Creating a HANA user specifically for Bizweaver connections is recommended (although it is not required) as it can aid in troubleshooting connection issues.
   * Enter the **HANA Timeout** period
     * The value is expressed in seconds.
     * The default value of 30 is appropriate for most installations.
       * This value is set on each database connection, so it can be different for each database if needed. The timeout value is used when the workflow is executed on a schedule or using the “Run now” option.
-    * Increase the value if you see SQL timeouts occurring in HANA logs.
+    * Increase the value if you see connection timeouts occurring in HANA logs.
 ===== DI Server Connections =====
@@ Line 232: / Line 255: @@
 </code>
   - **Database** is the SAP Business One company database name.  This value is case sensitive.
-  - **Username** and **Password** are the credentials that will be used to "login" to SAP Business One.  This user should be identified as a "superuser" and should have either a Professional or Indirect Access user license.
+  - **Username** and **Password** are the credentials that will be used to "login" to SAP Business One.  This user should be identified as a "superuser" and should have either a Professional or Indirect Access user license. <WRAP info round center> If  single sign-on user is used to sign in to the service layer an extra backslash is needed to pass it through the Service Layer ex: domain\\user </WRAP>
   - The connection information is saved but is not validated. Any connection errors will only be shown when the connection is used in a workflow.

Wiki

User Tools

Site Tools

Differences

Page Tools