Configuring DSN on Windows - trillium_discovery - trillium_quality - 17.1

Before you create a DSN entry, you must collaborate with your database administrator to gather relevant information like host name, database name, user login credentials, and other relevant information. This is important because you may need to provide all or some of the information when creating the TSS ODBC DSN entry.

This procedure describes how to create a 64-bit DSN to use with 64-bit ODBC Trillium-Supplied drivers and the ODBC Trillium-Supplied loader connections to connect to data sources in 64-bit enabled databases.

To add a 64-bit DSN entry on Windows

1. Open the command prompt.

2. Type in C:\Windows\System32\odbcad32.exe. The 64-bit ODBC Data Source Administrator opens.

3. Click the System DSN tab.

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

5. Scroll down and select the appropriate driver, for example, TSS 17 Oracle Driver.

6. Click Finish. The ODBC configuration page opens. The parameters in the ODBC configuration page will vary depending on the data source.

7. Specify the required information in the configuration page. See Configuring TSS Oracle Driver on Windows (Example).

   If you are configuring a TSS 17 SQL Server Legacy Driver, see SSO and the TSS 17 SQL Server Legacy Driver.

   If you are configuring a TSS 17 Hadoop Hive Driver, see About TSS 17 Hadoop Hive Driver.

8. Click Apply to save your changes.

9. Click OK to close the configuration window.

10. Create TSS ODBC loader connection.