Page Comparison

Use the Connection Designer screen to configure access to different databases within your organization.

Image Added

Creating a New Connection

1. Access the Vision Main Menu.
    
2. Click the Tools / Settings  drop-down.
   
   
3. Select the Manage Data Models / Connections option.
   
   
4.  Click Manage Connections.
   
   
5.  Click New Connection.
   
   
6.  Specify a Name of the connection. For example: ERP
   
   
7.  Select a Type option. For example: Microsoft SQL Server
   
   
8. Specify a Connection String.
   1. Connection String sample formats are available here:
      1. SQL Server: http://www.connectionstrings.com/sql-server/
      2. Access: http://www.connectionstrings.com/access/ 
      3. Progress: http://www.connectionstrings.com/progress/
      4. Others: http://www.connectionstrings.com/ (Not all options are supported; please contact Customer Support for assistance)
   2. For configuring Connection String Timeouts:
      1. Connection String Timeouts determine how long a query can run before it is cancelled. This is to prevent long queries from taking up valuable processing time on the database.
      2. These are configured in seconds, so a Connection Timeout=300 will cancel any query after 5 minutes. (300/60). 
      3. When running reports that may take longer than the default timeout, the execution will fail. Adding a Connection Timeout = 0 to the string will prevent this.
      4. Image Added

1. Click Save & Close.