Oracle

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

Prerequisite

You need to allow Dataworkz IP address for access to Oracle Database. This process depends upon the mode of Oracle deployment. Dataworkz supports the following :

• AWS

• Azure

• GCS

• Standalone

AWS

For RDS follow the steps listed below.

• Login to AWS console

• Goto RDS -> Databases

• Select the Oracle instance

• Goto Security -> VPC security groups and select the appropriate security groups

• Click the appropriate security group from the list

• Click "Edit Inbound Rules"

• 
• Click "Add Rules"

• Select "Oracle RDS" from the Type dropdown

• Enter the database port

• Enter "IP" of the Dataworkz platform nat gateway. This is the IP of Dataworkz platform nat gateway and can be viewed by following the steps provided below.

  • Login to Dataworkz Application

  • Goto Configuration by clicking the gear icon at top right of the screen

  • From left menu select Security -> Deployment Details

  • Copy the cluster IP and enter the same in the "IP" field in the above screen

• Click "Save rules"

Creating Oracle Configuration in Dataworkz

1. Login to Dataworkz Application

2. Goto Configuration -> Databases -> Oracle

3. Click the + icon to add a new configuration

4. 
5. Enter name of the database configuration in the above screen

6. Enter Host database server URL

7. Enter the database server Port

8. Enter the User name

9. Enter the Password

10. Enter the deployment type (On premise / AWS / Azure / Google Cloud Platform)

11. Select if TLS/SSL needs to be used

12. Click Test Connection

    1. If successful 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 second from 0 to 6 digits

• CHAR

• NCHAR

• CLOB