2023.1 OCF Connectors

The tables below provide information on databases, BI tools, and file systems supported with OCF connectors. Click the connector name to go to the corresponding documentation page. For some of the connectors, where the link is not currently available, documentation will be added soon.

RDBMS Connectors

* Lineage is calculated based on queries ingested from Compose.

** Lineage is calculated using direct lineage extraction.

*** Extraction of view SQL during MDE is not supported. Lineage information is generated from DDL queries ingested during QLI and DDL queries run in Compose.

BI Connectors

Connectors

Supported Version

Metadata Extraction

Lineage

Column Level Lineage

Access Rules

SSL

Looker

Cloud - latest, On-prem - 22.x, 23.x

Power BI on Azure

latest

Power BI Scanner on Azure

Power BI Pro and Premium versions

*

Qlik Sense

Feb 2022 and earlier versions

SAP BO

4.2

SSRS (Without Sharepoint)

2016, 2017, 2019

Tableau

(Tableau Server and Tableau Online)

Server: 2021.3, 2021.4, 2022.1, 2022.3

Online - latest

* Full Lineage support for Power BI objects, such as reports, tiles, and dashboards. Limited lineage support for datasource and dataset.

File System Connectors

Connectors

Supported Version

Metadata Extraction

Schema Extraction

Sampling

Authentication Methods

Amazon S3

latest

*

**

Basic, STS

Azure Blob Storage

latest

Basic, SAS

* Schema extraction is supported only for CSV and Parquet files

** File sampling is supported only for CSV and Parquet files

SSO with Compose

Database Type

Azure AD

AD FS

OKTA

PingFederate

One Login

Auth0

Snowflake IdP

Amazon Redshift

n/a

Databricks on AWS

n/a

Azure Databricks

n/a

Azure Synapse Analysis

n/a

Azure SQL (SQL DB)

n/a

Databricks Unity Catalog (Azure)

n/a

Snowflake

What is Different Compared to 2022.4?

This table contains the changes compared to the previous release.

Change

Description

Added support for new OCF connectors

Added Amazon Redshift Spectrum, EMR Presto, Databricks on GCP, SSRS, Impala on CDP, Starburst Enterprise (Trino)

PostgreSQL EC2

Added support for version 15.1

PostgreSQL RDS

Added support for version 14.5

Vertica

Added support for version 12.0.1

SQLServer EC2

Added support for version 2022

SQLServer On Azure VM

Added support for version 2022

Greenplum

Added support for version 6.22

Tableau Server

Added support for version 2022.3

Hive 3 on EMR

Added support for version 6.9

Amazon Athena

Added support for Engine Version 3

Databricks on AWS

Added support for Version 11.x

Column-level lineage (CLL)

Added CLL support for Databricks AWS, Databricks Azure, Azure Government Cloud, PostgreSQL (EC2, RDS and Enterprise), Tableau Server and Tableau Online

Feature support

Added QLI support for MySQL RDS, SQL Server RDS, Oracle RDS

Feature support

Added Sampling support for Databricks Unity Catalog, Azure Blob Storage

Feature support

Added Compose support for Databricks Unity Catalog

SSO Compose

Updated SSO Compose support for Databricks Unity Catalog (Azure)

Change Log

This table contains corrections and updates made between major releases.

Date

Change

07/06/23

A correction to lineage support for Starburst Enterprise. Currently, extraction of view SQL during MDE is not supported.

19/05/23

Added table-level lineage support for SAP BW and SAP ECC connector.

05/16/23

  • Update to information about lineage support for Databricks Unity Catalog: lineage is supported with the direct lineage extraction feature that does not require QLI.

  • Documentation links added for more sources.

06/06/23

Added support for Databricks Unity Catalog version 12.x