Oracle

The Oracle connector is based on the node-oracledb library.

Installation

The Oracle connector need some attention to install correctly. See the api/Dockerfile for more information.

Required Permissions

As a minimum, the user account that is used in Oracle connection requires read access to the following resources:

• sys.ALL_OBJECTS
• sys.ALL_TABLES
• sys.ALL_VIEWS
• sys.ALL_TAB_COLUMNS
• sys.ALL_CONSTRAINTS
• sys.ALL_CONS_COLUMNS
• sys.ALL_USERS
• sys.ALL_TAB_COMMENTS
• sys.ALL_COL_COMMENTS
• sys.GLOBAL_NAME

In addition to the above, to get the disk size property (dataset_size_bytes), read access to these tables and views is required. The connector will work without those permissions, but the dataset_size_bytes property will be null.

• sys.dba_segments
• sys.dba_indexes
• sys.v$pdbs (only if PDB database)
• sys.v$database (only if not PDB database)

Note that other permissions might be required if custom import queries are used.

Limitations

Lineage

The Oracle connector does not provide dataset/table lineage out of the box as this is missing in the information schema.