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

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

Catalog	Capability
Data Profiling	✅
Data Preview	✅

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 to the decube user. Here table 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 value.

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