Version 2020.3

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

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	✔	✔	✔	✔	✔	✔	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, 18,19	✔	✔	✔	✔	✔	✔	native
Oracle E-Business Suite	12.2.5	✔	✔	✔	✔	✔	✔	native
PostgreSQL (enterprise)	9.6.2.7, 10 11, 12	✔	✔	✔	✔	✔	✔	native
PostgreSQL (open source)	9.5, 9.6, 10, 11.4, 11.5, 12	✔	✔	✔	✔	✔	✔	native
Presto over Hive	0.185	✔	✔	✔	✔	✔	✔	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	✔	✔	✔	ㄨ	✔***	✔	native
Hive 3 on EMR with Tez	EMR 6.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 run in Compose.

Data Sources Supported as Custom DB

Database Type	Version Supported	Metadata Extraction	Compose	Sampling / Profiling	QLI	Popularity	Lineage	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
MongoDB	4.2	✔	ㄨ	✔	ㄨ	ㄨ	ㄨ	CData
MongoDB Atlas on AWS	4.2	✔	ㄨ	✔	ㄨ	ㄨ	ㄨ	CData

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	ㄨ	ㄨ		✔	ㄨ	✔	ㄨ	ㄨ	✔
Netezza	ㄨ	✔		ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
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 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	✔

* 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	✔	✔	✔	✔	✔
MicroStrategy	10.4, 11.1 2019 Cloud, 2020 Cloud	✔	ㄨ	✔	ㄨ	ㄨ
SFDC Einstein Analytics	Winter 2020 REST API41.0	✔	✔	ㄨ	ㄨ	ㄨ
SSRS (without Sharepoint)	2012, 14, 16, 17 2018, 19	✔	✔	ㄨ	ㄨ	✔

* In 2020.3, 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 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 Browsers

Browser	Version	OS Version
Chrome HD (1440x900)	84.0.4147.105	Windows 7
Chrome - Windows 10	84.0.4147.105	Windows 10
Chrome HD - OS X	77.0.3865.120	macOS Mojave 10.14
Mozilla Firefox HD (1440x900)	79.0	Windows 7, 10
Mozilla Firefox HD	73	macOS Mojave 10.14
Microsoft Internet Explorer 11 HD (1440x900)	11.0.115 (11.0.9600.19301)	Windows 7
Microsoft IE 11- Windows 10	11.437.17763.0 (11.0.120)	Windows 10
Microsoft Edge - Windows 10	84.0.522.40	Windows 10
Safari	11.1.2	OS X 10.11 El Capitan
Safari	12.1.2	macOS 10.12 Sierra
Safari	13.1	macOS 10.15 Catalina

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 V R7?

This table contains the changes compared to the previous release.

Change	Description
Certified support for a large number of data sources that can be cataloged using Custom DB and custom drivers	Added support for Amazon DynamoDB, Cosmos DB, MongoDB Atlas, Amazon Athena, Denodo, and other sources. See Data Sources Supported as Custom DB.
Oracle E-Business Suite	Added support for version 12.2.5
Oracle on RDS	Added support for versions 18c and 19c
PostgreSQL on RDS	Added support for version 12
Greenplum	Added support for version 6
SSRS	Added support for version 2019
MicroStrategy	Added support for version 2020 Cloud
Databricks	Added support for Databricks 6.4, 6.5, 6.6, 7.0 on AWS and Azure
Sybase ASE	Lineage marked as supported
MemSQL	Profiling marked as supported
EMR, HDP	Updated supported versions
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.