2023.1 OCF Connectors

Refer to the tables for information on databases, BI tools and file systems supported with OCF connectors. If you find there is no link to the documentation page for a few of the connectors listed, the documentation will be added soon.

RDBMS Connectors

* Lineage is calculated based on queries ingested from Compose.

BI Connectors

Connectors

Supported Version

Metadata Extraction

Lineage

Column Level Lineage

Access Rules

SSL

Looker

latest (cloud), 22.x (on-prem)

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

Azure Blob Storage

latest

Basic, SAS

AWS S3

latest

*

**

Basic, STS

* 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

AWS Redshift

n/a

AWS Databricks

n/a

Azure Databricks

n/a

Azure Synapse

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 Redshift Spectrum, EMR Presto, Databricks GCP, SSRS, Impala on CDP

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

Athena

Added support for Engine Version 3

Databricks 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)