Data Definition Language (DDL) Migration
- You can download the JDBC driver (for example,
terajdbc4.jar) from Teradata JDBC driver download site. Make sure you download the correct version of the JDBC driver matching the version of the Teradatadatabase.
- Next, you need to upload this JDBC driver to EXAoperation, Exasol's management interface.
- Log in to the EXAoperation user interface as an administrator user.
- Select Configuration > Software and click the JDBC Drivers tab. Click Add to add the JDBC driver details.
- Enter the following details for the JDBC properties:
This section focuses on the migration of the databases and tables from
This migration guide is based on the premise of using the Teradata Database Migration Script to execute the DDL migration (schema, tables) and map all data types to Exasol data types. While it is possible to execute certain steps manually outside of the script, using the script lets you automate tasks for converting schemas and table definitions as much as possible.
Before you begin with the migration, as a prerequisite you need to first upload Teradata JDBC driver to Exasol. To do this, you can follow the steps below:
- Driver Name: Teradata
- Main Class:
- Prefix: jdbc:teradata:
- Disable Security Manager: Do not select this option. This is an optional field. This allows the JDBC Driver to access the certificate and additional information.
- Comment: This is an optional field.
It is important to set the correct CHARSET parameter, depending on your Teradata installation. You will get an error message similar to “String data right truncation”, if you used CHARSET=UTF8 instead of CHARSET=UTF16.
The next steps in the DDL migration are: