Version 2022.4¶
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 2022.4. If your Alation instance uses a different release, please refer to the Support Matrix corresponding to this release.
Supported Database (DB) Types¶
The database types in this table can be added using native (built-in) drivers.
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 |
QLI* |
Popularity |
Lineage |
Column Level Lineage |
Driver Version |
|---|---|---|---|---|---|---|---|---|---|
DB2 (LUW) |
10.5, 11.1, 11.5 |
|
|
|
|
|
|
|
com.ibm.db2.jcc.DB2Driver 11.5 |
Greenplum |
5, 6 |
|
|
|
|
|
|
|
PostgreSQL 42.3.3 |
MongoDB |
4.4 |
|
|
|
|
|
|
|
mongo-java-driver 3.8.0 |
Oracle |
19c |
|
|
|
|
|
|
|
19.1 |
Oracle E-Business Suite |
12.2.5 |
|
|
|
|
|
|
|
19.1 |
EMR Presto on Hive |
Presto 0.238.3 EMR 6.0, 6.1, 6.2, 6.4 |
|
|
|
|
|
|
|
com.facebook.presto.jdbc.PrestoDriver.presto.jdbc.0.265.1 |
Salesforce DB |
Summer 2021 |
|
|
|
|
|
|
|
n/a |
SAP HANA |
2.0 |
|
|
|
|
|
|
|
version 2.4.70 |
SAS Base (data files in SAS server) |
9.4 |
|
|
|
|
*** |
*** |
|
com.sas.rio.MVADriver 904300 |
SingleStore ( Former MemSQL) |
7 |
|
|
|
|
*** |
*** |
|
MySQL 8.0 driver |
Snowflake (AWS, Azure, GCP) |
latest available at release date |
|
|
|
|
|
|
|
net.snowflake.client.jdbc.SnowflakeDriver version 3.12.14 |
Sybase ASE |
Adaptive Server Enterprise 16.0 |
|
|
|
|
|
|
|
com.alation.drivers.sybase.FixedSybaseDriver.com.alation.drivers.sybase.4 |
Sybase IQ |
16 |
|
|
|
|
|
|
|
com.alation.drivers.sybase.FixedSybaseDriver.com.alation.drivers.sybase.4 |
Teradata |
16.10, 16.20, 17.0 |
|
|
|
|
|
|
|
version 17.00.00.03 |
SOURCES ON AWS RDS |
|||||||||
Oracle |
19c |
|
|
|
|
*** |
*** |
|
19.1 |
AMAZON SOURCES |
|||||||||
AWS Databricks |
9.1 LTS |
|
|
|
|
|
|
|
SimbaSparkJDBC-2.6.21 |
AWS Glue |
latest available at release date |
|
|
|
|
|
|
|
API |
Amazon Redshift |
latest available at release date |
|
|
|
|
|
|
|
com.alation.drivers.redshift.FixedRedshiftDriver version 1.2.43.1067 |
Amazon Redshift Spectrum |
latest available at release date |
|
|
|
|
|
|
|
com.alation.drivers.redshift.FixedRedshiftDriver version 1.2.43.1067 |
GOOGLE SOURCES |
|||||||||
Google BigQuery |
latest available at release date |
|
|
|
|
|
|
|
Simba driver for Google BigQuery version 1.2.19.1023 |
HADOOP SOURCES |
|||||||||
Hive on CDH |
CDH 6.2, 6.3 |
|
|
|
|
|
|
|
com.alation.drivers.hive.Hive2Driver.com.alation.drivers. hive.zero.fourteen.0.14.0-0.14.0 |
Hive with AWS Glue as Metastore |
latest available at release date |
|
|
|
|
|
|
|
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, 6.4 |
|
|
|
|
*** |
*** |
|
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.1.3, 7.1.7 |
|
|
|
|
*** |
*** |
|
com.alation.drivers.hive.Hive2Driver.com.alation.drivers. hive.zero.fourteen.0.14.0-0.14.0 |
Impala |
CDH 6.3 |
|
|
|
|
|
|
|
com.alation.drivers.hive.Hive2Driver.com.alation.drivers. hive.two.2.1.0-2.1.0 |
MS AZURE SOURCES |
|||||||||
Hive 3 on Azure HDInsight |
4.0 |
|
|
|
|
|
|
|
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¶
Note that CData drivers can be purchased from Alation. See CData Drivers for details.
Database Type |
Version Supported |
Metadata Extraction |
Compose |
Profiling |
Sampling |
QLI |
Popularity |
Lineage |
Custom Query Based Column Profiling |
Column Level Lineage |
Driver |
Driver Version |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
Amazon Athena |
Engine versions 1, 2 |
|
|
|
|
|
|
|
|
|
Simba |
Athena Simba driver 2.0.9 |
Azure Analysis Services |
latest |
|
** |
|
|
|
* |
|
|
|
CData |
CData AAS JDBC Driver 2022 |
Azure Synapse Analytics (Azure DW) |
latest |
|
|
|
|
|
|
|
|
|
Microsoft |
com.microsoft.sqlserver.jdbc. SQLServerDriver.com.microsoft. sqlserver.9.4.0.jre11 |
Cassandra |
3.11, 4.0.1 |
|
|
|
|
|
* |
* |
|
|
CData |
CData Cassandra driver 2021 |
Confluent Kafka |
2.7.x |
|
|
|
|
|
|
|
|
|
CData |
CData Kafka driver 2021 |
Cosmos DB |
latest |
|
|
|
|
|
* |
* |
|
|
CData |
CData Cosmos driver 2021 |
CSV |
n/a |
|
|
|
|
|
|
|
|
|
CData |
CData CSV driver 2021 |
Databricks Azure |
9.1 LTS |
|
|
|
|
|
|
|
|
|
Simba |
SimbaSparkJDBC-2.6.21 |
Databricks GCP |
9.1 LTS, 10.4 LTS |
|
|
|
|
|
* |
* |
|
|
Simba |
SimbaSparkJDBC-2.6.21 |
Denodo |
8 |
|
|
|
|
|
|
|
|
|
Denodo |
denodo-vdp-jdbcdriver-8.0-ga |
Amazon DynamoDB |
2019.11.21 |
|
|
|
|
|
* |
* |
|
|
CData |
CData DynamoDB driver 2021 |
ElasticSearch |
6.0 |
|
|
|
|
|
|
|
|
|
CData |
CData ElasticSearch driver 2021 |
EMR Presto on Hive |
EMR 6.0, 6.1, 6.2, 6.4 Presto 0.238.3 |
|
|
|
|
|
|
|
|
|
com.facebook.presto.jdbc. PrestoDriver 0.265.1 |
|
EMR Presto on Hive with AWS Glue |
EMR 6.0, 6.1, 6.2, 6.4 Presto 0.238.3 |
|
|
|
|
|
|
|
|
|
com.facebook.presto.jdbc. PrestoDriver 0.265.1 |
|
EMR SparkSQL on Hive |
EMR 6.1, 6.2, 6.4 Spark 3.x |
|
|
|
|
|
* |
* |
|
|
CData |
CData SparkSQL driver 2020 |
GitHub (Beta) |
3.x |
|
|
|
|
|
|
|
|
|
CData |
CData GitHub driver 2021 |
MariaDB |
latest |
|
|
|
|
|
|
|
|
|
CData |
CData MariaDB driver 2021 |
MarkLogic |
10.0 |
|
|
|
|
|
* |
|
|
|
CData |
CData MarkLogic driver 2020 |
MongoDB |
4.2, 4.4 |
|
|
|
|
|
* |
* |
|
|
CData |
CData MongoDB driver 2021 |
MongoDB Atlas on AWS |
4.2, 4.4 |
|
|
|
|
|
* |
* |
|
|
CData |
CData MongoDB driver 2021 |
NetSuite |
2021.2 |
|
|
|
|
|
|
|
|
|
CData |
CData NetSuite driver 2021 |
Parquet (Amazon S3) |
Apache Parquet API V2.0 |
|
|
|
|
|
* |
|
|
|
CData |
CData Parquet driver 2021 |
Parquet (ADLS Gen2) |
Apache Parquet API V2.0 |
|
|
|
|
|
* |
|
|
|
CData |
CData Parquet driver 2021 |
Salesforce |
Summer 2021 |
|
|
|
|
|
|
|
|
|
CData |
CData SalesforceDB driver 2021 |
ServiceNow |
latest |
|
|
|
|
|
|
|
|
|
CData |
CData ServiceNow driver 2021 |
Splunk |
8.2.x |
|
|
|
|
|
|
|
|
|
CData |
CData Splunk driver 2021 |
SSAS |
2014, 2016 |
|
|
|
|
|
|
|
|
|
CData |
CData SSAS driver 2021 |
Starburst Enterprise (Trino) |
380-e LTS on AWS |
|
|
|
|
|
|
|
|
|
Trino driver |
Trino JDBC 385 (trino-jdbc-385.jar) |
* Lineage and Popularity are calculated based on queries ingested from Compose.
** Only SQL Compliance Queries are supported. Create Schemas, Tables, and Views are not supported.
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 |
|
|---|---|---|---|---|---|---|---|---|---|
DB2 (LUW) |
|
|
|
|
|
|
|
|
|
Greenplum |
|
|
|
|
|
|
|
|
|
MongoDB |
|
|
|
|
|
|
|
|
|
Oracle |
|
|
|
|
|
|
|
|
|
Oracle E-Business Suite |
|
|
|
|
|
|
|
|
|
EMR Presto on Hive |
|
|
|
|
|
|
|
|
|
Salesforce DB |
|
|
|
|
|
|
|
n/a |
|
SAP HANA |
|
|
|
|
|
|
|
|
|
SAS Base |
|
|
|
|
|
|
|
|
|
SingleStore (Former MemSQL) |
|
|
|
|
|
|
|
|
|
Snowflake |
|
|
|
|
|
|
|
|
|
Sybase ASE |
|
|
|
|
|
|
|
|
|
Sybase IQ |
|
|
|
|
|
|
|
|
|
Teradata |
|
|
|
|
|
|
|
|
|
SOURCES ON AWS RDS |
|||||||||
Oracle |
|
|
|
|
|
|
|
|
|
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 Databricks |
|
|
|
|
|
|
|
|
|
Azure HDInsight |
|
|
|
|
|
|
|
|
|
*Permission Mirroring
** Knox, Ranger, Blue Talon, Zookeeper
Note that SASL is only supported for Hive data sources.
Note
From 2022.1, key pair authentication is supported for Snowflake.
Authentication for Custom DB¶
Database |
OAuth |
OAuth for Compose |
Kerberos |
Keytab |
LDAP |
|---|---|---|---|---|---|
Amazon Athena |
|
|
|
|
|
Azure Analysis Services |
|
|
|
|
|
Azure Synapse Analytics (Azure DW) |
|
|
|
|
|
Cassandra |
|
|
|
|
|
Confluent Kafka |
|
|
|
|
|
Cosmos DB |
|
|
|
|
|
CSV |
|
|
|
|
|
Databricks Azure |
|
|
|
|
|
Databricks GCP |
|
|
|
|
|
Denodo |
|
|
|
|
|
Amazon DynamoDB |
|
|
|
|
|
ElasticSearch |
|
|
|
|
|
EMR Presto on Hive |
|
|
|
|
|
EMR Presto on Hive with AWS Glue |
|
|
|
|
|
EMR SparkSQL on Hive |
|
|
|
|
|
GitHub (Beta) |
|
|
|
|
|
MariaDB |
|
|
|
|
|
MarkLogic |
|
|
|
|
|
MongoDB |
|
|
|
|
|
MongoDB Atlas on AWS |
|
|
|
|
|
NetSuite |
|
|
|
|
|
Parquet (Amazon S3) |
|
|
|
|
|
Parquet (ADLS Gen2) |
|
|
|
|
|
Salesforce |
|
|
|
|
|
ServiceNow |
|
|
|
|
|
Splunk |
|
|
|
|
|
Starburst Enterprise (Trino) |
|
|
|
|
|
Authentication for Hive¶
Distribution and Data Platforms |
Authentication |
Support* |
|---|---|---|
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 |
|
* 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* |
|---|---|---|
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.
** Hive and Hadoop Version should be set to 2.x.x in the Add a Data Source wizard - CONNECTION section to connect to CDP with Kerberos authentication enabled.
Supported BI Tools¶
This table includes BI tools supported with the built-in (native) BI connectors.
Tool |
Supported Version |
Metadata Extraction |
Lineage |
Access Rules |
Stats |
SSL |
|---|---|---|---|---|---|---|
Tableau Server GBM V2* |
2020.4, 2021.1, 2021.2, 2021.3, 2021.4, 2022.1 |
|
|
|
|
|
MicroStrategy GBM V2 |
2020 Cloud |
|
|
|
|
|
SSRS (without Sharepoint) |
2014, 2016, 2017, 2019 |
|
|
|
|
|
SSRS (with Sharepoint) |
2016 |
|
|
|
|
|
* Tableau Online is not supported with the built-in (native) connector for Tableau but is supported with the corresponding OCF connector (see BI Connectors below).
Supported OCF Connectors¶
The tables in this section include sources supported with OCF connectors.
BI Connectors¶
Connectors |
Supported Version |
Metadata Extraction |
Lineage |
Column Level Lineage |
Access Rules |
Stats |
SSL |
|---|---|---|---|---|---|---|---|
Looker |
latest (cloud), 22.x (on-prem) |
|
|
|
|
|
|
Power BI |
latest |
|
|
|
|
|
|
Power BI Scanner API |
Power BI Pro and Premium versions |
|
* |
|
|
|
|
Qlik Sense |
Feb 2022 and Earlier Versions |
|
|
|
|
|
|
SAP BO |
4.2 |
|
|
|
|
|
|
Tableau (Server and Online) |
Server - 2021.3, 2021.4, 2022.1 Online - latest |
|
|
|
|
|
|
* Full Lineage support for Power BI objects such as dataset, reports, tiles, and dashboards. Limited lineage support for datasource and dataset.
RDBMS Connectors¶
Connectors |
Version Supported |
Metadata Extraction |
Compose |
Sampling |
Column Profiling V1 |
Column Profiling V2 |
QLI* |
Popularity |
Lineage |
Column Level Lineage |
Driver |
Driver Version |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
Amazon Athena |
Engine version 2 |
|
|
|
|
|
|
|
|
|
native |
athena-jdbc42-2.0.9.simba.fixed. custom-sts |
AWS Glue |
latest |
|
|
|
|
|
|
|
|
|
API |
n/a |
Azure SQL DB |
latest |
|
|
|
|
|
|
|
|
|
native |
Microsoft JDBC driver for SQL Server - 11.2.0.jre11 |
Azure SQL Managed Instance |
12.0.2000.8 |
|
|
|
|
|
|
|
|
|
native |
Microsoft JDBC driver for SQL Server - 11.2.0.jre11 |
Azure Synapse |
latest |
|
|
|
|
|
|
|
|
|
native |
Microsoft JDBC driver for SQL Server - 11.2.0.jre11 |
Databricks AWS |
9.1 LTS, 10.4 LTS |
|
|
|
|
|
|
|
|
|
native |
SimbaSparkJDBC-2.6.21 |
Databricks Azure |
9.1 LTS, 10.4 LTS |
|
|
|
|
|
|
|
|
|
native |
SimbaSparkJDBC-2.6.21 |
Databricks Unity Catalog |
10.4 LTS, 11.x Platforms: AWS, Azure |
|
|
|
|
|
|
|
|
|
native |
SimbaSparkJDBC-2.6.21 |
Databricks Azure on Azure Government Cloud |
10.4 LTS |
|
|
|
|
|
|
|
|
|
native |
SimbaSparkJDBC-2.6.21 |
DB2 |
10.5, 11.1, 11.5 |
|
|
|
|
|
|
|
|
|
native |
IBM Data Server driver for JDBC and SQLJ - 11.5 |
Denodo |
8 |
|
|
|
|
|
|
|
|
|
native |
denodo-vdp-jdbcdriver-8.0-update- 20220126 |
Google BigQuery |
latest |
|
|
|
|
|
|
|
|
|
native |
Simba JDBC Driver for GoogleBigQuery42 - 1.2.19.1023 |
Greenplum |
5, 6.3, 6.9 |
|
|
|
|
|
|
|
|
|
native |
PostgreSQL 42.3.3 |
Hive 2 on CDH |
CDH 6.2, 6.3 |
|
|
|
|
|
|
|
|
|
native |
com.alation.drivers.hive.one.cdh- 1.1.0-cdh-1.1.0 |
Hive 2 on EMR |
EMR 5.x |
|
|
|
|
|
|
|
|
|
native |
com.alation.drivers.hive.one.cdh- 1.1.0-cdh-1.1.0 |
Hive 2 on MapR |
MapR 6.1.x |
|
|
|
|
|
|
|
|
|
native |
com.alation.drivers.hive.one.cdh- 1.1.0-cdh-1.1.0 |
Hive 3 on CDH |
HDP 3.1.4 |
|
|
|
|
|
|
|
|
|
native |
com.alation.drivers.hive.one.cdh- 1.1.0-cdh-1.1.0 |
Hive 3 on EMR |
EMR 6.0, 6.1, 6.2, 6.4 |
|
|
|
|
|
|
|
|
|
native |
com.alation.drivers.hive.one.cdh- 1.1.0-cdh-1.1.0 |
Hive 3 on CDP |
CDP 7.1.3, 7.1.7 |
|
|
|
|
|
|
|
|
|
native |
com.alation.drivers.hive.one.cdh- 1.1.0-cdh-1.1.0 |
Hive 3 on Azure HDInsight |
CDP 7.1.3, 7.1.7 |
|
|
|
|
|
|
|
|
|
native |
com.alation.drivers.hive.one.cdh- 1.1.0-cdh-1.1.0 |
Impala |
CDH - 6.3 |
|
|
|
|
|
|
|
|
|
native |
org.apache.hive.jdbc.HiveDriver - hive.driver.2.1.1.java.9.patched - 2.1.1 |
Informatica Power Center |
Oracle - 12.1c, 19c DB2 - 10.x, 11.1 SQL Server - 2017, 2019 |
|
|
|
|
|
|
|
|
|
native |
Ojdbc8 - 21.4.0.0.1, IBM Data Server Driver for JDBC and SQLJ - 11.5.7.0, Microsoft JDBC Driver For SQL Server - 7.0.0.jre8 |
MySQL |
5.7, 8.0 |
|
|
|
|
|
|
|
|
|
native |
MySQL Connector/J - 8.0.29 |
MySQL RDS |
5.7, 8.0 |
|
|
|
|
|
|
** |
** |
|
native |
MySQL Connector/J - 8.0.29 |
Oracle |
19c |
|
|
|
|
|
|
|
|
|
native |
12.1.0.2-tlsPatch |
Oracle RDS |
19c |
|
|
|
|
|
|
** |
** |
|
native |
12.1.0.2-tlsPatch |
PostgreSQL |
10, 11.4, 11.5, 12, 13, 14.1, 14.5 |
|
|
|
|
|
|
|
|
|
native |
version 42.3.3 |
PostgreSQL RDS |
10, 11.4, 11.5, 12, 13, 14.1 |
|
|
|
|
|
|
|
|
|
native |
version 42.3.3 |
PostgreSQL Enterprise |
10, 11, 12, 13, 14.1 |
|
|
|
|
|
|
|
|
|
native |
version 42.3.3 |
Amazon Redshift |
latest |
|
|
|
|
|
|
|
|
|
native |
version 1.2.43.1067 |
SAP ASE (Sybase ASE) |
ASE 16.0 |
|
|
|
|
|
|
|
|
|
native |
com.sybase.jdbc4.jdbc.SybDriver (Sybase Driver 4) |
SAP BW or SAP BW/4HANA |
latest |
|
|
|
|
|
|
|
|
|
API |
n/a |
SAP ECC |
latest |
|
|
|
|
|
|
|
|
|
SDK |
n/a |
SAP HANA |
2.0 |
|
|
|
|
|
|
|
|
|
native |
com.sap.cloud.db.jdbc - ngdbc - 2.12.9 (SAP HANA JDBC Driver) |
SAS Base |
9.4 |
|
|
|
|
|
|
** |
** |
|
native |
SAS drivers for JDBC and SAS/ CONNECT - Release 9.46 - 94280 (com.sas.rio.MVADriver.com. alation.drivers.sas.94280) |
SingleStore (former MemSQL) |
7.8.9 |
|
|
|
|
|
|
** |
** |
|
native |
MySQL Connector/J - 8.0.29 |
Snowflake (AWS, Azure, GCP) |
latest |
|
|
|
|
|
|
|
|
|
native |
Snowflake JDBC Driver - 3.13.21 |
SQL Server on Azure VM |
2017, 2019 |
|
|
|
|
|
|
|
|
|
native |
Microsoft JDBC driver for SQL Server - 11.2.0.jre11 |
SQL Server |
2014, 2016, 2017, 2019 |
|
|
|
|
|
|
|
|
|
native |
Microsoft JDBC driver for SQL Server - 11.2.0.jre11 |
SQL Server RDS |
2014, 2016, 2017, 2019 |
|
|
|
|
|
|
|
|
|
native |
Microsoft JDBC driver for SQL Server - 11.2.0.jre11 |
SAP IQ (Sybase IQ) |
Sybase IQ 16 |
|
|
|
|
|
|
|
|
|
native |
com.sybase.jdbc4.jdbc.SybDriver (Sybase driver 4) |
Teradata |
16.10, 16.20, 17.05 |
|
|
|
|
|
|
|
|
|
native |
Teradata JDBC Driver - 17.10.00.27 |
Vertica |
11.1.x |
|
|
|
|
|
|
|
|
|
native |
Vertica 11.1.0-0 |
* Query Log Ingestion (QLI). Note that Alation does not support QLI for data sources on RDS except OCF PostgreSQL on RDS.
** Lineage and Popularity are calculated based on queries ingested from Compose.
File System Connectors¶
Connectors |
Supported Version |
Metadata Extraction |
Sampling |
Authentication Methods |
|---|---|---|---|---|
Azure Blob Storage |
latest |
|
|
Basic, SAS |
Amazon S3 |
latest |
|
* |
Basic, STS |
* File sampling is supported only for CSV and Parquet files
Supported File Systems¶
File System |
Version Supported |
Authentication Method |
Metadata Extraction |
|---|---|---|---|
Amazon S3 |
latest |
basic, IAM Role |
|
Azure Blob Storage |
2018-03-28 |
basic |
|
Azure Data Lake |
Gen 1 |
SSL, AAD* |
|
Azure Data Lake |
Gen 2** |
SSL, AAD* |
|
HDFS - CDH |
6.3 |
SSL, Kerberos |
|
HDFS - CDP |
7.1.3, 7.1.7 |
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.27.0 or later
Note
From release 2021.2, Docker Engine can be installed using Alation Container Service: Install Docker Using Alation Container Service
Supported OS Versions¶
Operating System |
Supported Version |
Alation Server |
Alation Agent |
OCF |
Alation Analytics |
Sandbox |
|---|---|---|---|---|---|---|
CentOS (rpm) |
7.x, x86 64-bit |
|
|
|
|
|
Red Hat (rpm) |
7.x, x86 64-bit 8.x, x86 64-bit 8.5, x86 64-bit |
|
|
|
|
|
Ubuntu (deb) |
16, 18, 20 |
|
|
|
|
|
AWS Linux |
2 |
|
|
|
|
|
Fedora |
33, 34 |
|
|
|
|
|
Debian |
9, 10 |
|
|
|
|
|
Oracle Linux on Red Hat-compatible Kernel |
7, 8, 8.5 |
|
|
|
|
|
More information: System Requirements
Supported Browsers¶
Browser |
Version |
OS Version |
|---|---|---|
Chrome |
106.0.0.0 |
Windows 10 |
Mozilla Firefox |
106.0 |
Windows 10 |
Microsoft Edge Chromium |
106.0.1370.52 |
Windows 10 |
SSO Catalog¶
Application |
Application |
Protocol |
|---|---|---|
SAML |
Ping |
2.0 |
SAML |
OKTA |
2.0 |
SAML |
OneLogin |
2.0 |
SAML |
Azure AD |
2.0 |
SAML |
AD FS |
2.0 |
SAML |
Auth0 |
2.0 |
SAML |
Auth0 |
OAuth 2.0 / OpenID Connect 2.0 |
Apps connecting with Catalog |
||
OAuth |
Slack |
|
OAuth |
Connected Sheets |
|
SSO - Compose (Native and Custom DB Connectors)¶
Database Type |
Azure AD |
AD FS |
OKTA |
PingFederate |
One Login |
Auth0 |
Snowflake IdP |
|---|---|---|---|---|---|---|---|
Amazon Athena |
|
|
|
|
|
|
|
Amazon Redshift |
|
|
|
|
|
|
|
Amazon DynamoDB |
|
|
|
|
|
|
|
AWS EMR |
|
|
|
|
|
|
|
AWS Databricks |
|
|
|
|
|
|
|
Azure Databricks |
|
|
|
|
|
|
|
Azure Synapse Analytics (DW) |
|
|
|
|
|
|
|
Azure SQL (SQL DB) |
|
|
|
|
|
|
|
Snowflake |
|
|
|
|
|
|
|
CSV |
|
|
|
|
|
|
|
Azure Analysis Services |
|
|
|
|
|
|
|
SSO - Compose (OCF Connectors)¶
Database Type |
Azure AD |
AD FS |
OKTA |
PingFederate |
One Login |
Auth0 |
Snowflake IdP |
|---|---|---|---|---|---|---|---|
Amazon Redshift |
|
|
|
|
|
|
|
AWS Databricks |
|
|
|
|
|
|
|
Azure Databricks |
|
|
|
|
|
|
|
Azure Synapse |
|
|
|
|
|
|
|
Azure SQL (SQL DB) |
|
|
|
|
|
|
|
Snowflake |
|
|
|
|
|
|
|
MDE - AuthService (Native and Custom DB Connectors)¶
MDE and Profiling with IAM Role.
Connector |
Basic Auth (IAM User) |
IAM Role |
|---|---|---|
Amazon Athena |
|
* |
Amazon Redshift |
|
* |
Amazon DynamoDB |
|
|
AWS Glue |
|
|
Amazon S3 |
|
* |
* This feature is Beta - 2021.3 and above.
Provisioning¶
Authentication Mode |
Provisioning Mode |
IdP(s) |
|---|---|---|
LDAP |
LDAP API |
Active Directory, Open LDAP |
SAML |
SCIM |
Okta |
SAML |
SCIM |
Ping Federate |
SAML |
SCIM |
Azure Active Directory |
SAML |
LDAP API |
Okta(IdP) + Active Directory (User repository) |
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 depends 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 users perform sampling, Alation 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 an insight into data in tables.
Profiling V2 or deep column profiling: retrieval of a data sample based on a default or custom query and statistical calculations on this sample. The profiling results are represented on the Frequency Distribution chart for a column.
What is Different Compared to 2022.3?¶
This table contains the changes compared to the previous release.
Change |
Description |
|---|---|
Added support for new OCF Connectors |
Added Denodo, Impala, SingleStore (Former MemSQL), Google BigQuery, QlikSense, SAP ASE, Hive 2 on CDH, Hive 2 on EMR, Hive 2 on MapR, Hive 3 on HDP, Hive 3 on EMR, Hive 3 on CDP, Hive 3 on Azure HDInsight, Amazon Athena, Azure Blob Storage, Databricks Unity Catalog |
Added support for new data sources as CustomDB |
Added Azure Analysis Services |
Driver upgrades |
Upgraded Azure SQL DB, SQL Server EC2, SQL Server RDS, SQL Server on Azure VM, AzureSQL Managed instance, Snowflake, Azure Synapse driver |
PostgreSQL EC2 (OCF) |
Added support for version 14.5 |
Column Level Lineage (CLL) |
Added CLL support for Azure Synapse (Native and OCF), DB2 (Native and OCF), Google BigQuery (OCF) |
Feature support |
Added QLI support for PostgreSQL RDS (OCF) |
Supported browsers |
Updated browser versions |
Docker Compose |
Updated Docker Compose version |
SSO Compose |
Updated SSO Compose support for Native, CustomDB and OCF connectors |
SSO Catalog |
Updated SSO Catalog support |