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