Version V R4 (5.8.x)

Refer to the tables below for information on supported database, file system, and BI tool types and versions. Note that we sometimes have to make corrections in this matrix and document them in the Change Log.

Supported Database (DB) Types

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

Database Type	Version Supported	Metadata Extraction	Compose	Sampling/ Profiling	QLI*	Popularity	Lineage
AWS Glue	2017-03-31	✔	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
Azure Data Warehouse	10.0.xxxx.xx	✔	✔	✔	ㄨ	✔	✔
Cassandra	2.1, 3.11.15**	✔	ㄨ	✔	ㄨ	ㄨ	ㄨ
Databricks (AWS)	V4.3	✔	✔	✔	✔	✔	✔
DB2	10, 11	✔	✔	✔	✔	✔	✔
EMR Hive QLI over Amazon S3	n/a	✔	✔	✔	✔	✔	✔
Google BigQuery	1	✔	✔	✔	✔	ㄨ	ㄨ
Greenplum	4.3.7.3 5.1.0(no QLI)	✔	✔	✔	✔	✔ ㄨ	✔
Hive 2	5.2 (CDH), 2.6.5 (HDP)	✔	✔	✔	✔	✔	✔
Hive 2 with AWS Glue as Metastore	2017-03-31	✔	✔	✔	✔	✔	ㄨ
Impala	2.1.0+	✔	✔	✔	✔	✔	✔
MemSQL	5.5.8	✔	✔	ㄨ	ㄨ	✔	✔
Microsoft Stack: HDInsight	3.6	✔	✔	✔	ㄨ	✔	ㄨ
MongoDB	3.2, 3.6	✔	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
MySQL	5.6, 5.7	✔	✔	✔	✔	✔	✔
Netezza	7.2.1.0	✔	✔	✔	✔	✔	✔
Oracle	11g (Version 1 & 2), 12c	✔	✔	✔	✔	✔	✔
PostgreSQL (enterprise)	9.5	✔	✔	✔	✔	✔	✔
PostgreSQL (open source)	9.5	✔	✔	✔	✔	✔	✔
Presto over Hive	0.151-0.185	✔	✔	✔	✔	✔	✔
Qubole	n/a	ㄨ	✔	ㄨ	ㄨ	ㄨ	ㄨ
Amazon Redshift	1.0.1385	✔	✔	✔	✔	✔	✔
Amazon Redshift Spectrum	1.0.1385	✔	✔	✔	✔	✔	✔
Salesforce DB	n/a	✔	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
SAP HANA	1.00.110.00.1447 753075	✔	✔	✔	✔	✔	✔
SAS Base (data files in SAS server	9.4	✔	✔	ㄨ	ㄨ	✔	✔
SparkSQL over Hive Metastore (CDH, HDP)	1.6.x.2.5, 2.0.x.2.5	✔	✔	✔	ㄨ	ㄨ	✔
Snowflake	2.34.0	✔	✔	✔	✔	✔	✔
SQL Server	2008, 2012, 2014, 2016	✔	✔	✔	✔	✔	✔
Sybase ASE	Adaptive Server Enterprise / 16.0 SP03	✔	✔	✔	✔	✔	ㄨ
Sybase IQ	Sybase IQ v16	✔	✔	✔	✔	✔	✔
Teradata	15.0, 15.10, 16.10	✔	✔	✔	✔	✔	✔
Teradata Aster	4.6	✔	✔	✔	✔	✔	✔
Tez	5.2 (CDH), 2.6.5 (HDP)	✔	✔	✔	✔	✔	ㄨ
Vertica	7	✔	✔	✔	✔	✔	✔

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

Supported File Systems

File System Source	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	4, 5	SSL, Kerberos	✔
HDFS - HDP	2.4, 2.5, 2.6	SSL, Kerberos	✔

*Azure Active Directory

Supported BI Tools

Tool	Supported Version	Metadata Extraction	Lineage	Access Rules	Stats
Tableau	10.5, 10.4, 10.3, 2018.1, 2018.2	✔	✔	✔	✔
MicroStrategy	10.4	✔	ㄨ	ㄨ	ㄨ
Cognos	10.2.1	✔	ㄨ	ㄨ	ㄨ
SFDC Einstein Analytics	REST API 41.0	✔	✔	ㄨ	ㄨ
SSRS / SSAS	14	✔	✔	ㄨ	ㄨ

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
AWS Glue without Hive	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
Azure Data Warehouse	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
Cassandra	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	✔
Databricks (AWS)	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
DB2	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
EMR Hive QLI over Amazon S3	ㄨ	ㄨ	✔	ㄨ	✔	✔	✔	✔
Google BigQuery	✔	✔	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
Greenplum	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	✔
Hive 2	ㄨ	ㄨ	✔	ㄨ	✔	✔	✔	✔
Hive 2 with AWS Glue as Metastore	ㄨ	ㄨ	✔	ㄨ	✔	✔	✔	✔
Impala	ㄨ	ㄨ	✔	ㄨ	✔	ㄨ	✔	✔
MemSQL	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	✔
Microsoft Stack: HDInsights	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
MongoDB	ㄨ	ㄨ	✔	ㄨ	✔	ㄨ	ㄨ	ㄨ
MySQL	ㄨ	ㄨ	✔	ㄨ	✔	ㄨ	ㄨ	✔
Netezza	ㄨ	✔	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
Oracle	ㄨ	ㄨ	✔	ㄨ	✔	ㄨ	ㄨ	✔
PostgreSQL (enterprise)	ㄨ	ㄨ	✔	ㄨ	ㄨ	ㄨ	ㄨ	✔
PostgreSQL (open source)	ㄨ	ㄨ	✔	ㄨ	ㄨ	ㄨ	ㄨ	✔
Presto over Hive	ㄨ	ㄨ	ㄨ	ㄨ	✔	ㄨ	ㄨ	ㄨ
Qubole	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
Amazon Redshift	ㄨ	✔	✔	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
Amazon Redshift Spectrum	ㄨ	✔	✔	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
Salesforce DB	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
SAP HANA	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
SAS Base (data files in SAS server)	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
Snowflake	ㄨ	✔	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
SparkSQL over Hive Metastore (CDH, HDP)	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	✔
SQL Server	ㄨ	✔	✔	✔	✔	ㄨ	ㄨ	✔
Sybase ASE	ㄨ	✔	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
Sybase IQ	ㄨ	✔	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
Teradata	✔	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	✔
Teradata Aster	ㄨ	✔	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ	ㄨ
Tez	ㄨ	ㄨ	ㄨ	ㄨ	✔	ㄨ	✔	✔
Vertica	ㄨ	ㄨ	✔	ㄨ	✔	ㄨ	ㄨ	ㄨ

*Permission Mirroring

Knox, Ranger, Blue Talon, Zookeeper

Note that MapR SASL is not yet supported for any of the data source types.

Supported Authentication Methods For Tableau Server

Tableau Version	LDAP	SSL
10.5, 10.4, 10.3	ㄨ	ㄨ
2018.1	ㄨ	✔
2018.2	✔	✔

Supported Browsers

Browser	Version	OS Version
Chrome HD (1440x900)	68.0.3440.106 (64-bit)	Windows 7 Ultimate N (SP1)
Mozilla Firefox HD (1440x900)	47, 57.0.2	Windows 7 Ultimate N (SP1)
Microsoft Internet Explorer 11 HD (1440x900)	11.0.45 (11.0.9600.18762)	Windows 7 Ultimate N (SP1)
Chrome HD - OS X	63.0.3239.84 (64-bit)	OS X El Capitan 10.11.6
Mozilla Firefox HD - OS X (1440x900)	57.0.2	OS X El Capitan (10.11.6)
Chrome - Windows 10	60.0.3112.90	Windows 10
Microsoft IE 11- Windows 10	11.0.15063.0 (Update Version 11.0.40)	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.

Change Log

Date	Change
05/22/2019	Correction: in R4 Alation does not support QLI for Greenplum 5.10
05/22/2019	MySQL: Removed version 5.1 as supported version because it is at end of life and supported hrough Oracle Lifetime Sustaining Support only
05/22/2019	DB2: Removed version 9 as supported version it is at end of life
05/22/2019	Teradata: Removed versions 13.0 and 14.because they are at end of life
05/22/2019	Vertica: Removed version 6 as it is at end of life
05/22/2019	Tableau Server: Removed versions 10.1 and 10.2 as supported versions as version 10.1 is at end of life, and support issues have been reported for version 10.2