Adding New System DSN - trillium_discovery - trillium_quality - 17.2

Trillium DQ Repository Administrator Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.2
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium DQ Repository Administrator Guide
First publish date
2008
Last updated
2024-07-01
Published on
2024-07-01T08:53:20.448228

You must create and configure a Data Source Name (DSN) for the Trillium ODBC loader connection with information about the specific database to which you want the connection to point.

Perform this procedure on the Windows server system where the Trillium repository is installed.

To add a new system DSN

  1. From the Start menu, click Trillium Software > ODBC Data Source Administrator. The ODBC Data Source Administrator window opens.

  2. Click the System DSN tab.

  3. Click Add to open the Create New Data Source window.

  4. Scroll through the list of drivers and select TSS 17 SQL Server Driver.

  5. Click Finish. The ODBC SQL Server Wire Protocol Driver Setup window opens.

  6. Configure the data source with the Host Name, Port Number, and Database of the SQL Server system.

  7. Click the Security tab.

  8. For Authentication Method, select Kerberos.

  9. Click Apply. Click Close to close the setup window.