Connectivity Summary

An out-of-the-box connector is available for DB2 databases to support crawling database objects and profiling sample data.

The drivers used by the connector are given below:

Driver/API: JDBC driver
Version: 10.1
Details: https://ovaledge-jars.s3.amazonaws.com/third_party_jars/db2jcc4-10.1.jar
Note: Latest version is

Connector Capabilities

The following are the connector capabilities mentioned below:


Supported objects and data types for Crawling are:

Feature Supported Objects Remarks
Crawling Tables  
Table Columns

Supported Data Types: Varchar, longvarchar, char, bigint, integer, decimal, smallint, float, date, time, timestamp.

Stored Procedures  

Please see this article Crawling Data for more details on crawling.  


For more details on profiling, please refer to Profiling Data

Feature Support Remarks
Table Profiling Row count, Columns count, View sample data  
View Profiling Row count, Columns count, View sample data View is treated as a table for profiling purposes
Column Profiling Min, Max, Null count, distinct, top 50 values  
Full Profiling Supported  
Sample Profiling Supported  


Operation Details
Select Supported
Insert Supported
Update Supported
Delete Supported
Joins within database Supported
Joins outside database Supported
Aggregations Supported
Group By Supported
Order By Supported

By default, the service account provided for the connector will be used for any query operations.


To use the connector, the following need to be available:

  1. Connection details as specified in the following section should be available.
  2. A User account with reading privileges.
  3. Add DB2 drivers into the OvalEdge Jar path to communicate with the DB2 database.
Check the Configuration section for further details on how to add the drivers to the jar path.

Connection Details

The following are the connection settings that should be added for connecting to a DB2 database:


  • Database Type: DB2
  • Connection Name: Select a Connection name for the DB2 database. The name that you specify is a reference name to easily identify your DB2 database connection in OvalEdge.
    Example: DB2 Connection 1
  • Hostname/IP Address: Database instance URL (on-premises/cloud-based)
  • Port Number: 50005
  • Sid/Database: Name of the database to connect.
  • Username: User account login credential
  • Password: Password
  • Driver Name: DBC driver name for DB2. It will be auto-populated.
    Example: com.ibm.db2.jcc.DB2Driver
  • Connection String: DB2 connection string. Set the Connection string toggle button to automatic, to get the details automatically from the credentials provided. Alternatively, you can manually enter the string.
    Format: jdbc:db2://{server}:50005/{sid}
    Example: jdbc:db2://
  • License Type: Standard , Auto Lineage.
  • Plugin Server/Port: NA

Once connectivity is established, additional configurations for Crawling and Profiling can be specified.


Profile Settings

  • Order: Priority of the rule
  • Start time and End time: Used when crawling/profiling is to be scheduled
  • No. of threads: No. of threads used to perform profiling
  • Profile Type: Disabled/Auto/Sample/Query
  • Row count Constraint: No. of rows to be fetched
  • Sample profile size: A sample profile row limit
  • Sample data count: A sample amount of data to profile
  • Query Timeout: Time to wait for a response
  • Crawler options: Procedures, Functions, Triggers & Views Source Code/Tables, Views & Columns/Relationship.
  • Profile options: Tables and Columns/Views and Columns
  • Crawler Rules: Include and Exclude Regex for table/column/procedures
  • Profile Rules: Include and Exclude Regex for table/column

Points to note

Port number can vary, default port number is 50005.


  1. How much does the driver cost?
    The Microsoft JDBC Driver for DB2  is available at no additional charge.