Articles in this section

Set up a connection to IBM Db2

Anitha Abraham
Updated

IBM Db2 is a relational database to store and manage structured data efficiently. It is widely used to process transactions, analyze data, and support AI-driven applications in banking, insurance, and manufacturing.

Supported platforms

  • Linux, Unix, Windows

  • AS400

Before you begin

If you have an on-premise Db2 setup, then you must complete the following steps:

  1. Download and install the Java 17 JDK. (We've tested Java 17 JDK. You can use a higher version also.)

  2. After installing the JDK software, configure the PATH and JAVA_HOME variables if you're using Windows on your machine:

    1. Set the JAVA_HOME variable to the JDK installation directory. For example,

      On Windows: JAVA_HOME=C:\Program Files\Java\jdk-17.0.1

    2. Set the PATH variable by appending bin to the path you specified in JAVA_HOME. For example,

      On Windows: PATH=C:\Program Files\Java\jdk-17.0.1\bin

      For Oracle Java, see also Setting JAVA_HOME. Similarly, if you're using OpenJDK or the like, refer to the related documentation to set these variables.

Set up the connection

Setting

Instructions

Name * 

Enter a clear and distinguishable name. Throughout the Celigo platform (integrator.io) imports and exports, you will have the option to choose this new connection. A unique identifier will prove helpful later when selecting it from a list of the connections in your account.

Application 

Shows the database connector, IBM Db2, that you had earlier selected.

Mode * 

Choose either Cloud (remote) or On-premise (network) server, based on your requirement.

  • Cloud – connects to a publicly accessible server application

  • On-premise – connects to a publicly inaccessible server that has an integrator.io agent installed on it. For On-premise, there’s an additional step to specify an Agent.

    Note

    Celigo on-premise agents work only on Windows and Linux platforms.

Agent * (enabled when Mode is On-premise)

Select an agent from the list.

To connect to an on-premise application, the platform (integrator.io) requires that an agent be installed on a networked computer. A single agent can be used by multiple different connections.

Host * 

Enter the hostname or IP address of the Db2 server.

See also, IBM Db2 documentation.

Port * 

Enter the port used to connect to the server hosting the Db2 database. The default is 50000.

Database * 

Enter the name of the Db2 database.

Username * 

Enter your username to authenticate and access the database.

Password * 

Enter the password to authenticate and access the database

Use SSL 

Check this field if you want to establish a secure connection to the database. This ensures that data in transit is encrypted.

Certificate (enabled when Use SSL is selected)

Enter the certificate chain in PEM format only if the database server is using client certificate authentication. For details, see IBM Db2 documentation.

After configuring the settings, click Test Connection. When the connection is verified, you will receive the following message:

test-connection-success.png

The connection is now added to your account. You can see it listed under Resources → Connections. If a connection is part of an integration, you can see it listed under Home → Integration name → Connections, and you may proceed to register the connection.