Create IBM DB2 Connection

 

image-20240627-071715.png

Connection Properties:

Name

Mandatory

Description

Name

Mandatory

Description

Connection Name

Yes

Name of the connection

Description

No

Description of the connection

Host Name

Yes

Host or “Endpoint“

Port

Yes

Port number

Schema

Yes

Name of the schema.

Database

Yes

Name of the database

Username

Yes

Username of the database

Password

Yes

Password of the database

Platform Type

Yes

Type of platform where the database is hosted (LUW for Linux, Unix, Windows, or iSeries for IBM iSeries).

Use SSL

Yes

Whether to use SSL (Secure Sockets Layer) for the connection (Yes or No).

Steps to create connection:

  1. There are two ways to create connection -

    1. Choose the IBM DB2 connector from Pipeline tab > add connection.

image-20240627-072351.png
Pipeline Tab

b. Go to the Connections tab > add connection > from the dropdown select IBM DB2.

  1. Fill in the required details.

  2. Click on the Test connection button to confirm.

  3. Click Create connection.