Create Connection

This section explains how to set up the connection between Teradata and Exasol.

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

For instructions on how to install the Teradata JDBC driver in Exasol SaaS, contact Support.

Create and test the connection

1. Open a SQL client and create the connection from Exasol to Teradata:

   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:

   IMPORT FROM JDBC AT TERADATA_DB
   STATEMENT 'SELECT ''Connection to Teradata works''';