Oracle

Add Oracle as a decube connection and help your team discover, document and monitor data assets to drive data-driven insights and decisions.

Supported Capabilities

Capability	Supported
Metadata Extraction	✅
Metadata Types Collected	Schema, Table, Column
Data Profiling	✅
Data Preview	✅
Data Quality	✅
Configurable Collection	✅
External Table	❌
View Table	✅
Stored Procedure	❌

Data Quality Support

Capability	Supported
Freshness	✅
Volume	✅
Field Health	✅
Custom SQL	✅
Schema Drift	✅
Job Failure	❌

Lineage Support

Capability	Supported
View Table Lineage	✅
External Table Lineage	❌
SQL Query Lineage	❌
Foreign Key Lineage	✅
Stored Procedure Lineage	❌

Connection Requirements

Connecting to decube is as easy as providing us with read-only credentials to your Oracle database. At a minimum, we require

• Username

• Password

• Host

• Port

• Database

Oracle

Create User for Decube

A custom user would allow for a granular configuration of the user on your database and your connection to decube.

1. Create the user, and change password accordingly.

CREATE USER 'decube' IDENTIFIED BY '<password>';

1. Grant read-only privileges on all data dictionary views

GRANT SELECT_CATALOG_ROLE TO 'decube';

1. Grant access of tables and views to the decube user. Here table or view can be * if you're using decube to observe the whole database. For only a few tables, you'll have to run this command multiple times changing the table or view value.

GRANT CONNECT TO decube;
GRANT SELECT ON <schema>.<table> TO decube;
GRANT SELECT ON <schema>.<view> TO decube;