Oracle

This document describes the Dataworkz connector configuration required to access an Oracle database.

Prerequisite

Allow the Dataworkz IP address access to the Oracle database. The process depends on the deployment mode. Dataworkz supports the following deployment modes:

• AWS

• Azure

• GCS

• Standalone

AWS

For RDS, follow the steps below.

• Log in to the AWS console.

• Go to RDS > Databases.

• Select the Oracle instance.

• Go to Security > VPC security groups and select the appropriate security group.

• Click the security group from the list.

• Click Edit Inbound Rules.

• Click Add Rules.

• Select Oracle RDS from the Type dropdown.

• Enter the database port.

• Enter the IP of the Dataworkz platform NAT Gateway. To find it:

  • Log in to the Dataworkz application.

  • Go to Configuration by clicking the gear icon at the top right.

  • From the left menu, select Security > Deployment Details.

  • Copy the cluster IP and enter it in the IP field.

• Click Save rules.

Creating Oracle Configuration in Dataworkz

1. Log in to the Dataworkz application.

2. Go to Configuration > Databases > Oracle.

3. Click + Add new configuration.

1. Enter a name for the database configuration.

2. Enter the Host database server URL.

3. Enter the Port.

4. Enter the Username.

5. Enter the Password.

6. Enter the Deployment Type (On-premise / AWS / Azure / Google Cloud Platform).

7. Enable TLS/SSL if required.

8. Click Test Connection.

   1. If the connection succeeds, click Save to add the connector.

Datatypes Supported

Dataworkz supports the following Oracle datatypes:

• VARCHAR2

• NVARCHAR2

• NUMBER

• FLOAT

• LONG

• DATE

• BINARY_FLOAT

• BINARY_DOUBLE

• TIMESTAMP - fractional support for seconds from 0 to 6 digits

• CHAR

• NCHAR

• CLOB