DB2
This document describes the Dataworkz connector configuration required to access DB2.
Prerequisite
You need to allow Dataworkz IP address for access to DB2 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 DB2 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 "DB2 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"
Create Connector for DB2 in Dataworkz
Login to Dataworkz Application
Goto Configuration -> Databases -> DB2
Click the + icon to add a new configuration
Provide name for the connector
Enter Host name / IP address of the database server
Enter the Port at which server is running
Enter the User name
Enter the Password
Select the deployment enviornment
Select TLS/SSL if needed
Click Test Connection
If successful click Save to add the connector
Last updated