Sage 50 Accounting Intelligence Reporting Tip of the Month:

Sage Intelligence Connector: Adding New Connections

A Data Connection holds the relevant connection information to connect to a supported ODBC or OLEDB compliant data source. This data connection object is then used for all connections to this data source. By adding a data connection, the Connector can make data available from this data source.

To add a new data connection, double-click on the Enterprise object and select the relevant connection type (driver) to use for the connection, by clicking on it in the object window. Right-click and select Add Connection.  In the Connection Name field, type the name of your connection.

Note: Depending on the type of the connection being created, certain values will need to be entered to specify how the data is accessed (some connection types will allow you to browse for data using the buttons to the right of the text boxes). Where paths or folder names are required for creating a Data Connection, always use the Universal Naming Convention as opposed to using drive mappings. For example \\Servername\c\mydata\ as opposed to X:\mydata where X is a mapped drive to \\Servername\c\. This will ensure that reports against this Data Connection can be run from any workstation regardless of drive mappings.
1.    In the Server box, browse to or add your server name.
2.    In the Database Name box, enter the name of your Database.
3.    In the User Id: text field, type your user ID if you have security settings on the data folder.
4.    In the Password text field, type your password for the above entered user ID.
5.    Click Add. The new Connection will now appear in the Object window.
6.    To test the Connection, right-click the Connection, select the Check/Test.

Leave a reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s