Overview¶
Alation Cloud Service Applies to Alation Cloud Service instances of Alation
Customer Managed Applies to customer-managed instances of Alation
Core Connector Core connectors are included with all Alation platform tiers (subject to each tier’s connector limits) and are fully supported by Alation.
You can install and upgrade the connector using one of the following methods, depending on your Alation deployment type:
On-premise instances: Download the latest connector package from the Alation Customer Portal (Customer Portal > Connectors), then upload and install it in Alation.
Alation Cloud Service: Install and upgrade the connector directly from your instance without downloading the package. Any connector available on the Alation Customer Portal (Customer Portal > Connectors) can be installed and upgraded this way. See Install Connectors (Cloud-Native Architecture). You can also download the connector package from the Alation Customer Portal and install or upgrade it manually by uploading the Zip file.
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 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 or ensures that it has been installed.
Installs the connector.
Creates and configures an Oracle data source in the catalog.
Oracle Administrator:
Creates a service account and grants it the required privileges to access the metadata.
Provides the JDBC URI to access the Oracle database.
Assists in configuring authentication.
Scope¶
The table below shows what features are covered by the connector. For version support information, refer to Support Matrix.
Oracle (EC2) |
Oracle (RDS) |
Oracle (E-Business Suite) |
|
|---|---|---|---|
Core Capabilities |
|||
Automated metadata extraction (MDE) |
|
|
|
Query-based MDE |
|
|
|
Search |
|
|
|
Catalog page curation |
|
|
|
Catalog sets |
|
|
|
Propagation of data quality flags |
|
|
|
Compose |
|||
On-prem Alation instances |
|
|
|
Alation Cloud Service instances* |
|
|
|
* Compose for data sources connected via Alation Agent is supported from connector version 1.2.11.2455. |
|||
Query Log Ingestion (QLI) |
|||
Table-based |
|
|
|
Query-based |
|
|
|
Filters |
|
|
|
Popularity |
|
|
|
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 |
|
|
|
LDAP |
|
|
|
Technical Metadata |
|||
Tables |
|
|
|
Columns |
|
|
|
Primary keys |
|
|
|
Foreign keys |
|
|
|
Views |
|
|
|
Schemas |
|
|
|
Source comments* |
|
|
|
Synonyms |
|
|
|
Stored procedures |
|
|
|
Lineage |
|||
Lineage for stored procedures(Beta) |
|
|
|
Lineage for functions |
|
|
|
* Source comments are not supported for materialized view. |
|||