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