Differences
This shows you the differences between two versions of the page.
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]]] |