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

Supported Capabilities

General

• Metadata — metadata extraction and display of asset information (tables, columns, schemas). Types collected: Schema, Table, Column

• Profiling — data profiling on the Profiler tab

• Preview — sample data preview

• Data Quality — data quality monitoring and observability

• Configurable Collection — selective ingestion of schemas/workspaces in Data Source Management

• View Table — view tables, which are virtual tables based on SQL queries

Data Quality Monitors

• Freshness

• Volume

• Field Health

• Custom SQL

• Schema Drift

Lineage

• View Table Lineage — tracks virtual tables (views) and their data dependencies

• Foreign Key Lineage — tracks relationships between tables via primary and foreign keys

Not Supported

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;