Use the Connection Designer screen to configure access to different databases within your organization.
Creating a New Connection
- Access the Vision Main Menu.
- Click the Tools / Settings drop-down.
- Select the Manage Data Models / Connections option.
- Click Manage Connections.
- Click New Connection.
- Specify a Name of the connection. For example: ERP
- Select a Type option. For example: Microsoft SQL Server
- Specify a Connection String.
Connection String sample formats are available here:- SQL Server: http://www.connectionstrings.com/sql-server/
- Access: http://www.connectionstrings.com/access/
- Progress: http://www.connectionstrings.com/progress/
- Others: http://www.connectionstrings.com/ (Not all options are supported; please contact Customer Support for assistance)
- Click Save & Close.