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 |