Advanced Analytica Advanced Analytica: IBOM
← All connectors
IBM Db2 logo

Source connector

IBM Db2

Set up IBM Db2 as a source and move its data into your chosen destination.

Version 0.3.1 community alpha

Db2

Overview

The IBM Db2 source syncs data from Db2. It supports Full Refresh and Incremental syncs. For each sync, you can copy only new or updated data. Alternatively, copy every row from the tables and columns you’ve set up for replication.

The IBM Db2 source connector is built on the IBM Data Server Driver for JDBC and SQLJ. This pure-Java driver (Type 4) supports the JDBC 4 specification described in IBM Db2 documentation.

Resulting schema

The IBM Db2 source doesn’t alter the schema in your warehouse. However, the connected destination may alter the resulting schema. See the destination’s documentation for details.

Features

FeatureSupported?(Yes/No)Notes
Full Refresh SyncYes
Incremental - Append SyncYes
NamespacesYes

Get started

Requirements

You’ll need this information to configure the IBM Db2 source:

  1. Host
  2. Port
  3. Database
  4. Username
  5. Password
  6. A dedicated read-only Airbyte user and role with access to every schema needed for replication.

Setup guide

1. Enter the database port, host and name

This optional step is highly recommended for better permission control and auditing. Alternatively, you can use Airbyte with an existing database user.

Create a dedicated database user, then run these commands against your database:

-- create Airbyte role
CREATE ROLE 'AIRBYTE_ROLE';

-- grant Airbyte database access
GRANT CONNECT ON 'DATABASE' TO ROLE 'AIRBYTE_ROLE'
GRANT ROLE 'AIRBYTE_ROLE' TO USER 'AIRBYTE_USER'

Your database user is now ready to use with Airbyte.

3. Set up an SSL connection

You need a client certificate to set up an SSL connection. Add it to the “SSL PEM file” field. The connector will automatically add the certificate to the secret keystore.

You can also enter your own keystore password. If you don’t, the password will be generated automatically.

IP allow list

If you use Airbyte Cloud and restrict access to specific IPs, add the Airbyte Cloud IP addresses to your allow list.

Changelog

Expand to review

| Version | Date | Pull Request | Subject | | :------ | :--------- | :------------------------------------------------------------------------------------------------------------ | :---------------------------------------------------------------------------------------------------------------------------------------- | -------- | | 0.3.1 | 2025-07-10 | 62915 | Add gradle docker plugins | | 0.3.0 | 2025-03-06 | 48969 | fix datatype and connection string | | 0.2.4 | 2025-01-10 | 51502 | Use a non root base image | | 0.2.3 | 2024-12-18 | 49909 | Use a base image: airbyte/java-connector-base:1.0.0 | | 0.2.2 | 2024-02-13 | 35233 | Adopt CDK 0.20.4 | | 0.2.1 | 2024-01-24 | 34453 | bump CDK version | | 0.2.0 | 2023-12-18 | 33485 | Remove LEGACY state | | 0.1.20 | 2023-06-20 | 27212 | Fix silent exception swallowing in StreamingJdbcDatabase | | 0.1.19 | 2023-03-22 | 20760 | Removed redundant date-time datatypes formatting | | 0.1.18 | 2023-03-06 | 23455 | For network isolation, source connector accepts a list of hosts it is allowed to connect to | | 0.1.17 | 2022-12-14 | 20346 | Consolidate date/time values mapping for JDBC sources | | | 2022-10-13 | 15535 | Update incremental query to avoid data missing when new data is inserted at the same time as a sync starts under non-CDC incremental mode | | 0.1.16 | 2022-09-06 | 16354 | Add custom JDBC params | | 0.1.15 | 2022-09-01 | 16238 | Emit state messages more frequently | | 0.1.14 | 2022-08-18 | 14356 | DB Sources: only show a table can sync incrementally if at least one column can be used as a cursor field | | 0.1.13 | 2022-07-22 | 14714 | Clarified error message when invalid cursor column selected | | 0.1.12 | 2022-07-14 | 14574 | Removed additionalProperties:false from JDBC source connectors | | 0.1.11 | 2022-06-17 | 13864 | Updated stacktrace format for any trace message errors | | 0.1.10 | 2022-04-29 | 12480 | Query tables with adaptive fetch size to optimize JDBC memory consumption | | 0.1.9 | 2022-02-21 | 10242 | Fixed cursor for old connectors that use non-microsecond format. Now connectors work with both formats | | 0.1.8 | 2022-02-18 | 10242 | Updated timestamp transformation with microseconds | | 0.1.7 | 2022-02-14 | 10256 | Add -XX:+ExitOnOutOfMemoryError JVM option | **** | | 0.1.6 | 2022-02-08 | 10173 | Improved discovering tables in case if user does not have permissions to any table | | 0.1.5 | 2022-02-01 | 9875 | Discover only permitted for user tables | | 0.1.4 | 2021-12-30 | 9187 8749 | Add support of JdbcType.ARRAY to JdbcSourceOperations. | | 0.1.3 | 2021-11-05 | 7670 | Updated unique DB2 types transformation | | 0.1.2 | 2021-10-25 | 7355 | Added ssl support | | 0.1.1 | 2021-08-13 | 4699 | Added json config validator | | 0.1.0 | 2021-06-22 | 4197 | New Source: IBM DB2 |

Advanced Analytica

Most businesses are sitting on information they can’t use at speed. The people who hold it are busy, and when they leave, the knowledge goes with them. The documents are static, and the processes around them weren’t designed for AI.

Advanced Analytica works with these businesses to turn that information into structured data assets. Once they're integrated, AI systems can govern it, and the business can use it. We bring in the strategy, the specification and the AI skills to rework how the business operates.

MOVE FAST. STAY SAFE.