Version 2022.3

Available from release 2022.3.5

Refer to the tables below for information on supported database, file system, and BI tool types and versions.

Important

Alation has certified support for versions in this matrix with release 2022.3. If your Alation instance uses a different release, please refer to the Support Matrix corresponding to this release.

Supported Database (DB) Types

The database types in this table can be added using native (built-in) drivers.

Note that Query Log Ingestion (QLI) is not currently supported for data sources deployed on AWS RDS.

Database Type

Version Supported

Metadata Extraction

Compose

Sampling

QLI*

Popularity

Lineage

Column Level Lineage

Driver Version

DB2 (LUW)

10.5, 11.1, 11.5

com.ibm.db2.jcc.DB2Driver 11.5

Greenplum

5, 6

PostgreSQL 42.3.3

MongoDB

4.4

mongo-java-driver 3.8.0

Oracle

19c

19.1

Oracle E-Business Suite

12.2.5

19.1

EMR Presto on Hive

Presto 0.238.3

EMR 6.0, 6.1, 6.2, 6.4

com.facebook.presto.jdbc.PrestoDriver.presto.jdbc.0.265.1

Salesforce DB

Summer 2021

n/a

SAP HANA

2.0

version 2.4.70

SAS Base (data files in SAS server)

9.4

***

***

com.sas.rio.MVADriver 904300

SingleStore ( Former MemSQL)

7

***

***

MySQL 8.0 driver

Snowflake

(AWS, Azure, GCP)

latest available at release date

net.snowflake.client.jdbc.SnowflakeDriver version 3.12.14

Sybase ASE

Adaptive Server Enterprise 16.0

com.alation.drivers.sybase.FixedSybaseDriver.com.alation.drivers.sybase.4

Sybase IQ

16

com.alation.drivers.sybase.FixedSybaseDriver.com.alation.drivers.sybase.4

Teradata

16.10, 16.20, 17.0

version 17.00.00.03

SOURCES ON AWS RDS

Oracle

19c

***

***

19.1

AMAZON SOURCES

AWS Databricks

9.1 LTS

SimbaSparkJDBC-2.6.21

AWS Glue

latest available at release date

API

Amazon Redshift

latest available at release date

com.alation.drivers.redshift.FixedRedshiftDriver version 1.2.43.1067

Amazon Redshift Spectrum

latest available at release date

com.alation.drivers.redshift.FixedRedshiftDriver version 1.2.43.1067

GOOGLE SOURCES

Google BigQuery

latest available at release date

Simba driver for Google BigQuery version 1.2.19.1023

HADOOP SOURCES

Hive on CDH

CDH 6.2, 6.3

com.alation.drivers.hive.Hive2Driver.com.alation.drivers. hive.zero.fourteen.0.14.0-0.14.0

Hive with AWS Glue as Metastore

latest available at release date

com.alation.drivers.hive.Hive2Driver.com.alation.drivers. hive.zero.fourteen.0.14.0-0.14.0

Hive 3 on EMR with Tez

EMR 6.0, 6.4

***

***

com.alation.drivers.hive.Hive2Driver.com.alation.drivers. hive.zero.fourteen.0.14.0-0.14.0

Hive 3 on CDP with Tez

CDP 7.1.3, 7.1.7

***

***

com.alation.drivers.hive.Hive2Driver.com.alation.drivers. hive.zero.fourteen.0.14.0-0.14.0

Impala

CDH 6.3

com.alation.drivers.hive.Hive2Driver.com.alation.drivers. hive.two.2.1.0-2.1.0

MS AZURE SOURCES

Hive on Azure HDInsight

3.6

com.alation.drivers.hive.Hive2Driver.com.alation.drivers. hive.zero.fourteen.0.14.0-0.14.0

Hive 3 on Azure HDInsight

4.0

com.alation.drivers.hive.Hive2Driver.com.alation.drivers. hive.zero.fourteen.0.14.0-0.14.0

* Query Log Ingestion (QLI). Note that Alation does not support QLI for data sources on RDS.

** Case sensitivity is not supported.

*** Lineage and Popularity are calculated based on queries ingested from Compose.

Data Sources Supported as Custom DB

Note that CData drivers can be purchased from Alation. See CData Drivers for details.

Database Type

Version Supported

Metadata Extraction

Compose

Profiling

Sampling

QLI

Popularity

Lineage

Custom Query Based Column Profiling

Column Level Lineage

Driver

Driver Version

Amazon Athena

Engine versions 1, 2

Simba

Athena Simba driver 2.0.9

Azure Synapse Analytics (Azure DW)

latest

Microsoft

com.microsoft.sqlserver.jdbc. SQLServerDriver.com.microsoft. sqlserver.9.4.0.jre11

Cassandra

3.11, 4.0.1

*

*

CData

CData Cassandra driver 2021

Confluent Kafka

2.7.x

CData

CData Kafka driver 2021

Cosmos DB

latest

*

*

CData

CData Cosmos driver 2021

CSV

n/a

CData

CData CSV driver 2021

Databricks Azure

9.1 LTS

Simba

SimbaSparkJDBC-2.6.21

Databricks GCP

9.1 LTS, 10.4 LTS

*

*

Simba

SimbaSparkJDBC-2.6.21

Denodo

8

Denodo

denodo-vdp-jdbcdriver-8.0-ga

Amazon DynamoDB

2019.11.21

*

*

CData

CData DynamoDB driver 2021

ElasticSearch

6.0

CData

CData ElasticSearch driver 2021

EMR Presto on Hive

EMR 6.0, 6.1, 6.2, 6.4

Presto 0.238.3

Facebook

com.facebook.presto.jdbc. PrestoDriver 0.265.1

EMR Presto on Hive with AWS Glue

EMR 6.0, 6.1, 6.2, 6.4

Presto 0.238.3

Facebook

com.facebook.presto.jdbc. PrestoDriver 0.265.1

EMR SparkSQL on Hive

EMR 6.1, 6.2, 6.4 Spark 3.x

*

*

CData

CData SparkSQL driver 2020

GitHub (Beta)

3.x

CData

CData GitHub driver 2021

MariaDB

latest

CData

CData MariaDB driver 2021

MarkLogic

10.0

*

CData

CData MarkLogic driver 2020

MongoDB

4.2, 4.4

*

*

CData

CData MongoDB driver 2021

MongoDB Atlas on AWS

4.2, 4.4

*

*

CData

CData MongoDB driver 2021

NetSuite

2021.2

CData

CData NetSuite driver 2021

Parquet (Amazon S3)

Apache Parquet API V2.0

*

CData

CData Parquet driver 2021

Parquet (ADLS Gen2)

Apache Parquet API V2.0

*

CData

CData Parquet driver 2021

Salesforce

Summer 2021

CData

CData SalesforceDB driver 2021

ServiceNow

latest

CData

CData ServiceNow driver 2021

Splunk

8.2.x

CData

CData Splunk driver 2021

SSAS

2014, 2016

CData

CData SSAS driver 2021

Starburst Enterprise (Trino)

380-e LTS on AWS

Trino driver

Trino JDBC 385 (trino-jdbc-385.jar)

* Lineage and Popularity are calculated based on queries ingested from Compose.

Supported DB Authentication Methods

Note that for all database types listed in this table, Alation supports basic authentication, and users can connect with their database credentials (database account login and password). The table focuses on specific authentication methods which our customers usually ask about.

Database Type

PM*

Cross DB

SSL

NTLM

Kerberos

Proxy Access**

Keytab

LDAP

DB2 (LUW)

Greenplum

MongoDB

Oracle

Oracle E-Business Suite

EMR Presto on Hive

Salesforce DB

n/a

SAP HANA

SAS Base

SingleStore (Former MemSQL)

Snowflake

Sybase ASE

Sybase IQ

Teradata

SOURCES ON AWS RDS

Oracle

AMAZON SOURCES

AWS Databricks

AWS Glue

Amazon Redshift

n/a

Amazon Redshift Spectrum

n/a

GOOGLE SOURCES

Google BigQuery

HADOOP SOURCES

Hive

Authentication for Hive

Authentication for Hive 3

Impala

SparkSQL over Hive Metastore

MS AZURE SOURCES

Azure Databricks

Azure HDInsight

*Permission Mirroring

** Knox, Ranger, Blue Talon, Zookeeper

Note that SASL is only supported for Hive data sources.

Note

From 2022.1, key pair authentication is supported for Snowflake.

Authentication for Custom DB

Database

OAuth

OAuth for Compose

Kerberos

Keytab

LDAP

Amazon Athena

Azure Synapse Analytics (Azure DW)

Cassandra

Confluent Kafka

Cosmos DB

CSV

Databricks Azure

Databricks GCP

Denodo

Amazon DynamoDB

ElasticSearch

EMR Presto on Hive

EMR Presto on Hive with AWS Glue

EMR SparkSQL on Hive

GitHub (Beta)

MariaDB

MarkLogic

MongoDB

MongoDB Atlas on AWS

NetSuite

Parquet (Amazon S3)

Parquet (ADLS Gen2)

Salesforce

ServiceNow

Splunk

Starburst Enterprise (Trino)

Authentication for Hive

Distribution and Data Platforms

Authentication

Support*

CDH

Basic

Kerberos (and keytab)

Hive SSL

WebHDFS SSL

HTTPFS Kerberos

Hive Zookeeper URL

SASL

EMR

Basic

Kerberos (and keytab)

Hive SSL

WebHDFS SSL

SASL

* Support of authentication methods depends on your Hive setup. This table shows all the authentication methods Alation can potentially support for Hive. For more details on Hive data sources, refer to Hive.

Authentication for Hive 3

Distribution and Data Platforms

Authentication

Support*

CDP

Basic

Kerberos (and keytab)

**

Azure Encryption

Hive SSL

WebHDFS SSL

HTTPFS Kerberos

Knox Kerberos

Knox LDAP

Hive Zookeeper URL

SASL

EMR

Basic

Kerberos (and keytab)

Azure Encryption

Hive SSL

WebHDFS SSL

HTTPFS Kerberos

Knox Kerberos

Knox LDAP

Hive Zookeeper URL

SASL

* Support of authentication methods depends on your Hive setup. This table shows all the authentication methods Alation can potentially support for Hive. For more details on Hive data sources, refer to Hive.

** Hive and Hadoop Version should be set to 2.x.x in the Add a Data Source wizard - CONNECTION section to connect to CDP with Kerberos authentication enabled.

Supported BI Tools

Tool

Supported Version

Metadata Extraction

Lineage

Access Rules

Stats

SSL

Tableau Server GBM V2*

2020.4, 2021.1, 2021.2, 2021.3, 2021.4, 2022.1

MicroStrategy GBM V2

2020 Cloud

SSRS (without Sharepoint)

2014, 2016, 2017, 2019

SSRS (with Sharepoint)

2016

* Tableau Online is not supported.

Supported OCF Connectors

BI Connectors

Connectors

Supported Version

Metadata Extraction

Lineage

Column Level Lineage

Access Rules

Stats

SSL

Looker

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

Power BI

latest

Power BI Scanner API

Power BI Pro and Premium versions

*

SAP BO

4.2

Tableau (Server and Online)

Server - 2021.3, 2021.4, 2022.1

Online - latest

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

RDBMS Connectors

Connectors

Version Supported

Metadata Extraction

Compose

Sampling

Column Profiling V1

Column Profiling V2

QLI*

Popularity

Lineage

Column Level Lineage

Driver

Driver Version

AWS Glue

latest

API

n/a

Azure SQL DB

latest

native

Microsoft JDBC driver for SQL Server - 9.4.0.jre11

Azure SQL Managed Instance

12.0.2000.8

native

Microsoft JDBC driver for SQL Server - 9.4.0.jre11

Azure Synapse

latest

native

Microsoft JDBC driver for SQL Server - 10.2.0.jre11

Databricks AWS

9.1 LTS, 10.4 LTS

native

SimbaSparkJDBC-2.6.21

Databricks Azure

9.1 LTS, 10.4 LTS

native

SimbaSparkJDBC-2.6.21

Databricks Azure on Azure Government Cloud

10.4 LTS

native

SimbaSparkJDBC-2.6.21

DB2

10.5, 11.1, 11.5

native

IBM Data Server driver for JDBC and SQLJ - 11.5

Greenplum

5, 6.3, 6.9

native

PostgreSQL 42.3.3

Informatica Power Center

Oracle - 12.1c, 19c

DB2 - 10.x, 11.1

SQL Server - 2017, 2019

native

Ojdbc8 - 21.4.0.0.1,

IBM Data Server Driver for JDBC and SQLJ - 11.5.7.0,

Microsoft JDBC Driver For SQL Server - 7.0.0.jre8

MySQL

5.7, 8.0

native

MySQL Connector/J - 8.0.29

MySQL RDS

5.7, 8.0

**

**

native

MySQL Connector/J - 8.0.29

Oracle

19c

native

12.1.0.2-tlsPatch

Oracle RDS

19c

**

**

native

12.1.0.2-tlsPatch

PostgreSQL

10, 11.4, 11.5, 12, 13, 14.1

native

version 42.3.3

PostgreSQL RDS

10, 11.4, 11.5, 12, 13, 14.1

native

version 42.3.3

PostgreSQL Enterprise

10, 11, 12, 13, 14.1

native

version 42.3.3

Amazon Redshift

latest

native

version 1.2.43.1067

SAP BW or SAP BW/4HANA

latest

API

n/a

SAP ECC

latest

SDK

n/a

SAP HANA

2.0

native

com.sap.cloud.db.jdbc - ngdbc - 2.12.9 (SAP HANA JDBC Driver)

SAS Base

9.4

**

**

native

SAS drivers for JDBC and SAS/ CONNECT - Release 9.46 - 94280 (com.sas.rio.MVADriver.com. alation.drivers.sas.94280)

Snowflake (AWS, Azure, GCP)

latest

native

Snowflake JDBC Driver - 3.12.14

SQL Server on Azure VM

2017, 2019

native

Microsoft JDBC driver for SQL Server - 9.4.0.jre11

SQL Server

2014, 2016, 2017, 2019

native

Microsoft JDBC driver for SQL Server - 9.4.0.jre11

SQL Server RDS

2014, 2016, 2017, 2019

native

Microsoft JDBC driver for SQL Server - 9.4.0.jre11

Sybase

Sybase IQ 16

native

com.sybase.jdbc4.jdbc.SybDriver (Sybase driver 4)

Teradata

16.10, 16.20, 17.05

native

Teradata JDBC Driver - 17.10.00.27

Vertica

11.1.x

native

Vertica 11.1.0-0

* Query Log Ingestion (QLI). Note that Alation does not support QLI for data sources on RDS.

** Lineage and Popularity are calculated based on queries ingested from Compose.

File System Connectors

Connectors

Supported Version

Metadata Extraction

Sampling

Authentication Methods

Amazon S3

latest

*

Basic, STS

* File sampling is supported only for CSV and Parquet files

Supported File Systems

File System

Version Supported

Authentication Method

Metadata Extraction

Amazon S3

latest

basic, IAM Role

Azure Blob Storage

2018-03-28

basic

Azure Data Lake

Gen 1

SSL, AAD*

Azure Data Lake

Gen 2**

SSL, AAD*

HDFS - CDH

6.3

SSL, Kerberos

HDFS - CDP

7.1.3, 7.1.7

SSL, Kerberos

* Azure Active Directory

** ADLS Gen 2 can be added using the Azure Blob Storage native connector.

Supported Docker Versions

Supported OS Versions

Operating System

Supported Version

Alation Server

Alation Agent

OCF

Alation Analytics

Sandbox

CentOS (rpm)

7.x, x86 64-bit

Red Hat (rpm)

7.x, x86 64-bit 8.x, x86 64-bit 8.5, x86 64-bit

Ubuntu (deb)

16, 18, 20

AWS Linux

2

Fedora

33, 34

Debian

9, 10

Oracle Linux on Red Hat-compatible Kernel

7, 8, 8.5

More information: System Requirements

Supported Browsers

Browser

Version

OS Version

Chrome

103.0.5060.114

Windows 10

Mozilla Firefox

102.0

Windows 10

Microsoft Edge Chromium

103.0.1264.62

Windows 10

SSO Catalog

Application

Protocol

Ping

SAML 2.0

OKTA

SAML 2.0

OneLogin

SAML 2.0

Azure AD

SAML 2.0

AD FS

SAML 2.0

Auth0

SAML 2.0

Auth0

OAuth 2.0 / OpenID Connect 2.0

SSO - Compose (Native and Custom DB Connectors)

Database Type

Azure AD

AD FS

OKTA

PingFederate

One Login

Auth0

Snowflake IdP

Amazon Athena

Amazon Redshift

Amazon DynamoDB

AWS EMR

Azure Databricks

Azure Synapse Analytics (DW)

Azure SQL (SQL DB)

Snowflake

CSV

SSO - Compose (OCF Connectors)

Database Type

Azure AD

AD FS

OKTA

PingFederate

One Login

Auth0

Snowflake IdP

Amazon Redshift

Azure Databricks

Azure Synapse

Azure SQL (SQL DB)

Snowflake

MDE - AuthService (Native and Custom DB Connectors)

MDE and Profiling with IAM Role.

Connector

Basic Auth (IAM User)

IAM Role

Amazon Athena

*

Amazon Redshift

*

Amazon DynamoDB

AWS Glue

Amazon S3

*

* This feature is Beta - 2021.3 and above.

Provisioning

Authentication Mode

Provisioning Mode

IdP(s)

LDAP

LDAP API

Active Directory, Open LDAP

SAML

SCIM

Okta

SAML

SCIM

Ping Federate

SAML

SCIM

Azure Active Directory

SAML

LDAP API

Okta(IdP) + Active Directory (User repository)

Definitions

Compose: the Alation query tool for authoring, running, and publishing SQL queries to the data catalog.

Lineage: visual representation of how tables, views, and BI reports are derived from source tables.

Metadata Extraction: extraction of metadata from a source into the catalog with the goal of synchronizing them and providing catalog users with a representation of the data contained in this source. Metadata extraction can be run manually or on an automatic schedule that depends on your organization’s needs and usage.

Popularity: an indicator of the popularity (intensity of use) of a data object, such as a table or a column. Popularity is calculated through an algorithm that analyzes both the results of Query Log Ingestion and Compose usage to determine the number of Alation users that have used the object and the number of times the object has been used.

Query Log Ingestion (QLI): processing of a selection of database query logs by Alation in order to calculate Popularity, Top Users, and supply JOIN information to the catalog.

Sampling: creation of data samples for the cataloged data sources. When users perform sampling, Alation scans the first 10,000 rows of a table. A data sample is a random sample of 100 rows out of those 10,000 scanned rows intended to provide an insight into data in tables.

Profiling V2 or deep column profiling: retrieval of a data sample based on a default or custom query and statistical calculations on this sample. The profiling results are represented on the Frequency Distribution chart for a column.

What is Different Compared to 2022.2?

This table contains the changes compared to the previous release.

Change

Description

Added support for new OCF Connectors

Added PostgreSQL Enterprise, Greenplum, SAP Hana, Vertica, Teradata, Azure Databricks, Azure Databricks on Government Cloud, Informatica Power Center, SAP ECC , Tableau (Server and Online), Azure SQL Managed Instance, Snowflake

Added support for new data sources as CustomDB

Added SSAS, CSV

Driver upgrades

Upgraded Snowflake, MySQL, and Starburst Trino driver

SQL Server RDS (OCF)

Added support for version 2019

Starburst Trino

Added support for version 380 -e LTS

Supported browsers

Updated browser versions

Removed from the list of supported sources (These connectors are removed from the built-in sources, however can be added with OCF.)

Vertica, Azure SQL Data Warehouse, MySQL, SQL Server, SQL Server RDS ,PostgreSQL (enterprise), PostgreSQL EC2, PostgreSQL RDS

Change Log

This table contains corrections made between major releases when Alation finds issues with support of versions announced earlier.

Date

Change

30-09-22

Added Amazon S3 file system connector for the patch release 2022.3.5.