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

1. Login to Dataworkz Application

2. Goto Configuration -> Databases -> DB2

3. Click the + icon to add a new configuration

4. 
5. Provide name for the connector

6. Enter Host name / IP address of the database server

7. Enter the Port at which server is running

8. Enter the User name

9. Enter the Password

10. Select the deployment enviornment

11. Select TLS/SSL if needed

12. Click Test Connection

    1. If successful click Save to add the connector