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
-
Open the command prompt.
-
Type in C:\Windows\System32\odbcad32.exe. The 64-bit ODBC Data Source Administrator opens.
-
Click the System DSN tab.
-
Click Add to open the Create New Data Source window.
-
Scroll down and select the appropriate driver, for example, TSS 17 Oracle Driver.
-
Click Finish. The ODBC configuration page opens. The parameters in the ODBC configuration page will vary depending on the data source.
-
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.
-
Click Apply to save your changes.
-
Click OK to close the configuration window.
-
Create TSS ODBC loader connection.
TSS ODBC drivers with web-based interface
TSS 17 Autonomous REST Connector Driver
TSS 17 Google Analytics Driver
TSS 17 Microsoft Dynamics 365 Driver
TSS 17 Microsoft SharePoint Driver
TSS 17 MongoDB Driver
TSS 17 SAP S4HANA Driver
The parameters in the ODBC configuration page will vary depending on the data source.
Limitation with TSS 17 Google BigQuery Driver and TSS 17 Oracle Service Cloud Driver
For the 17.3 release, you can use only the Direct mode of connection to configure DSN for these drivers and cannot use the Auto (where applicable) or Server mode. The connection mode is specified under the SQL Engine tab in the SQL Engine Mode dropdown list.