IBM Db2 connector

Easily connect to your IBM Db2 with Pecan, so you can create models using your existing data.

Ori Sagi avatar
Written by Ori Sagi
Updated over a week ago

Db2 is a relational database management system that delivers advanced data management and analytics capabilities for transactional workloads.

You'll need to provide certain details and credentials, so Pecan can access the relevant data in IBM Db2. If you need help with the below steps, be sure to consult with your internal IT or DevOps team.

Prerequisite steps

  1. First, make sure you whitelist these Pecan IP addresses:
  2. Before adding a Db2 connection, if you haven’t already, you’ll need to create a role with Read permissions so Pecan can access your database service.

How to configure an IBM Db2 connection

  1. Log in to Pecan, select the “Connections” tab, and click Add connection.

  2. Select “IBM Db2” and complete the following fields:

    • Connection name – This is how you’ll identify the connection when creating and working with models on the platform. Names should be unique and reflect the data source and what’s stored in it. Valid characters include letters, numbers, and underscores. Connection names can’t be changed once created. Example: “db2_paid_downloads_fall_2021”

    • Connection type – Select "Read" if the connection will be used to import data into Pecan. Select "Write" if it will be used to export predictions from Pecan to IBM Db2.

    • Host name – this is the address that provides remote access to your database service instance.

    • Username and Password – these credentials are for the Read-only account that will enable Pecan to access your database service.

    • Database – this is the name of the database Pecan should use. Servers can hold many different databases; if you want to use multiple databases to create models in Pecan, but they sit on the same server, you’ll need to create a new connection for each database.

    • SSL – select “true” or “false” based on whether your Db2 instance only accepts encrypted connections via SSL protocol. This way, Pecan can configure the connection accordingly.

    • Port – provide the connection port for your server. If you leave this blank, Pecan will automatically use the default port 50000.

  3. Now, click Test connection to make sure everything is working correctly. Then click Create connection to complete the setup. (For more information, see Testing and creating a data connection.)

Did this answer your question?