Connections

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

Open

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. Open

         

1. Click Save & Close.