Version V R6 (5.10.x)

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
Cassandra	2.1, 3.11.15**	✔	ㄨ	✔	ㄨ	ㄨ	ㄨ
DB2	10, 11	✔	✔	✔	✔	✔	✔
Greenplum	4.3.7.3	✔	✔	✔	✔	✔	✔
	5.1.0	✔	✔	✔	ㄨ	✔	✔
MemSQL	5.8.0	✔	✔	ㄨ	ㄨ	✔	✔
MongoDB	3.2, 3.6	✔	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
MySQL	5.7	✔	✔	✔	✔	✔	✔
Netezza	7.2.1.0	✔	✔	✔	✔	✔	✔
Oracle	11gR2, 12c, 18,19	✔	✔	✔	✔	✔	✔
PostgreSQL (enterprise)	9.6.2.7	✔	✔	✔	✔	✔	✔
PostgreSQL (open source)	9.5, 9.6	✔	✔	✔	✔	✔	✔
Presto over Hive	0.185	✔	✔	✔	✔	✔	✔
Qubole	contact Support	ㄨ	✔	ㄨ	ㄨ	ㄨ	ㄨ
Salesforce DB	n/a	✔	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
SAP HANA	1.00.110.00.1447 753075	✔	✔	✔	✔	✔	✔
SAS Base (data files in SAS server)	9.4	✔	✔	✔	ㄨ	✔	✔
Snowflake	2.34.0	✔	✔	✔	✔	✔	✔
SQL Server	2012, 2014, 2016, 2017	✔***	✔	✔	✔	✔	✔
Sybase ASE	Adaptive Server Enterprise 16.0	✔	✔	✔	✔	✔	ㄨ
Sybase IQ	v 16	✔	✔	✔	✔	✔	✔
Teradata	15.10, 16.10, 16.20	✔	✔	✔	✔	✔	✔
Teradata Aster	4.6	✔	✔	✔	✔	✔	✔
Vertica	7.2.3	✔	✔	✔	✔	✔	✔
SOURCES ON AWS RDS
My SQL	5.7	✔	✔	✔	ㄨ	✔	✔
Oracle	11gR2, 12c 12.2	✔	✔	✔	ㄨ	✔	✔
PostgreSQL (open source)	9.5, 10, 11	✔	✔	✔	ㄨ	✔	✔
SQL Server	2012, 2014, 2016, 2017	✔***	✔	✔	ㄨ	✔	✔
AMAZON SOURCES
AWS Databricks	V4.3	✔	✔	✔	✔	✔	✔
AWS Glue	2017-03-31	✔	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
Amazon Redshift	1.0.1385	✔	✔	✔	✔	✔	✔
Amazon Redshift Spectrum	1.0.1385	✔	✔	✔	✔	✔	✔
GOOGLE SOURCES
Google BigQuery	n/a	✔	✔	✔	✔	ㄨ	ㄨ
HADOOP SOURCES
Hive on HDP	HDP 2.4, 2.5.3, 2.6.3, 2.6.4, 2.6.5	✔	✔	✔	✔	✔	✔
Hive on CDH	CDH 5.2 to 5.16	✔	✔	✔	✔	✔	✔
Hive 2 on EMR (QLI over FS)	EMR 5.10 to 5.16	✔	✔	✔	✔	✔	✔
Hive 2 on EMR (QLI over Amazon S3)	EMR 5.10 to 5.16	✔	✔	✔	✔	✔	✔
Hive on EMR with MapReduce	EMR 5.10 to 5.16	✔	✔	✔	ㄨ	✔	✔
Hive on EMR with Tez	EMR 5.10 to 5.16	✔	✔	✔	ㄨ	✔	✔
Hive with AWS Glue as Metastore	2017-03-31	✔	✔	✔	✔	✔	ㄨ
Hive on HDP with Tez	HDP 2.4, 2.5.3, 2.6.3, 2.6.4, 2.6.5	✔	✔	✔	✔	✔	✔
Hive 3 on HDP with Tez	HDP 3.0, 3.1	✔	✔	✔	ㄨ	✔	✔
Impala	CDH 5.8 to 5.16	✔	✔	✔	✔	✔	✔
SparkSQL over Hive Metastore	CDH 5.8 to 5.16 HDP 2.4, 2.5, 2.6.5	✔	✔	✔	ㄨ	ㄨ	✔
MS AZURE SOURCES
Azure SQL Data Warehouse	10.0.xxxx.xx	✔	✔	✔	ㄨ	✔	✔
Azure Databricks****	V5.3	✔	✔	✔	✔	✔	✔
Hive on Azure HDInsight	3.5, 3.6	✔	✔	✔	✔	✔	✔
Hive 3 on Azure HDInsight	4.0	✔	✔	✔	ㄨ	✔	✔

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

** Cassandra 3.11.15 is supported with the custom DB functionality.

*** Case sensitivity is not supported.

**** Alation recommends to use Progress Datadirect Spark SQL JDBC driver for Azure Databricks sources.

Supported DB Authentication Methods

Note that all these database types support basic authentication, meaning, 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	ㄨ	ㄨ		ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	✔
Netezza	ㄨ	✔		ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
Oracle	ㄨ	ㄨ		✔	ㄨ	✔	ㄨ	ㄨ	✔
PostgreSQl (enterprise)	ㄨ	ㄨ		✔	ㄨ	ㄨ	ㄨ	ㄨ	✔
PostgreSQl (open source)	ㄨ	ㄨ		✔	ㄨ	ㄨ	ㄨ	ㄨ	✔
Presto over Hive	ㄨ	ㄨ		✔	ㄨ	✔	ㄨ	ㄨ	ㄨ
Qubole	ㄨ	ㄨ		ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
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 2	Link
Hive 3	Link
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 2

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 currently support for Hive 2. For more details on Hive data sources, refer to the Hive section of the Installing Alation: Data Source Configuration guide.

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 currently support for Hive 3. For more details on Hive data sources, refer to the Hive section of the Installing Alation: Data Source Configuration guide.

Supported BI Tools

Tool	Supported Version	Metadata Extraction	Lineage	Access Rules	Stats
Tableau Legacy*	10.5.3, 2018.1	✔	✔	✔	✔
Tableau Generic*	10.5.3, 2018.1, 2018.3 2019.1 2019.2	✔	✔	✔	✔
MicroStrategy	10.4, 11	✔	ㄨ	✔	ㄨ
Cognos	11	✔	✔	ㄨ	ㄨ
SFDC Einstein Analytics	REST API 41.0	✔	✔	ㄨ	ㄨ
SSRS / SSAS	contact Support	✔	✔	ㄨ	ㄨ

* In V R5 (5.9.x), Alation updated the integration framework for Tableau Server. The framework that existed in prior releases is referred to as “Legacy”, and the new framework is referred to as “Tableau Generic”. For more details, see the Tableau Server section in Installing Alation: Guide to BI Tool Configuration.

Supported Authentication Methods For Tableau Server

Tableau Version	LDAP	SSL
10.5.3, 10.4	ㄨ	ㄨ
2018.1	ㄨ	✔
2018.2	✔	✔
2019.1	✔	✔
2019.2	✔	✔

Supported File Systems

File System	Version Supported	Authentication Method	Metadata Extraction
Amazon S3	all versions	basic	✔
Azure Blob Storage	2018-03-28	basic	✔
Azure Data Lake	Gen 1	SSL, AAD*	✔
HDFS - CDH	5.2 to 5.16	SSL, Kerberos	✔
HDFS - HDP	2.4, 2.5.3, 2.6.3, 2.6.4, 2.6.5	SSL, Kerberos	✔

* Azure Active Directory

Supported Browsers

Browser	Version	OS Version
Chrome HD (1440x900)	72.0.3626.121 (64-bit)	Windows 7 Ultimate N (SP1)
Chrome - Windows 10	74.0.3729.131 (64 bit)	Windows 10
Chrome HD - OS X	74.0.3729.131	macOS High Sierra 10.13.6
Mozilla Firefox HD (1440x900)	66.0.4	Windows 7 Ultimate N (SP1)
Mozilla Firefox HD - OS X (1440x900)	66.0.5	OS X El Capitan (10.11.6)
Microsoft Internet Explorer 11 HD (1440x900)	11.0.115 (11.0.9600.19301)	Windows 7 Ultimate N (SP1)
Microsoft IE 11- Windows 10	11.437.17763.0 (11.0.120)	Windows 10

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 other 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 R5

This table contains changes compared to the previous release.

Change	Description
Google BigQuery	Added support for Lineage and Popularity.
MySQL 5.6 on RDS - removed	Removed MySQL on RDS 5.6 since it is EOL
Hive 3 on HDP with Tez - added	Added support for Hive 3 on HDP with Tez, except QLI
SQL Server 2008 - removed	Removed SQL Server 2008 since it is EOL, from both RDS and EC2 lists
PostgreSQL version 11 - added	Added support to PostgreSQL 11, both RDS and EC2
PostgreSQL version 10 - added support on RDS	Added support to PostgreSQL version 10 on RDS
Oracle 18,19 - added	Added support for Oracle 18,19
Cognos 11 - added	Added support for Cognos 11
Cognos 10.2 - removed	Cognos 10.2 support removed since IBM has ended support
MicroStrategy 11 - added	Added support for MicroStrategy 11
Hive on EMR with Tez or MR QLI - not supported	Removed Hive on EMR with Tez or MR QLI support since we have issues with the summary logs.
Hive on MS Azure	Added QLI support (except for Hive 3)

Change Log

This table contains corrections we have to make in case we find issues with the support of the announced versions.

Date	Change
	No corrections yet