Oracle
The Oracle connector is based on the node-oracledb library.
Installation
Section titled “Installation”The Oracle connector need some attention to install correctly. See the api/Dockerfile for more information.
Required Permissions
Section titled “Required Permissions”The user account that is used in Oracle connections need to have read access to these tables and views (in addition to the more common access to sys.ALL_TABLES etc) to get all metadata relevant for Katalogue, but the connector will work without those permissions:
- 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
Section titled “Limitations”Lineage
Section titled “Lineage”The Oracle connector does not provide dataset/table lineage out of the box as this is missing in the information schema.