Home Connectors Oracle Connector

Oracle Connector

Last updated on Sep 19, 2024

In this page, you will learn how to connect Erathos to Oracle Database to move your data.

The connection methods with databases available on the platform are Open Connection, Static IP, and SSH Tunnel Connection.

Connecting Oracle Database to Erathos:

  1. Log in to the Erathos platform.

  2. Select Oracle as the connector.

  3. Name your connection.

  4. Fill out the following form with the requested information.

To connect via SSH tunnel, you will need to fill out this additional form:

How to locate the credentials for db_host, db_port, and db_name in Oracle Cloud?

Autonomous Database

  1. Navigate to the main details page of the chosen database.

  2. In the top bar, click the "Database Connection" button.

  3. A sidebar labeled "Database Connection" will open, containing a box titled "Connection strings."

  4. Choose one of the available TNS names and click "Show" to view the full string.

  1. Copy the values for port, host, and service_name. On the Erathos platform, these values correspond to db_port, db_host, and db_name, respectively

If the network configuration restricts access to only allowed IPs, still on the database details page, click "Edit" next to the Access control list.

Add the IP 35.212.87.86 and click "Save" at the bottom of the page to allow Erathos to connect to your database.

DB System

  1. In the sidebar under Resources, click on "Nodes."

  2. In the Nodes table, the column defined as "Public IP address" will be your db_host if you choose not to use an SSH tunnel.

    If you prefer to use a private connection:

  3. Copy the IP value or DNS present in the column "Private IP address & DNS name" to use as db_host, and the Public IP address will be the ssh_host. By default, the ssh_user on Oracle Cloud is generally opc.

  4. Then, click the "Add SSH Keys" button in the top bar of the page.

    A sidebar will open:

    1. Check the box "Generate SSH key pair."

    2. Click the "Save private key" button to download the key file.

    3. Finally, click the "Save changes" button at the bottom of the page.

Still in the Resources sidebar on the main page of the DB System, now select "Databases" and click on the chosen CDB to load its details.

On the CDB page, select the "Pluggable Databases" option in the Resources bar. Then, click on the name of the chosen PDB.

On the main page of the PDB, click the top button called "PDB connection" to open the connection details sidebar.

Copy the values for port and service_name. On the platform, these values correspond to db_port and db_name, respectively.

If the network configuration restricts access to only allowed IPs, return to the initial main page of the DB System to access the VCN associated with the database.

On the VCN page, select the subnet of the desired database and click to explore the access rules.

Then, click "Security List" in the table, and when the page opens, click "Add Ingress Rules."

Add the CIDR 35.212.87.86/32, corresponding to the Erathos IP, to allow our connection to the database (if you prefer to restrict the allowed ports, replace "all" in Destination Port Range with 22 for the SSH tunnel and/or 1521/1522 for the database).

Once the connector is created, you can create your data pipeline from Oracle to your data warehouse in BigQuery, DataBricks, Redshift, or Postgres.