Altova XMLSpy 2024 Professional Edition

This example illustrates how to connect to a Teradata database server through ODBC.

Prerequisites:

The Teradata ODBC driver must be installed (see https://downloads.teradata.com/download/connectivity/odbc-driver/windows. This example uses Teradata ODBC Driver for Windows version 16.20.00.

You have the following database connection details: host, username, and password.

To connect to Teradata through ODBC:

1.Press the Windows key, start typing "ODBC", and select Set up ODBC data sources (32-bit) from the list of suggestions. If you have a 64-bit ODBC driver, select Set up ODBC data sources (64-bit) and use 64-bit XMLSpy in the subsequent steps.

dbc_teradata_odbc01

2.Click the System DSN tab, and then click Add.

dbc_teradata_odbc02

3.Select Teradata Database ODBC Driver and click Finish.

dbc_teradata_odbc03

4.Enter name and, optionally, a description that will help you identify this ODBC data source in future. Also, enter the database connection credentials (Database server, User, Password), and, optionally, select a database.

5.Click OK. The data source now appears in the list.

dbc_teradata_odbc04

6.Run XMLSpy and start the database connection wizard.

7.Click ODBC Connections.

dbc_teradata_odbc05

8.Click System DSN, select the data source created previously, and then click Connect.

 

Note:If you get the following error: "The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 03.80", make sure that the path to the ODBC client (for example, C:\Program Files\Teradata\Client\16.10\bin, if you installed it to this location) exists in your system's PATH environment variable. If this path is missing, add it manually.

© 2017-2023 Altova GmbH