Oracle Lineage Connector

The Oracle Lineage Connector allows Bigeye to track lineage from your Oracle database instance. This connector requires appropriate permissions and configuration to access metadata, packages, and views.

Prerequisites

Before configuring the connector, ensure you have an Oracle user with the required permissions.

Note: See the Oracle setup guide for detailed instructions on creating users and granting the necessary permissions.

Connector Parameters

The Oracle Lineage Connector requires the following parameters in addition to standard database connection parameters:

Parameter	Description
`db.connection.url`	JDBC URL for connecting to your Oracle instance.
`db.connection.driver_class`	JDBC driver class name for Oracle.
`db.connection.username`	Oracle username for the connector.
`db.connection.password`	Password for the Oracle user.
`db.catalog.name.include`	Optional list of catalogs to include.
`db.catalog.name.exclude`	Optional list of catalogs to exclude.
`db.query.fetchsize`	Number of rows to fetch per query.
`db.metadata.usedbaviews`	Set to `true` to use DBA views for metadata extraction.
`db.metadata.uselocalviews`	Set to `true` to use local views for metadata extraction.
`process.package.source`	Set to `true` to process package sources for lineage.
`save.package.source`	Set to `true` to save package source information.
`oracle.version`	Oracle database version (e.g., `19c`, `21c`).

Example Configuration

# Oracle connection
db.connection.url=jdbc:oracle:thin:@//<host>:1521/<service_name>
db.connection.driver_class=oracle.jdbc.OracleDriver
db.connection.username=bigeye_user
db.connection.password=your_password

# Optional catalog filters
db.catalog.name.include=SALES,MARKETING
db.catalog.name.exclude=TEST

# Query and metadata configuration
db.query.fetchsize=500
db.metadata.usedbaviews=true
db.metadata.uselocalviews=false
process.package.source=true
save.package.source=true
oracle.version=19c