Version 2020.4

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

Cassandra

2.1

✔

ㄨ

✔

ㄨ

ㄨ

ㄨ

native

DB2

10, 11

✔

✔

✔

✔

✔

✔

native

Greenplum

4, 5, 6.3, 6.9

✔

✔

✔

✔

✔

✔

native

MemSQL

5.8.0

✔

✔

✔

ㄨ

✔***

✔ ***

native

MongoDB

3.2, 3.4, 3.6, 4.0

✔

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

native

MySQL

5.7, 8.0

✔

✔

✔

✔

✔

✔

native

Oracle

11gR2, 12c, 18c, 19c

✔

✔

✔

✔

✔

✔

native

Oracle E-Business Suite

12.2.5

✔

✔

✔

✔

✔

✔

native

PostgreSQL (enterprise)

9.6, 10, 11, 12

✔

✔

✔

✔

✔

✔

native

PostgreSQL (open source)

9.5, 9.6, 10, 11.4, 11.5, 12, 13

✔

✔

✔

✔

✔

✔

native

Presto on Hive

0.230

✔

✔

✔

✔

✔

✔

native

Salesforce DB

winter 2020

✔

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

API

SAP HANA

2.0

✔

✔

✔

✔

✔

✔

native

SAS Base (data files in SAS server)

9.4

✔

✔

✔

ㄨ

✔***

✔***

native

Snowflake

latest available at release date

✔

✔

✔

✔

✔

✔

native

SQL Server

2012, 2014, 2016, 2017, 2019

✔**

✔

✔

✔

✔

✔

native jtds

Sybase ASE

Adaptive Server Enterprise 16.0

✔

✔

✔

✔

✔

✔

native

Sybase IQ

v 16

✔

✔

✔

✔

✔

✔

native

Teradata

15.10, 16.10, 16.20

✔

✔

✔

✔

✔

✔

native

Teradata Aster

4.6

✔

✔

✔

✔

✔

✔

native

Vertica

7.2.3

✔

✔

✔

✔

✔

✔

native

SOURCES ON AWS RDS

MySQL

5.7. 8.0

✔

✔

✔

ㄨ

✔***

✔***

native

Oracle

11, 12c, 12.2c, 18c, 19c

✔

✔

✔

ㄨ

✔***

✔***

native

PostgreSQL (open source)

9.5, 10.0, 11.4, 11.5, 12

✔

✔

✔

ㄨ

✔***

✔***

native

SQL Server

2012, 2014, 2016, 2017

✔**

✔

✔

ㄨ

✔***

✔***

native

AMAZON SOURCES

AWS Databricks

6.4, 6.5, 6.6, 7.0

✔

✔

✔

✔

✔

✔

native

AWS Glue

latest available at release date

✔

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

native

Amazon Redshift

latest available at release date

✔

✔

✔

✔

✔

✔

native

Amazon Redshift Spectrum

latest available at release date

✔

✔

✔

✔

✔

✔

native

GOOGLE SOURCES

Google BigQuery

latest available at release date

✔

✔

✔

✔

✔

✔

native

HADOOP SOURCES

Hive on HDP

HDP 2.4, 2.5.3, 2.6.3, 2.6.4, 2.6.5

✔

✔

✔

✔

✔

✔

native

Hive on CDH

CDH 5.2 to 5.16, 6.2, 6.3

✔

✔

✔

✔

✔

✔

native

Hive on EMR (QLI over FS)

EMR 5.0 to 5.29

✔

✔

✔

✔

✔

✔

native

Hive on EMR (QLI over Amazon S3)

EMR 5.0 to 5.29

✔

✔

✔

✔

✔

✔

native

Hive on EMR with MapReduce

EMR 5.0 to 5.29

✔

✔

✔

ㄨ

✔***

✔***

native

Hive on EMR with Tez

EMR 5.0 to 5.29

✔

✔

✔

ㄨ

✔***

✔***

native

Hive with AWS Glue as Metastore

2017-03-31

✔

✔

✔

✔

✔

✔

native

Hive on HDP with Tez

HDP 2.4, 2.5.3, 2.6.3, 2.6.4, 2.6.5

✔

✔

✔

✔

✔

✔

native

Hive 3 on HDP with Tez

HDP 3.0, 3.1.x

✔

✔

✔

ㄨ

✔***

✔***

native

Hive 3 on EMR with Tez

EMR 6.0

✔

✔

✔

ㄨ

✔***

✔***

native

Hive 3 on CDP with Tez

CDP 7.0

✔

✔

✔

ㄨ

✔***

✔***

native

Impala

CDH 5.8 to 5.16 6.0 to 6.3

✔

✔

✔

✔

✔

✔

native

SparkSQL over Hive Metastore

CDH 5.8 to 5.16 HDP 2.4, 2.5, 2.6.5

✔

✔

✔

ㄨ

ㄨ

ㄨ

native

MS AZURE SOURCES

Azure SQL Data Warehouse

latest avaialble at release date

✔

✔

✔

ㄨ

✔***

✔***

native

Hive on Azure HDInsight

3.5, 3.6

✔

✔

✔

✔

✔

✔

native

Hive 3 on Azure HDInsight

4.0

✔

✔

✔

ㄨ

✔

✔

native

* 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

Database Type

Version Supported

Metadata Extraction

Compose

Sampling

QLI

Popularity

Lineage

Custom Query Based Column Profiling

Driver

Amazon Athena

latest

✔

✔

✔

✔

✔

✔

ㄨ

Simba

Azure Databricks

6.4, 6.5, 6.6, 7.0

✔

✔

✔

✔

✔

✔

✔

Simba

Cassandra

3.11

✔

✔

✔

ㄨ

✔*

✔*

ㄨ

CData

Cosmos DB

latest

✔

✔

✔

ㄨ

✔*

✔*

ㄨ

CData

Denodo

7.0.3

✔

✔

✔

ㄨ

ㄨ

ㄨ

✔

Denodo

Amazon DynamoDB

V2019.11.21

✔

✔

✔

ㄨ

✔*

✔*

✔

CData

EMR Presto on Hive with AWS Glue

EMR 5.29, 6.0 Presto 0.230

✔

✔

✔

✔

✔

✔

✔

Facebook

MongoDB

4.2

✔

✔

✔

ㄨ

✔*

✔*

✔

CData

MongoDB Atlas on AWS

4.2

✔

✔

✔

ㄨ

✔*

✔*

✔

CData

Salesforce

Winter 2020

✔

✔

✔

ㄨ

ㄨ

ㄨ

ㄨ

CData

ServiceNow

Paris

✔

✔

✔

ㄨ

ㄨ

ㄨ

ㄨ

CData

* 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

ㄨ

✔

ㄨ

ㄨ

ㄨ

Cassandra

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

Cosmos DB

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

Denodo

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

Amazon DynamoDB

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

EMR Presto on Hive with AWS Glue

ㄨ

ㄨ

✔

✔

✔

MongoDB

✔

ㄨ

✔

ㄨ

ㄨ

MongoDB Atlas on AWS

ㄨ

ㄨ

ㄨ

ㄨ

ㄨ

Salesforce

✔

ㄨ

ㄨ

ㄨ

ㄨ

ServiceNow

✔

ㄨ

ㄨ

ㄨ

ㄨ

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*

10.5.3, 2018.1, 2018.3, 2019.1, 2019.2, 2019.3, 2019.4, 2020.1, 2020.2, 2020.3

✔

✔

✔

✔

✔

MicroStrategy

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

✔

ㄨ

✔

ㄨ

ㄨ

SFDC Einstein Analytics

Winter 2020 REST API 41.0

✔

✔

ㄨ

ㄨ

ㄨ

SSRS (without Sharepoint)

2012, 14, 16, 17 2018, 19

✔

✔

ㄨ

ㄨ

✔

SSRS (with Sharepoint)

2012, 16

✔

✔

ㄨ

ㄨ

✔

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

Supported OCF Connectors

Connectors

Supported Version

Metadata Extraction

Lineage

Access Rules

Stats

SSL

Looker

Cloud 7.x

✔

✔

ㄨ

ㄨ

ㄨ

Power BI Pro

latest

✔

✔

ㄨ

ㄨ

ㄨ

Tableau

2019.4, 2020.2, 2020.3

✔

✔

✔

ㄨ

✔

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 OS for the Alation Server

  • CentOS 7.x or 8.x

  • RedHat 7.x or 8.x

  • Ubuntu 16, 18

  • AWS Linux 2

More information: System Requirements

Supported Browsers

Browser

OS

Version

Chrome HD

Windows 7

86.0.4240.75

Chrome

Windows 10

86.0.4240.75

Mozilla Firefox HD

Windows 7

81.0

Mozilla Firefox

Windows 10

79

Microsoft Internet Explorer 11

Windows 7

11.0

Microsoft Internet Explorer 11

Windows 10

81.0

Microsoft Edge Chromium

Windows 10

86.0.622.38

Safari

OS X 10.11 El Capitan

11.1.2

Safari

macOS 10.12 Sierra

12.1.2

Safari

macOS 10.15 Catalina

13.1

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 will depend 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 profiling 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 2020.3?

This table contains the changes compared to the previous release.

Change

Description

Certified support for new data sources that can be cataloged using Custom DB and custom drivers

Added support for EMR Presto on Hive with AWS Glue, Salesforce, and ServiceNow. See Data Sources Supported as Custom DB

Certified support for the data sources that can be cataloged using Open Connector Framework

Added support for Looker, Power BI Pro and Tableau. Salesforce and ServiceNow. See Supported OCF Connectors

Certified support for the data sources that can be cataloged using BI SOURCES

Added support for SSRS with Sharepoint. See Supported BI Tools

Greenplum

Added support for version 6.9

Hive 3 on CDP

Added support for version 7.0

Azure Databricks

OAuth for Compose marked as Supported

PostgreSQL (open source)

Added support for version 13

Tableau GBM V2

Added support for version 2020.3

Amazon Athena

QLI, Popularity, and Lineage marked as supported

Custom Query-Based Column Profiling

Custom Query-Based Profiling added to the Custom DB table

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

10-08-20

Removed Cognos 11 from Supported BI Tools.