Skip to main content

Source Db2

info

Airbyte Enterprise Connectors are a selection of premium connectors available exclusively for Airbyte Self-Managed Enterprise and Airbyte Teams customers. These connectors, built and maintained by the Airbyte team, provide enhanced capabilities and support for critical enterprise systems. To learn more about enterprise connectors, please talk to our sales team.

Features

FeatureSupportedNotes
Full Refresh SyncYes
Incremental Sync - AppendYes
Replicate Incremental DeletesNo
Change Data Capture (CDC)No
SSL SupportNo
SSH Tunnel ConnectionNo
NamespacesYes

From the point of view of the Db2 database instance, the Enterprise Db2 source operates strictly in a read-only fashion.

Getting Started

1. Make sure your database is accessible from the machine running Airbyte

This is dependent on your networking setup. The easiest way to verify if Airbyte is able to connect to your Db2 instance is by testing the connection in the UI.

2. Create a dedicated read-only user with access to the relevant tables

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

Data type mapping

Db2 data types are mapped to the following data types when synchronizing data.

Oracle TypeAirbyte TypeNotes
SMALLINTnumber
INTnumberinteger
INTEGERnumberinteger
BIGINTnumberinteger
DECIMALnumber
DECnumber
NUMERICnumber
REALnumber
FLOATnumber
DOUBLEnumber
DOUBLE PRECISIONnumber
DECFLOATnumber
CHARstring
CHARACTERstring
VARCHARstring
CHARACTER VARYINGstring
CHAR VARYINGstring
CLOBstring
CHARACTER LARGE OBJECTstring
CHAR LARGE OBJECTstring
BLOBstring
BINARY LARGE OBJECTstring
BINARYstring
VARBINARYstring
BINARY VARYINGstring
DATEstring
TIMEstring
TIMESTAMPstring
BOOLEANboolean
XMLstring

Changelog

Expand to review

The connector is still incubating, this section only exists to satisfy Airbyte's QA checks.

  • 0.0.1