Version 2021.1¶
Refer to the tables below for information on supported database, file system, and BI tool types and versions.
Important
Alation has certified support for versions in this Matrix with release 2021.1. If your Alation instance uses a different release, please refer to the Support Matrix corresponding to this release.
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 |
Driver |
Driver Version |
|---|---|---|---|---|---|---|---|---|---|
Cassandra |
2.1 |
✔ |
ㄨ |
✔ |
ㄨ |
ㄨ |
ㄨ |
native |
com.alation.drivers. redshift.FixedRedshiftDriver 1.2.12.1017 |
DB2 |
10, 11 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
com.ibm.db2.jcc.DB2Driver 10.5 |
Greenplum |
4, 5, 6.3, 6.9 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
Postgres 42.2.14 |
MemSQL |
5.8.0, 7 |
✔ |
✔ |
✔ |
ㄨ |
✔*** |
✔ *** |
native |
MySQL 8.0 driver |
MongoDB |
3.2, 3.4, 3.6, 4.0, 4.4 |
✔ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
native |
mongo-java-driver 3.8.0 |
MySQL |
5.7, 8.0 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
V 8.0.21 |
Oracle |
11gR2, 12c, 18c, 19c |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
12.1.0.2-tlsPatch. |
Oracle E-Business Suite |
12.2.5 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
12.1.0.2-tlsPatch. |
PostgreSQL (enterprise) |
9.6, 10, 11, 12, 13 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
Postgres 42.2.14 |
PostgreSQL (open source) |
9.5, 9.6, 10, 11.4, 11.5, 12, 13 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
Postgres 42.2.14 |
Presto on Hive |
0.230 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
com.facebook.presto.jdbc. PrestoDriver 0.227. Note that the 0.199 is also available |
Salesforce DB |
winter 2020 |
✔ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
API |
N/A |
SAP HANA |
2.0 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
V 2.4.70. |
SAS Base (data files in SAS server) |
9.4 |
✔ |
✔ |
✔ |
ㄨ |
✔*** |
✔*** |
native |
com.sas.rio.MVADriver 904300 |
Snowflake |
latest available at release date |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
net.snowflake.client.jdbc. SnowflakeDriver v3.12.14 |
SQL Server |
2012, 2014, 2016, 2017, 2019 |
✔** |
✔ |
✔ |
✔ |
✔ |
✔ |
native jtds |
com.microsoft.sqlserver 8.2.2.jre11 |
Sybase ASE |
Adaptive Server Enterprise 16.0 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
com.alation.drivers.sybase. FixedSybaseDriver.com.alation. drivers.sybase.4 |
Sybase IQ |
v 16 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
com.alation.drivers.sybase. FixedSybaseDriver.com.alation. drivers.sybase.4 |
Teradata |
15.10, 16.10, 16.20, 17.0 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
V 15.10.00.22 |
Teradata Aster |
4.6 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
com.asterdata.ncluster.Driver 5.0.3 |
Vertica |
7.2.3 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
V 7.2.1 |
SOURCES ON AWS RDS |
|||||||||
MySQL |
5.7. 8.0 |
✔ |
✔ |
✔ |
ㄨ |
✔*** |
✔*** |
native |
V 8.0.21 |
Oracle |
11, 12c, 12.2c, 18c, 19c |
✔ |
✔ |
✔ |
ㄨ |
✔*** |
✔*** |
native |
12.1.0.2-tlsPatch. |
PostgreSQL (open source) |
9.5, 10.0, 11.4, 11.5, 12 |
✔ |
✔ |
✔ |
ㄨ |
✔*** |
✔*** |
native |
Postgres 42.2.14 |
SQL Server |
2012, 2014, 2016, 2017 |
✔** |
✔ |
✔ |
ㄨ |
✔*** |
✔*** |
native |
com.microsoft.sqlserver8.2.2 .jre11 |
AMAZON SOURCES |
|||||||||
AWS Databricks |
6.4, 6.5, 6.6, 7.0, 7.3 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
SimbaSparkJDBC-2.6.16.1020 |
AWS Glue |
latest available at release date |
✔ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
native |
N/A |
Amazon Redshift |
latest available at release date |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
com.alation.drivers.redshift. FixedRedshiftDriver 1.2.12.1017 |
Amazon Redshift Spectrum |
latest available at release date |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
com.alation.drivers.redshift. FixedRedshiftDriver 1.2.12.1017 |
GOOGLE SOURCES |
|||||||||
Google Big Query |
latest available at release date |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
Simba driver for Google Big Query V 1.2.11.1014 |
HADOOP SOURCES |
|||||||||
Hive on HDP |
HDP 2.4, 2.5.3, 2.6.3, 2.6.4, 2.6.5 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
com.alation.drivers.hive. Hive2Driver.com.alation. drivers.hive.zero.fourteen. 0.14.0-0.14.0 |
Hive on CDH |
CDH 5.2 to 5.16, 6.2, 6.3 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
com.alation.drivers.hive. Hive2Driver.com.alation. drivers.hive.zero.fourteen. 0.14.0-0.14.0 |
Hive on EMR (QLI over FS) |
EMR 5.0 to 5.29 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
com.alation.drivers.hive. Hive2Driver.com.alation. drivers.hive.zero.fourteen. 0.14.0-0.14.0 |
Hive on EMR (QLI over Amazon S3) |
EMR 5.0 to 5.29 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
com.alation.drivers.hive. Hive2Driver.com.alation. drivers.hive.zero.fourteen. 0.14.0-0.14.0 |
Hive on EMR with MapReduce |
EMR 5.0 to 5.29 |
✔ |
✔ |
✔ |
ㄨ |
✔*** |
✔*** |
native |
com.alation.drivers.hive. Hive2Driver.com.alation. drivers.hive.zero.fourteen. 0.14.0-0.14.0 |
Hive on EMR with Tez |
EMR 5.0 to 5.29 |
✔ |
✔ |
✔ |
ㄨ |
✔*** |
✔*** |
native |
com.alation.drivers.hive. Hive2Driver.com.alation. drivers.hive.zero.fourteen. 0.14.0-0.14.0 |
Hive with AWS Glue as Metastore |
2017-03-31 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
com.alation.drivers.hive. Hive2Driver.com.alation. drivers.hive.zero.fourteen. 0.14.0-0.14.0 |
Hive on HDP with Tez |
HDP 2.4, 2.5.3, 2.6.3, 2.6.4, 2.6.5 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
com.alation.drivers.hive. Hive2Driver.com.alation. drivers.hive.zero.fourteen. 0.14.0-0.14.0 |
Hive 3 on HDP with Tez |
HDP 3.0, 3.1.x |
✔ |
✔ |
✔ |
ㄨ |
✔*** |
✔*** |
native |
com.alation.drivers.hive. Hive2Driver.com.alation. drivers.hive.zero.fourteen. 0.14.0-0.14.0 |
Hive 3 on EMR with Tez |
EMR 6.0 |
✔ |
✔ |
✔ |
ㄨ |
✔*** |
✔*** |
native |
com.alation.drivers.hive. Hive2Driver.com.alation. drivers.hive.zero.fourteen. 0.14.0-0.14.0 |
Hive 3 on CDP with Tez |
CDP 7.0 |
✔ |
✔ |
✔ |
ㄨ |
✔*** |
✔*** |
native |
com.alation.drivers.hive. Hive2Driver.com.alation. drivers.hive.zero.fourteen. 0.14.0-0.14.0 |
Impala |
CDH 5.8 to 5.16 6.0 to 6.3 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
Hive2Driver.com.alation. drivers.hive.two.2.1.0-2.1.0 |
SparkSQL over Hive Metastore |
CDH 5.8 to 5.16 HDP 2.4, 2.5, 2.6.5 |
✔ |
✔ |
✔ |
ㄨ |
ㄨ |
ㄨ |
native |
|
MS AZURE SOURCES |
|||||||||
Azure SQL Data Warehouse |
latest avaialble at release date |
✔ |
✔ |
✔ |
ㄨ |
✔*** |
✔*** |
native |
com.microsoft.sqlserver.jdbc. SQLServerDriver.com.microsoft. sqlserver.jdbc.8.2.2.jre11 |
Hive on Azure HDInsight |
3.5, 3.6 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
native |
com.alation.drivers.hive. Hive2Driver.com.alation. drivers.hive.zero.fourteen. 0.14.0-0.14.0 |
Hive 3 on Azure HDInsight |
4.0 |
✔ |
✔ |
✔ |
ㄨ |
✔ |
✔ |
native |
com.alation.drivers.hive. Hive2Driver.com.alation. drivers.hive.zero.fourteen. 0.14.0-0.14.0 |
* Query Log Ingestion (QLI). Note that Alation does not support QLI for data sources on RDS.
** Case sensitivity is not supported.
*** Lineage and Popularity are calculated based on queries ingested from Compose.
Data Sources Supported as Custom DB¶
Database Type |
Version Supported |
Metadata Extraction |
Compose |
Sampling |
QLI |
Popularity |
Lineage |
Custom Query Based Column Profiling |
Driver |
Driver Version |
|---|---|---|---|---|---|---|---|---|---|---|
Amazon Athena |
latest |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
ㄨ |
Simba |
Simba driver V 2.0.9 for Amazon Athena |
Azure Databricks |
6.4, 6.5, 6.6, 7.0, 7.4 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
Simba |
SimbaSparkJDBC-2.6.16.1020 |
Azure Synapse Analytics (Azure DW) |
Latest |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
Microsoft |
com.microsoft.sqlserver.jdbc. SQLServerDriver.com.microsoft. sqlserver.jdbc.8.2.2.jre11 |
Cassandra |
3.11 |
✔ |
✔ |
✔ |
ㄨ |
✔* |
✔* |
ㄨ |
CData |
CData cassandra driver 2020 |
Cosmos DB |
latest |
✔ |
✔ |
✔ |
ㄨ |
✔* |
✔* |
ㄨ |
CData |
CData Cosmos Driver 2020 |
Denodo |
8 |
✔ |
✔ |
✔ |
ㄨ |
ㄨ |
ㄨ |
✔ |
Denodo |
denodo-vdp-jdbcdriver-8.0-ga |
Amazon DynamoDB |
V2019.11.21 |
✔ |
✔ |
✔ |
ㄨ |
✔* |
✔* |
✔ |
CData |
CData DynamoDB Driver 2020 |
EMR Presto on Hive with AWS Glue |
EMR 5.29, 6.0 Presto 0.230 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
com.facebook.presto.jdbc. PrestoDriver 0.227 |
|
EMR SparkSQL on Hive |
EMR 6.1 Spark 3.x |
✔ |
✔ |
✔ |
ㄨ |
✔* |
✔* |
✔ |
CData |
CData SparkSQL Driver 2020 |
MongoDB |
4.2, 4.4 |
✔ |
✔ |
✔ |
ㄨ |
✔* |
✔* |
✔ |
CData |
CData MongoDB Driver 2020 |
MongoDB Atlas on AWS |
4.2, 4.4 |
✔ |
✔ |
✔ |
ㄨ |
✔* |
✔* |
✔ |
CData |
CData MongoDB Driver 2020 |
Salesforce |
Winter 2020 |
✔ |
✔ |
✔ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
CData |
CData SalesforceDB Driver 2020 |
ServiceNow |
Paris |
✔ |
✔ |
✔ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
CData |
CData ServiceNow Driver 2020 |
Starburst Enterprise Presto (Trino) |
2020 338-e.0 LTS on AWS |
✔ |
✔ |
✔ |
✔ |
ㄨ |
ㄨ |
ㄨ |
Starburst |
presto-cli-338-executable.jar from starburst |
* Lineage and Popularity are calculated based on queries ingested from Compose.
Supported DB Authentication Methods¶
Note that for all database types listed in this table, Alation supports basic authentication, and 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 |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
✔ |
|
MongoDB |
ㄨ |
ㄨ |
✔ |
ㄨ |
✔ |
ㄨ |
ㄨ |
ㄨ |
|
MySQL |
ㄨ |
ㄨ |
✔ |
ㄨ |
✔ |
ㄨ |
ㄨ |
✔ |
|
Oracle |
ㄨ |
ㄨ |
✔ |
ㄨ |
✔ |
ㄨ |
ㄨ |
✔ |
|
Oracle E-Business Suite |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
|
PostgreSQl (enterprise) |
ㄨ |
ㄨ |
✔ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
✔ |
|
PostgreSQl (open source) |
ㄨ |
ㄨ |
✔ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
✔ |
|
Presto over Hive |
ㄨ |
ㄨ |
✔ |
ㄨ |
✔ |
ㄨ |
ㄨ |
ㄨ |
|
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 |
|||||||||
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 Custom DB¶
Database |
OAuth |
OAuth for Compose |
Kerberos |
Keytab |
LDAP |
|---|---|---|---|---|---|
Amazon Athena |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
Azure Databricks |
ㄨ |
✔ |
ㄨ |
ㄨ |
ㄨ |
Azure Synapse Analytics (Azure DW) |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
Cassandra |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
Cosmos DB |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
Denodo |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
Amazon DynamoDB |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
EMR Presto on Hive with AWS Glue |
ㄨ |
ㄨ |
✔ |
✔ |
✔ |
EMR SparkSQL on Hive |
ㄨ |
ㄨ |
✔ |
✔ |
ㄨ |
MongoDB |
✔ |
ㄨ |
✔ |
ㄨ |
ㄨ |
MongoDB Atlas on AWS |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
Salesforce |
✔ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ServiceNow |
✔ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
Starburst Enterprise Presto (Trino) |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
Authentication for Hive¶
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 potentially support for Hive. For more details on Hive data sources, refer to Hive.
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 |
✔ |
|
CDP |
Basic |
✔ |
Kerberos (and keytab) |
ㄨ |
|
Azure Encryption |
ㄨ |
|
Hive SSL |
ㄨ |
|
WebHDFS SSL |
ㄨ |
|
HTTPFS Kerberos |
ㄨ |
|
Knox Kerberos |
ㄨ |
|
Knox LDAP |
ㄨ |
|
Hive Zookeeper URL |
ㄨ |
|
SASL |
ㄨ |
|
EMR |
Basic |
✔ |
Kerberos (and keytab) |
✔ |
|
Azure Encryption |
ㄨ |
|
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 potentially support for Hive. For more details on Hive data sources, refer to Hive.
Supported BI Tools¶
Tool |
Supported Version |
Metadata Extraction |
Lineage |
Access Rules |
Stats |
SSL |
|---|---|---|---|---|---|---|
Tableau GBM V2* |
10.5.3, 2018.1, 2018.3, 2019.1, 2019.2, 2019.3, 2019.4, 2020.1, 2020.2, 2020.3, 2020.4 |
✔ |
✔ |
✔ |
✔ |
✔ |
MicroStrategy |
10.4 (on-prem), 11.1 (on-prem), 2019 Cloud, 2020 Cloud |
✔ |
ㄨ |
✔ |
ㄨ |
ㄨ |
SFDC Einstein Analytics |
Winter 2020 REST API 41.0 |
✔ |
✔ |
ㄨ |
ㄨ |
ㄨ |
SSRS (without Sharepoint) |
2012, 14, 16, 17, 18, 19 |
✔ |
✔ |
ㄨ |
ㄨ |
✔ |
SSRS (with Sharepoint) |
2012, 16 |
✔ |
✔ |
ㄨ |
ㄨ |
✔ |
* In 2020.4, a Tableau Server BI source can only be added using the GBM V2 framework. Tableau Legacy model is no longer available for new Tableau sources.
Supported OCF Connectors¶
Connectors |
Supported Version |
Metadata Extraction |
Lineage |
Access Rules |
Stats |
SSL |
|---|---|---|---|---|---|---|
Looker |
Cloud 7.x |
✔ |
✔ |
ㄨ |
ㄨ |
ㄨ |
Power BI Pro |
latest |
✔ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
Tableau |
2019.4, 2020.2, 2020.3, 2020.4 |
✔ |
✔ |
✔ |
ㄨ |
✔ |
SAP BO |
4.2 |
✔ |
✔ |
ㄨ |
ㄨ |
ㄨ |
Supported File Systems¶
File System |
Version Supported |
Authentication Method |
Metadata Extraction |
|---|---|---|---|
Amazon S3 |
latest |
basic |
✔ |
Azure Blob Storage |
2018-03-28 |
basic |
✔ |
Azure Data Lake |
Gen 1 |
SSL, AAD* |
✔ |
Azure Data Lake |
Gen 2** |
SSL, AAD* |
✔ |
HDFS - CDH |
5.2 to 5.16 6.0 to 6.3 |
SSL, Kerberos |
✔ |
HDFS - HDP |
2.4, 2.5.3, 2.6.3, 2.6.4, 2.6.5, 3.0.1, 3.1.0, 3.1.4 |
SSL, Kerberos |
✔ |
* Azure Active Directory
** ADLS Gen 2 can be added using the Azure Blob Storage native connector.
Supported Docker Versions¶
Docker 18.09.1 or later
Docker Compose 1.23 or later
Supported OS for the Alation Server¶
CentOS 7.x or 8.x
RedHat 7.x or 8.x
Ubuntu 16, 18
AWS Linux 2
Fedora 31, 32
Debian 9, 10
Oracle Linux on Red Hat Compatible Kernel 7
More information: System Requirements
Supported Browsers¶
Browser |
OS |
Version |
|---|---|---|
Chrome HD |
Windows 7 |
88.0.4324.104 |
Chrome |
Windows 10 |
88.0.4324.104 |
Mozilla Firefox HD |
Windows 7 |
85.0 |
Mozilla Firefox |
Windows 10 |
85 |
Microsoft Internet Explorer 11 |
Windows 7 |
11.0 |
Microsoft Internet Explorer 11 |
Windows 10 |
11.0 |
Microsoft Edge Chromium |
Windows 10 |
88.0.705.50 |
SSO Catalog¶
Application |
Protocol |
|---|---|
Ping |
SAML 2.0 |
OKTA |
SAML 2.0 |
OneLogin |
SAML 2.0 |
Azure AD |
SAML 2.0 |
ADFS |
SAML 2.0 |
Auth0 |
SAML 2.0 |
SSO - Compose¶
Database Type |
Azure AD |
AD FS |
OKTA |
PingFederate |
One Login |
Auth0 |
Snowflake IDP |
|---|---|---|---|---|---|---|---|
Amazon Athena |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
ㄨ |
Amazon Redshift |
ㄨ |
ㄨ |
✔ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
Amazon DynamoDB |
ㄨ |
ㄨ |
✔ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
AWS EMR |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
Azure Databricks |
✔ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
ㄨ |
Snowflake |
✔ |
✔ |
✔ |
✔ |
ㄨ |
ㄨ |
✔ |
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 source 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 2020.4?¶
This table contains the changes compared to the previous release.
Change |
Description |
|---|---|
Certified support for new data sources that can be cataloged using Custom DB and custom drivers |
Added support for EMR SparkSQL, Starburst Enterprise Presto (Trino), Denodo and Azure Synapse Analytics (Azure DW). See Data Sources Supported as Custom DB |
Teradata |
Added support for version 17 |
AWS Databricks |
Added support for version 7.3 |
Azure Databricks |
Added support for version 7.4 |
Postgres Enterprise |
Added support for version 13 |
Supported OS Versions |
Updated OS versions |
Supported browsers |
Updated browser versions |