2024.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, 24.10

MicroStrategy

Cloud - latest On-prem - 11.3.10, 11.4.06

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, 4.3

SSRS (Without Sharepoint)

2016, 2017, 2019

Tableau

(Tableau Server and Tableau Online)

Server: 2021.3, 2021.4, 2022.1, 2022.3, 2023.1

Online - latest

* Lineage for Dataflows is supported for Alation versions 2023.3.3 or higher.

File System Connectors

Connectors

Supported Version

Metadata Extraction

Schema Extraction

Sampling

Authentication Methods

Amazon S3

latest

*

**

Basic, STS

Azure Blob Storage

latest

Basic, SAS

HDFS

CDH - 6.2, 6.3 CDP - 7.1.3, 7.1.7

Basic, SSL, Kerberos

* 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

Databricks IdP

Amazon Redshift

n/a

n/a

Databricks on AWS

n/a

Azure Databricks

n/a

n/a

Azure Synapse Analysis

n/a

n/a

Azure SQL (SQL DB)

n/a

n/a

Databricks Unity Catalog (Azure)

n/a

Databricks Unity Catalog (AWS)

n/a

n/a

Snowflake

n/a

What is Different Compared to 2023.3?

This table contains the changes compared to the previous release.

Change

Description

Databricks on GCP

Added support for version 13.3 LTS

Databricks on AWS

Added support for version 13.3 LTS

Oracle E-Business Suite

Added support for version 12.2.12

Teradata

Added support for version 17.20

Change Log

This table contains corrections and updates made between major releases.

Date

Change

13/05/24

Added Salesforce, Kafka, DynamoDB and Elasticsearch connectors

03/06/24

Added Azure CosmosDB, ServiceNow, Talend and SSAS connectors

12/06/24

Added MongoDB, TIBCO Data Virtualization, and TIBCO Spotfire connectors

17/07/24

  • Added new version support for SAP BO OCF Connector

  • Added Amazon Redshift Serverless

06/08/24

  • Added Databricks Unity on GCP OCF Connector and Informatica PowerCenter OCF Connector

23/08/24

Added new version support for Looker and MicroStrategy connectors

28/08/24

Added Azure Data Factory (ADF) OCF conector