Version 2021.2ΒΆ

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 2021.2. If your Alation instance uses a different release, please refer to the Support Matrix corresponding to this release.

Supported Database (DB) TypesΒΆ

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 / Profiling

QLI*

Popularity

Lineage

Driver

Driver Version

Cassandra

2.1

βœ”

ㄨ

βœ”

ㄨ

ㄨ

ㄨ

native

alation.jdbc.cassandra.CassandraDriver.com.alation.drivers.cassandra.0.1

DB2

10.5, 11.1, 11.5

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

com.ibm.db2.jcc.DB2Driver 10.5

Greenplum

4, 5, 6.3, 6.9

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

PostgreSQL 42.3.3

MemSQL

7

βœ”

βœ”

βœ”

ㄨ

βœ”***

βœ” ***

native

MySQL 8.0 driver

MongoDB

3.6, 4.0, 4.4

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

native

mongo-java-driver 3.8.0

MySQL

5.7, 8.0

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

version 8.0.21

Oracle

12c, 18c, 19c

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

12.1.0.2-tlsPatch

Oracle E-Business Suite

12.2.5

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

12.1.0.2-tlsPatch

PostgreSQL (enterprise)

9.6, 10, 11, 12, 13

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

PostgreSQL 42.3.3

PostgreSQL (open source)

9.6, 10, 11.4, 11.5, 12, 13

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

PostgreSQL 42.3.3

Presto on Hive

0.238.3

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

com.facebook.presto.jdbc.PrestoDriver.presto.jdbc.0.227

Salesforce DB

Winter 2021

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

API

N/A

SAP HANA

2.0

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

version 2.4.70.

SAS Base (data files in SAS server)

9.4

βœ”

βœ”

βœ”

ㄨ

βœ”***

βœ”***

native

com.sas.rio.MVADriver 904300

Snowflake

(AWS, Azure, GCP)

latest available at release date

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

com.snowflake.client.jdbc.SnowflakeDriver version 3.12.16

SQL Server

2012, 2014, 2016, 2017, 2019

βœ”**

βœ”

βœ”

βœ”

βœ”

βœ”

native

com.microsoft.sqlserver.jdbc.SQLServerDriver version 8.2.2.jre11

(supports NTLM)

Sybase ASE

Adaptive Server Enterprise 16.0

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

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

Sybase IQ

16

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

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

Teradata

15.10, 16.10, 16.20, 17.0

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

version 15.10.00.22

Teradata Aster

4.6

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

com.asterdata.ncluster.Driver.teraaster.5.0.3

Vertica

7.2.3

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

version 7.2.1

SOURCES ON AWS RDS

MySQL

5.7. 8.0

βœ”

βœ”

βœ”

ㄨ

βœ”***

βœ”***

native

version 8.0.21

Oracle

12c, 12.2c, 18c, 19c

βœ”

βœ”

βœ”

ㄨ

βœ”***

βœ”***

native

12.1.0.2-tlsPatch.

PostgreSQL (open source)

10.0, 11.4, 11.5, 12, 13

βœ”

βœ”

βœ”

ㄨ

βœ”***

βœ”***

native

PostgreSQL 42.3.3

SQL Server

2012, 2014, 2016, 2017, 2019

βœ”**

βœ”

βœ”

ㄨ

βœ”***

βœ”***

native

com.microsoft.sqlserver.jdbc.SQLServerDriver version 8.2.2.jre11

AMAZON SOURCES

AWS Databricks

7.3, 7.5, 8.0

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

SimbaSparkJDBC-2.6.16.1020

AWS Glue

latest available at release date

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

n/a

API

Amazon Redshift

latest available at release date

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

com.alation.drivers.redshift.FixedRedshiftDriver version 1.2.43.1067

Amazon Redshift Spectrum

latest available at release date

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

com.alation.drivers.redshift.FixedRedshiftDriver version 1.2.43.1067

GOOGLE SOURCES

Google BigQuery

latest available at release date

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

Simba driver for Google BigQuery version 1.2.12.1015

HADOOP SOURCES

Hive on HDP

HDP 2.4, 2.5.3, 2.6.3, 2.6.4, 2.6.5

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

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

Hive on CDH

CDH 5.2 to 5.16, 6.2, 6.3

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

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

Hive on EMR (QLI over FS)

EMR 5.0 to 5.29

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

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

Hive on EMR (QLI over Amazon S3)

EMR 5.0 to 5.29

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

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

Hive on EMR with MapReduce

EMR 5.0 to 5.29

βœ”

βœ”

βœ”

ㄨ

βœ”***

βœ”***

native

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

Hive on EMR with Tez

EMR 5.0 to 5.29

βœ”

βœ”

βœ”

ㄨ

βœ”***

βœ”***

native

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

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

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

Hive on HDP with Tez

HDP 2.4, 2.5.3, 2.6.3, 2.6.4, 2.6.5

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

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

Hive 3 on HDP with Tez

HDP 3.0, 3.1.x

βœ”

βœ”

βœ”

ㄨ

βœ”***

βœ”***

native

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

βœ”

βœ”

βœ”

ㄨ

βœ”***

βœ”***

native

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.0

βœ”

βœ”

βœ”

ㄨ

βœ”***

βœ”***

native

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

Impala

CDH 5.8 to 5.16 6.0 to 6.3

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

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

MS AZURE SOURCES

Azure Synapse Analytics

latest available at release date

βœ”

βœ”

βœ”

ㄨ

βœ”***

βœ”***

native

com.microsoft.sqlserver.jdbc.SQLServerDriver version 8.2.2.jre11

Hive on Azure HDInsight

3.5, 3.6

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

native

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

Hive 3 on Azure HDInsight

4.0

βœ”

βœ”

βœ”

ㄨ

βœ”

βœ”

native

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

Sampling

QLI

Popularity

Lineage

Custom Query Based Column Profiling

Driver

Driver Version

Amazon Athena (Engine version 1)

latest

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

Simba

Simba driver 2.0.9 for Amazon Athena

Azure Databricks

7.4, 7.5, 8.0

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

Simba

SimbaSparkJDBC-2.6.16.1020

Azure Synapse Analytics (Azure DW)

Latest

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

Microsoft

com.microsoft.sqlserver.jdbc. SQLServerDriver version 8.2.2.jre11

Cassandra

3.11

βœ”

βœ”

βœ”

ㄨ

βœ”*

βœ”*

ㄨ

CData

CData cassandra driver 2020

Cosmos DB

latest

βœ”

βœ”

βœ”

ㄨ

βœ”*

βœ”*

ㄨ

CData

CData Cosmos Driver 2020

Denodo

8

βœ”

βœ”

βœ”

ㄨ

ㄨ

ㄨ

βœ”

Denodo

denodo-vdp-jdbcdriver-8.0-ga

Amazon DynamoDB

2019.11.21

βœ”

βœ”

βœ”

ㄨ

βœ”*

βœ”*

βœ”

CData

CData DynamoDB Driver 2020

EMR Presto on Hive with AWS Glue

EMR 6.0, 6.1, 6.2 Presto 0.238.3

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

Facebook

com.facebook.presto.jdbc. PrestoDriver 0.227

EMR SparkSQL on Hive

EMR 6.1, 6.2 Spark 3.x

βœ”

βœ”

βœ”

ㄨ

βœ”*

βœ”*

βœ”

CData

CData SparkSQL Driver 2020

MarkLogic

10.0

βœ”

βœ”

βœ”

ㄨ

βœ”*

ㄨ

βœ”

CData

CData MarkLogic Driver 2020

MongoDB

4.2, 4.4

βœ”

βœ”

βœ”

ㄨ

βœ”*

βœ”*

βœ”

CData

CData MongoDB Driver 2020

MongoDB Atlas on AWS

4.2, 4.4

βœ”

βœ”

βœ”

ㄨ

βœ”*

βœ”*

βœ”

CData

CData MongoDB Driver 2020

Salesforce

Winter 2021

βœ”

βœ”

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

CData

CData SalesforceDB Driver 2020

ServiceNow

Paris

βœ”

βœ”

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

CData

CData ServiceNow Driver 2020

Starburst Enterprise Presto (Trino) on AWS

2020 338-e.0 LTS, 350-e LTS

βœ”

βœ”

βœ”

βœ”

ㄨ

ㄨ

ㄨ

Starburst

presto-cli-350-executable.jar from starburst

* 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

Cassandra

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

βœ”

DB2

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

Greenplum

ㄨ

ㄨ

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

βœ”

MemSQL

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

βœ”

MongoDB

ㄨ

ㄨ

βœ”

ㄨ

βœ”

ㄨ

ㄨ

ㄨ

MySQL

ㄨ

ㄨ

βœ”

ㄨ

βœ”

ㄨ

ㄨ

βœ”

Oracle

ㄨ

ㄨ

βœ”

ㄨ

βœ”

ㄨ

ㄨ

βœ”

Oracle E-Business Suite

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

PostgreSQl (enterprise)

ㄨ

ㄨ

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

βœ”

PostgreSQl (open source)

ㄨ

ㄨ

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

βœ”

Presto over Hive

ㄨ

ㄨ

βœ”

ㄨ

βœ”

ㄨ

ㄨ

ㄨ

Salesforce DB

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

n/a

SAP HANA

ㄨ

ㄨ

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

SAS Base

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

Snowflake

ㄨ

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

SQL Server

ㄨ

βœ”

βœ”

βœ”

βœ”

ㄨ

ㄨ

βœ”

Sybase ASE

ㄨ

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

Sybase IQ

ㄨ

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

Teradata

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

βœ”

Teradata Aster

ㄨ

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

Vertica

ㄨ

ㄨ

βœ”

ㄨ

βœ”

ㄨ

ㄨ

ㄨ

SOURCES ON AWS RDS

MySQL

ㄨ

ㄨ

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

Oracle

ㄨ

ㄨ

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

PostgreSQl (open source)

ㄨ

ㄨ

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

SQL Server

ㄨ

βœ”

βœ”

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

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 Data Warehouse

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

Azure Databricks

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

Azure HDInsight

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

*Permission Mirroring

** Knox, Ranger, Blue Talon, Zookeeper

Note that SASL is only supported for Hive data sources.

Authentication for Custom DBΒΆ

Database

OAuth

OAuth for Compose

Kerberos

Keytab

LDAP

Amazon Athena

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

Azure Databricks

ㄨ

βœ”

ㄨ

ㄨ

ㄨ

Azure Synapse Analytics (Azure DW)

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

Cassandra

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

Cosmos DB

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

Denodo

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

Amazon DynamoDB

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

EMR Presto on Hive with AWS Glue

ㄨ

ㄨ

βœ”

βœ”

βœ”

EMR SparkSQL on Hive

ㄨ

ㄨ

βœ”

βœ”

ㄨ

MongoDB

βœ”

ㄨ

βœ”

ㄨ

ㄨ

MongoDB Atlas on AWS

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

Salesforce

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

ServiceNow

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

Starburst Enterprise Presto (Trino)

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

Authentication for HiveΒΆ

Distribution and Data Platforms

Authentication

Support*

MapR

Basic

βœ”

Kerberos (and keytab)

βœ”

Hive SSL

βœ”

HTTPFS Kerberos

βœ”

Wire-level security

βœ”

SASL

βœ”

HDP

Basic

βœ”

Kerberos (and keytab)

βœ”

Azure Encryption

βœ”

Hive SSL

βœ”

WebHDFS SSL

βœ”

HTTPFS Kerberos

βœ”

Knox Kerberos

βœ”

Knox LDAP

βœ”

Hive Zookeeper URL

βœ”

SASL

βœ”

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

βœ”

EMR with Tez

Kerberos (and keytab)

βœ”

LDAP

βœ”

* 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*

HDP

Basic

βœ”

Kerberos (and keytab)

βœ”

Azure Encryption

βœ” (only in Azure HDP))

Hive SSL

βœ”

WebHDFS SSL

βœ”

HTTPFS Kerberos

βœ”

Knox Kerberos

βœ”

Knox LDAP

βœ”

Hive Zookeeper URL

βœ”

SASL

βœ”

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.

Supported BI ToolsΒΆ

Tool

Supported Version

Metadata Extraction

Lineage

Access Rules

Stats

SSL

Tableau GBM V2*

2018.3, 2019.1, 2019.2, 2019.3, 2019.4, 2020.1, 2020.2, 2020.3, 2020.4

βœ”

βœ”

βœ”

βœ”

βœ”

MicroStrategy**

11.1 (on-prem), 2019 Cloud, 2020 Cloud

βœ”

ㄨ

βœ”

ㄨ

ㄨ

SSRS (without Sharepoint)

2012, 14, 16, 17, 18, 19

βœ”

βœ”

ㄨ

ㄨ

βœ”

SSRS (with Sharepoint)

2012, 16

βœ”

βœ”

ㄨ

ㄨ

βœ”

* From release 2020.4, a Tableau Server BI source can only be added using the GBM V2 framework. Tableau Legacy model is no longer available for new Tableau sources.

** From release 2021.2, MicroStrategy BI source can only be added using the GBM V2 framework.

Supported OCF ConnectorsΒΆ

Connectors

Supported Version

Metadata Extraction

Lineage

Access Rules

Stats

SSL

Looker

Cloud 7.x

βœ”

βœ”

ㄨ

ㄨ

ㄨ

Power BI Pro

latest

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

SAP BO

4.2

βœ”

βœ”

ㄨ

ㄨ

ㄨ

Supported File SystemsΒΆ

File System

Version Supported

Authentication Method

Metadata Extraction

Amazon S3

latest

basic

βœ”

Azure Blob Storage

2018-03-28

basic

βœ”

Azure Data Lake

Gen 1

SSL, AAD*

βœ”

Azure Data Lake

Gen 2**

SSL, AAD*

βœ”

HDFS - CDH

5.2 to 5.16 6.0 to 6.3

SSL, Kerberos

βœ”

HDFS - HDP

2.4, 2.5.3, 2.6.3, 2.6.4, 2.6.5, 3.0.1, 3.1.0, 3.1.4

SSL, Kerberos

βœ”

* Azure Active Directory

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

Supported Docker VersionsΒΆ

Supported OS for the Alation ServerΒΆ

  • CentOS 7.x or 8.x

  • RedHat 7.x or 8.x

  • Ubuntu 16, 18, 20

  • AWS Linux 2

  • Fedora 31, 32, 33

  • Debian 9, 10

  • Oracle Linux on Red Hat Compatible Kernel 7, 8

More information: System Requirements

Supported BrowsersΒΆ

Browser

Version

Chrome

90.0.4430.85

Mozilla Firefox

88

Microsoft Internet Explorer 11

11.0

Microsoft Edge Chromium

90.0.818.42

SSO CatalogΒΆ

Application

Protocol

Ping

SAML 2.0

OKTA

SAML 2.0

OneLogin

SAML 2.0

Azure AD

SAML 2.0

ADFS

SAML 2.0

Auth0

SAML 2.0

SSO - ComposeΒΆ

Database Type

Azure AD

AD FS

OKTA

PingFederate

One Login

Auth0

Snowflake IDP

Amazon Athena

βœ”

βœ”

βœ”

βœ”

βœ”

βœ”

ㄨ

Amazon Redshift

ㄨ

ㄨ

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

Amazon DynamoDB

ㄨ

ㄨ

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

AWS EMR

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

Azure Databricks

βœ”

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

Snowflake

βœ”

βœ”

βœ”

βœ”

ㄨ

ㄨ

βœ”

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 you perform data sampling in Alation, it 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 you with an understanding of what kind of data is contained in the profiled table without the need to run a query.

What Is Different Compared to 2021.2?ΒΆ

This table contains the changes compared to the previous release.

Change

Description

Added support for new data sources as Custom DB

Added MarkLogic

Databricks

Added support for version 8.0

Postgres RDS

Added support for version 13

Salesforce DB

Added support for version 2021 Winter

SAP BO

Supported on OCF

SparkSQL over Hive

Added support for SparkSQL over Hive with Glue on EMR 6.2

SQL Server RDS

Added support for version 2019

Supported OS Versions

Added Fedora 33, OEL 8, and Ubuntu 20

Supported browsers

Updated browser versions

Change LogΒΆ

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

Date

Change

02-06-21

Removed MicroStrategy 2021 Cloud version from Supported BI Tools.

11-03-22

Updated the PostgreSQL driver version for the patch release version 2021.2.13