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
Login to Dataworkz Application
Goto Configuration -> Databases -> Oracle
Click the + icon to add a new configuration
Enter name of the database configuration in the above screen
Enter Host database server URL
Enter the database server Port
Enter the User name
Enter the Password
Enter the deployment type (On premise / AWS / Azure / Google Cloud Platform)
Select if TLS/SSL needs to be used
Click Test Connection
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
Last updated