Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Introduction (File Operations) • Introduction (Admin Console) • Introduction (Database Connections)
versago:database_connection_configuration

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
versago:database_connection_configuration [2019/08/26 13:14]
runger [Related Documents] 		versago:database_connection_configuration [2020/09/08 09:21] (current)
Line 2: Line 2:
  
 This document describes the steps to create database connections to allow Versago to retrieve information for reporting and save information captured in Versago forms. This document describes the steps to create database connections to allow Versago to retrieve information for reporting and save information captured in Versago forms.
- 
-====== Audience ====== 
- 
-This document is intended for Versago administrators. End-users do not have access to this function. 
- 
-====== Related Documents ====== 
- 
-The following documents contain additional information that may be helpful with understanding these processes. 
- 
-  * [[versago:report_configuration|Report Configuration Guide]] 
  
 ====== Special Terminology ====== ====== Special Terminology ======
Line 26: Line 16:
     - Best practice indicates that this should not be the default “super-user” (sa for SQL Server). A specific user that can both read and write to the various databases should be created. This same user can be used for Bizweaver as well.     - Best practice indicates that this should not be the default “super-user” (sa for SQL Server). A specific user that can both read and write to the various databases should be created. This same user can be used for Bizweaver as well.
   - A valid SAP Business One user and password **if** you plan to use SAP Business One Saved Queries as a data source.   - A valid SAP Business One user and password **if** you plan to use SAP Business One Saved Queries as a data source.
- 
-====== To Begin ====== 
- 
-This document is intended for Versago administrators. End-users do not have access to this function. 
- 
-  * Click on the Admin link in the profile section of the Versago home page to access the Administration console. 
-  * Database connections are found under the Settings category of the menu. 
  
 ====== Database Setup ====== ====== Database Setup ======
Line 46: Line 29:
       * This is the database that will be used for Versago forms.       * This is the database that will be used for Versago forms.
       * It may also be used for other Versago-related tables such as data consolidation & summarization for reporting.       * It may also be used for other Versago-related tables such as data consolidation & summarization for reporting.
-      * It may also be used for intermediate processing tables used by Bizweaver (the associated Third Wave data integration tool).+      * It may also be used for intermediate processing tables used by **Bizweaver** (the associated Third Wave data integration tool).
       * Check with your administrator for the proper database name.       * Check with your administrator for the proper database name.
   * Versago Common   * Versago Common
Line 57: Line 40:
   * Click on the “Database Setup” link in the Admin console to begin.   * Click on the “Database Setup” link in the Admin console to begin.
  
-{{:versago:dbconfig1.png?800|}}+{{  :versago:dbconfig1.png?800  |}}
  
 The database connection maintenance tool consists of two functions: creation of new connections and maintenance of existing connections. The database connection maintenance tool consists of two functions: creation of new connections and maintenance of existing connections.
Line 73: Line 56:
 Values marked with * are required. All values can be changed at any time unless noted otherwise. Values marked with * are required. All values can be changed at any time unless noted otherwise.
  
-{{:versago:dbconfig2.png?400|}}+{{  :versago:dbconfig2.png?400  |}}
  
   - **Company Name** is the description that the user sees when selecting a database connection in the setup process for reports and forms.   - **Company Name** is the description that the user sees when selecting a database connection in the setup process for reports and forms.
Line 94: Line 77:
       - A value in this field is required but is only significant for SQL vs. HANA. The actual SQL version is not significant.       - A value in this field is required but is only significant for SQL vs. HANA. The actual SQL version is not significant.
       - Although the field label reads “SQL Server,” access to SAP HANA databases for reporting is also supported and can be selected from the drop-down.       - Although the field label reads “SQL Server,” access to SAP HANA databases for reporting is also supported and can be selected from the drop-down.
 +
  
 ===== SAP Business One Specific Information ===== ===== SAP Business One Specific Information =====
  
-The following items are used only when the connection pertains to an SAP Business One database AND you may want to use B1 Saved Queries as a data source. See the “Versago – Report Configuration Guide” document for more information on using B1 Saved Queries.+The following items are used only when the connection pertains to an SAP Business One database AND you may want to use B1 Saved Queries as a data source. See **//[[versago:report_configuration|Report Configuration]]//** for more information on using B1 Saved Queries.
  
 +<WRAP center round info 80%>
 If you do not plan to use B1 Saved Queries as a data source these items can be left blank. If you do plan to use B1 Saved Queries, all items are required. These values can be changed at any time. If you do not plan to use B1 Saved Queries as a data source these items can be left blank. If you do plan to use B1 Saved Queries, all items are required. These values can be changed at any time.
 +</WRAP>
 +
  
   - **B1 Username** is the SAP Business One user to be used to connect to the database   - **B1 Username** is the SAP Business One user to be used to connect to the database
Line 109: Line 96:
       - The default port value is 30000. This will be different only in very specific situations. Contact your network administrator or SAP Business One Administrator if you have any questions.       - The default port value is 30000. This will be different only in very specific situations. Contact your network administrator or SAP Business One Administrator if you have any questions.
  
 +=====Updating Connection Server and Database Information=====
 +It is not currently possible to change the server and database information in a Versago connection.  This will be addressed in a future release.  If it is necessary to make this change it can be done directly using commands in SQL Server Management Studio.  Click **//[[versago:update database connection|here]]//** for instructions.
 +
 +====== Related Documents ======
 +
 +The following documents contain additional information that may be helpful with understanding these processes.
  
 +  * [[versago:update database connection|Update Database Connection]]
 +  * [[versago:database port information|Database Port Information]]
versago/database_connection_configuration.1566839699.txt.gz · Last modified: 2019/08/26 13:14 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