Oracle Connector: Overview

Applies from release 2021.3

The OCF Connector for Oracle was developed by Alation and is available as a Zip file, which can be uploaded in Manage Connectors and installed. Create a ticket with Alation Support about receiving the Oracle connector package.

This connector should be used to catalog the Oracle database as a data source in Alation. The connector catalogs Oracle objects such as schemas, tables, columns, synonyms, views, primary keys, foreign keys, indices, procedures and functions. It enables end users to search and find Oracle objects from the Alation user interface.

Team

The following administrators are required to install this connector:

  • Alation Administrator:

    • Installs Alation Connector Manager

    • Installs the connector

    • Creates and configures an Oracle data source in the catalog

  • Oracle Administrator:

    • Creates a service account that should have read privileges to access tables and views

    • Provides the JDBC URI to access the Oracle database

    • Provides access to public schemas to extract metadata

Scope

The table below shows what features are covered by the connector. For version support information, refer to Support Matrix.

Oracle (EC2)

Oracle (RDS)

Core Capabilities

Automated Metadata Extraction (MDE)

Query-based MDE

Search

Catalog page curation

Catalog sets

Propagation of data quality flags

Popularity

Compose

On-prem Alation instances

Alation Cloud Service instances*

* Compose for data sources connected through Alation Agent is supported from connector version 1.2.6.

QLI

Table-based

Query-based

Filters

Lineage

Sampling and Profiling

Table sampling

Custom query-based table sampling

Custom query-based column profiling

Dynamic Profiling

Authentication

Basic (username and password)

Kerberos

Keytab

Technical Metadata

Tables

Columns

Primary key

Foreign key

Views

Schemas

Source comments

Synonyms