Open topic with navigation

Set data source properties

To set data source properties

Open: System Administration > Information Management > Data Sources.

1. Right-click the Data Source Name and choose Properties.

   The Properties window displays the General tab.

2. Enter the Data Source Name.

   You must enter this name when you add a data source. You can change the name if required.

   The name Accounts is reserved for Sage 200 Accounts and Manufacturing models, and the name CRM is reserved for the Sage 200 CRM model.

3. Enter the Connection String Settings.

• To use the information that is used to connect to the Sage 200 company, select Use Client Side Connection String.

  If you select this check box, you do not need to enter a connection string on this tab or the Companies tab.

• To set a default connection string, leave the Use Client Side Connection String box clear and enter a connection string.

  You can enter a string or generate one by clicking the browse (...) button.

• To set connection strings for individual companies, use the Companies tab.
4. Click Test Connection String to test the string is valid.
5. Click OK to confirm the General properties.

Go to top