Configuring ODBC DSN    - trillium_discovery - trillium_quality - 17.1

You must configure an ODBC DSN for each repository from which you want to access data on the system where you installed the Trillium ODBC Reporting Adapter.

Before you start this procedure, you must first perform the following:

1. Install the Trillium Repository Server in your environment. Create a repository.

2. Install either the 32-bit or 64-bit ODBC Reporting Adapter on the same Windows system where you plan to create ODBC DSNs.

To configure ODBC DSN data source

1. On the Trillium repository server system, open the ODBC Data Source Administrator window.

2. Click the System DSN tab.

   

3. Click Add. The Create New Data Source window opens.

4. Scroll through the list of available drivers and select TSS ODBC Reporting Adapter.

5. Click Finish. The Trillium ODBC DSN Setup window opens.

   

6. In the DSN Properties section, enter information in the following fields:

   • Data Source Name. Enter a name for the DSN you are creating. This will be the name displayed by the application when it requests a connection to the data source.

   Note: This name cannot be changed after you click OK to save these properties.

   • Description. Enter a brief description of the data source.

7. In the Connection Properties section, enter information in the following fields:

   Note: Service Name and Service Data Source fields are populated automatically and cannot be modified.

   • User name. Name of the Trillium administrator who created the repository.

   • Password. Password of the Trillium administrator who created the repository.

   • Host. Trillium repository server host name for the system where the repository is located. Enter localhost if you are creating the DSN on the Trillium server system. Otherwise, enter the name or IP address; for example, tsserver or 123.456.789.10.

   • Port. Repository Server port defined during installation of the repository server. For example, 17040.

   • Repository. Name of the repository.

8. Click Test. After a few seconds a message opens stating that the data source connection was successful. If the test is not successful, a Failed to attach to Repository [repository_name] opens. Verify the information entered in the Trillium ODBC DSN Setup window and click Test again.

   To use the reporting adapter, follow the guidelines and procedures in the Trillium Reporting Adapter for Excel User’s Guide.

9. Click OK. The Setup window closes and the name of the new DSN displays in the System Data Sources section of the System DSN tab.

   

10. (Optional) To change the properties for the DSN, select the DSN name and click Configure. You cannot change the data source name or the Service Name and Service Data Source connection properties.

11. (Optional) To delete a DSN, select it and click Remove.

12. Click OK to close the ODBC Data Source Administrator window.