Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Previous revision
knowledge-base:database-migration:setup-and-troubleshooting:teradata:odbc-driver-configuration [2018/06/14 12:47]
knowledge-base:database-migration:setup-and-troubleshooting:teradata:odbc-driver-configuration [2023/12/15 10:22] (current)
volha.zhyrava
Line 1: Line 1:
 +\\
 +[[https://​www.ispirer.com|Ispirer Website]]
 +[[https://​www.ispirer.com/​products/​teradata-migration|Ispirer Capabilities:​ Teradata Migration]]
 +[[https://​www.ispirer.com/​download/​download-demo|Free Trial]]
 +====== Teradata: ODBC Driver Configuration ======
  
 +To tune the ODBC Connection to Teradata database, please fulfill the following steps:
 +
 +1. Select the Windows Control Panel -> Administrative Tools -> Data Sources (ODBC) option. The "ODBC Data Source Administrator"​ window is displayed.
 +
 +{{:​knowledge-base:​database-migration:​setup-and-troubleshooting:​teradata:​ter_odbc_conf_1.jpg?​nolink|}}
 +
 +2. Click on the "​Add"​ button and select "​Teradata ODBC Driver"​ from the list.
 +
 +{{:​knowledge-base:​database-migration:​setup-and-troubleshooting:​teradata:​ter_odbc_conf_2.png?​nolink|}}
 +
 +3. Click on the "​Finish button"​. The Teradata ODBC dialog is displayed.
 +
 +\\
 +
 +4. Enter the following configuration details:
 +
 +  * The data source name,
 +  * The server name or IP address
 +  * Default database
 +  * User name and password
 +  * And character set if required.
 +
 +See the example below:
 +
 +{{:​knowledge-base:​database-migration:​setup-and-troubleshooting:​teradata:​ter_odbc_conf_3.png?​nolink|}}
 +
 +5. Click on the "​OK"​ button.
 +
 +\\
 +
 +If you created ODBC connection not in the SQLWays Wizard, then you must restart the SQLWays Wizard to update the list of ODBC connections. ​
 +
 +Your Teradata connection is now available to be used in SQLWays Wizard. ​
 +
 +\\
 +
 +If you have any other questions, please contact us: [[[email protected]]]