Create Connection

Learn how to set up the connection between Teradata and Exasol.

Before you begin the migration procedure, you must upload the Teradata JDBC driver to your Exasol system and configure a connection between the databases. 

To learn how to install drivers in Exasol SaaS, see Driver management (SaaS).

Teradata JDBC driver

  1. Download the JDBC driver from the Teradata JDBC driver download site. Make sure that you download the correct version of the JDBC driver for the version of Teradata.

  2. Upload the JDBC driver to EXAoperation, Exasol's management interface.

    1. Log in to the EXAoperation user interface as an administrator user.
    2. Select Configuration > Software and click the JDBC Drivers tab. Click Add to add the JDBC driver details.
    3. Enter the following details for the JDBC properties:

      • Driver Name: Teradata

      • Main Class: com.teradata.jdbc.TeraDriver

      • Prefix: jdbc:teradata:

      • Disable Security Manager: Do not select this option. This option allows the JDBC Driver to access the certificate and additional information.

      • Comment: This is an optional field.

    4. Click Add to save the settings.
    5. Select the radio button next to the driver from the list of JDBC drivers.
    6. Click Choose File to locate the downloaded driver and click Upload to upload the JDBC driver.

Create and test the connection

  1. Open a SQL client and create the connection from Exasol to Teradata:
    Copy
    CREATE OR REPLACE CONNECTION TERADATA_DB 
    TO 'jdbc:teradata://192.168.99.105/CHARSET=UTF16' 
    USER 'dbc' IDENTIFIED BY 'dbc';
  2. Test the connection by performing a small dummy import:
    Copy
    IMPORT FROM JDBC AT TERADATA_DB
    STATEMENT 'SELECT ''Connection to Teradata works''';