Create Connection

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

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

For instructions on how to install Oracle drivers in Exasol SaaS, contact Support.

Create and test the connection

  1. Open a SQL client and create the connection from Exasol to Oracle: 
    CREATE OR REPLACE CONNECTION oracle_jdbc    
    TO 'jdbc:oracle:thin:@192.168.56.106:1521/orcl' 
    USER 'stage' IDENTIFIED BY 'stage';
  2. Test the connection by performing a small dummy import: 
    IMPORT FROM JDBC AT oracle_jdbc 
    STATEMENT 'SELECT ''Connection works'' from dual';