2024.3 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¶

Connectors	Supported Version	Table Level Lineage	Column Level Lineage
Amazon Athena	Engine versions 2, 3
Redshift OCF Connector
Amazon Redshift Provisioned	latest
Amazon Redshift Provisioned with Spectrum	latest
Amazon Redshift Serverless	latest
Amazon Redshift Serverless with Spectrum	latest
AWS Glue	latest
Azure CosmosDB
Azure Data Factory	Snowflake: 8.30.1 Oracle: 19c SQL Server: 2019 Azure SQL DB: 12.0.2000.8
Azure SQL DB	latest
Azure SQL Managed Instance	12.0.2000.8
Azure Synapse Analytics	latest
Databricks OCF Connector
Databricks on AWS	9.1 LTS, 10.4 LTS, 11.x, 12.x, 13.3 LTS
Databricks Azure	9.1 LTS, 10.4 LTS, 11.x, 12.x
Databricks on Google Cloud	9.1 LTS, 10.4 LTS, 11.3 LTS, 12.x, 13.3 LTS	*
Databricks Unity Catalog
Databricks Unity Catalog on AWS	10.4 LTS, 11.x, 12.x	**	**
Databricks Unity Catalog on Azure	10.4 LTS, 11.x, 12.x	**	**
Databricks Unity Catalog on GCP	13.3, 14.3	**	**
Databricks Azure on Government Cloud	10.4 LTS, 11.x, 12.x
DB2	10.5, 11.1, 11.5
Denodo	8
Amazon DynamoDB
Elasticsaerch	6.0 and later
EMR Presto	EMR 6.0, 6.1, 6.2, 6.4, 6.9
Google BigQuery	latest
Greenplum	6.22
Hive OCF Connector
Hive 2 on CDH	CDH 6.2, 6.3
Hive 2 on EMR	EMR 5.x
Hive 2 on MapR	MapR 6.1.x
Hive 3 on CDH	HDP 3.1.4
Hive 3 on EMR	EMR 6.0, 6.1, 6.2, 6.4, 6.9
Hive 3 on CDP	CDP 7.1.3, 7.1.7
Hive 3 on Azure HDInsight	4.0, 5.0
Impala on CDH	CDH - 6.3
Impala on CDP	7.1.3, 7.1.7
Informatica PowerCenter	Oracle: 19c SQL Server: 2022 Informatica PowerCenter Version: Oracle repo 10.5.4 SQL Server repo 10.5.4
Informatica CDI	latest
Kafka	Apache Kafka 2.7.x to 3.6.x Confluent: 6.1.x to 7.6.x
MongoDB	2.6 to 5.0 MongoDB Atlas, MongoDB Compass
MySQL OCF Connector
MySQL	8.0
MySQL RDS	8.0
Oracle OCF Connector
Oracle	19c
Oracle RDS	19c
Oracle E-Business Suite	EBS 12.2.12 Oracle 19c
PostgreSQL OCF Connector
PostgreSQL	12, 13, 14.1, 14.5, 15.1
PostgreSQL RDS	12, 13, 14.1, 14.5
PostgreSQL Enterprise	12, 13, 14.1
Salesforce	latest
SAP ASE	ASE 16.0
SAP BW	n/a	**
SAP ECC	n/a	**
SAP HANA	2.0
SAP IQ	16
SAS Base	9.4	*
ServiceNow
SingleStore (former MemSQL)	7.8.9	*
Snowflake (AWS, Azure, GCP)	latest
SQL Server Analysis Services (SSAS)
SQL Server OCF Connector
SQL Server	2014, 2016, 2017, 2019, 2022
SQL Server RDS	2014, 2016, 2017, 2019
SQL Server on Azure VM	2017, 2019, 2022
Starburst Enterprise (Trino)	413-e LTS on AWS	***
Talend
Teradata	16.10, 16.20, 17.05, 17.20
TIBCO Data Virtualization	7.0.6 and later
TIBCO Spotfire	Version 12, 14
Vertica	11.1.x, 12.0.1
Workday	v42.1 wsdl version for SOAP interaction

* 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	Lineage	Column Level Lineage
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.

** Column-level lineage is supported only for SQL Server when the field names are same for RDBMS table columns, dataset fields and report fields.

*** Report Lineage and Column-level Lineage are supported for the following data sources: MySQL, SQL Server, Snowflake, Oracle, PostgreSQL, Redshift, Databricks and Google BigQuery. However, Column-level lineage is supported for Databricks and Google BigQuery only when the database column and explore field name are same.

File System Connectors¶

Connectors	Supported Version	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

ELT Connectors¶

Connectors	Supported Version	Metadata Extraction (MDE)	Table Sampling	Profiling	Query Log Ingestion (QLI)	Table Level Lineage	Column Level Lineage	Compose
Fivetran		NA	NA	NA	NA			NA

SSO with Compose¶

Database Type	Azure AD	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 2024.1?¶

This table contains the changes compared to the previous release.

Change	Description
Looker	Added support for version 24.1.0

Change Log¶

This table contains corrections and updates made between major releases.

Date	Change
12/09/24	Added Informatica CDI OCF connector
04/10/24	Added CLL support for SSRS OCF connector
17/10/24	Added CLL support for Looker OCF Connector
24/10/24	Added Workday OCF Connector
12/11/24	Added Fivetran OCF Connector