Wiki

Scale Your Enterprise

User Tools

Site Tools


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 [2020/08/12 09:20]
dlee
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]] 
-  * [[versago:update database connection|Update Database Connection]] 
-  * [[versago:database port information|Database Port Information]] 
  
 ====== Special Terminology ====== ====== Special Terminology ======
Line 28: 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 102: Line 83:
 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. 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 100%>+<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> </WRAP>
Line 118: Line 99:
 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. 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.1597238405.txt.gz · Last modified: 2020/08/12 09:20 by dlee