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 select and select Add Connection.
In the Connection Name field, type the name of your connection.
NOTE: Depending on the connection 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 \Servernamecmydata as opposed to X:mydata where X is a mapped drive to \Servernamec. This will ensure that reports against this Data Connection can be run from any workstation regardless of drive mappings.
- In the Server box, browse to or add your server name
- In the Database Name box, enter the name of your Database
- In the User Id: text field, type your User Id: if you have security settings on the data folder
- In the Password text field, type your password for the above entered User Id
- Click on Add. The new Connection will now appear in the Object window
- To test the Connection, right select on the Connection, select the Check/Test
- 7. Once you have done a Check/Test on the Connection you can now add the Containers to the Connection
