Configuring ODBC DSN    - trillium_discovery - trillium_quality - 17.1

Trillium Reporting Adapter for Excel Guide
Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Quality
Trillium > Trillium Discovery
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Reporting Adapter for Excel Guide
Topic type
How Do I
Overview
Configuration
Reference
Administration
Installation
First publish date
2012

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

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

  1. Install Trillium Quality and the Trillium Repository Server in your environment (they do not need to be installed on the same system as the DSN). See the Trillium DQ Installation Guide.

  2. Install the ODBC Reporting Adapter on the same Windows system where you plan to create ODBC DSNs. To install the 32-bit provider or the 64-bit provider, see the Trillium DQ Installation Guide.

  3. Create a Trillium repository to which you want to create a connection. You need the repository account information to create a DSN.

To configure ODBC DSN data source

  1. On the Trillium repository server system, do one of the following depending on the version of the ODBC reporting adapter you installed:

    • 32-bit: Click Start > Programs/All Programs > Trillium Software > ODBC Administrator.

    • 64-bit: Click Start > Programs/All Programs > Trillium Software > ODBC Administrator (64-Bit).

    The ODBC Data Source Administrator window opens.

  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 (for 32-bit) or TSS ODBC Reporting Adapter (64-bit).

  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. As a best practice, for reference include the type of ODBC connection you are using, either 32- or 64-bit, in the name.

    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. This is case sensitive.

  8. Click Test. After between 5 and 30 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 message opens. Verify the information entered in the Trillium ODBC DSN Setup window and click Test again.

  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.