DB2

Rather than a storage connector, that connects to a GCP or S3 bucket for example, a DB2 connector is referred to as a database connector. Currently, the Oracle connector is supported for the creation of platform, tabular assets and cannot be used as an export location.

Pre-requisites

To connect your Oracle database , you need:

1. Your database host's IP (e.g., 1.1.1.2) or domain (e.g., my.server.com)

2. Your database's port

3. A user created for accessing the required data (input username and password)

4. Database name with the following minimum Role/Permission:

   1. SELECT on target tables

   2. SELECT on SYSCAT views

Create the Connector

1. Click Manage on the Navigation bar.

2. Select Connectors to view the Manage Connectors screen

3. Click the Create Connector button at the top right

4. Enter a Name for your Connector and a Description (optional)

5. Choose Type > DB2

6. Add any Integration Metadata needed for programmatic integration.

7. Click Create. Connection test will run and if successful, will show Connection Test Status as Successful.

8. Click Close.