Version 2022.3¶
Available from release 2022.3.5
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.3. 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 on Azure HDInsight |
3.6 |
|
|
|
|
|
|
|
com.alation.drivers.hive.Hive2Driver.com.alation.drivers. hive.zero.fourteen.0.14.0-0.14.0 |
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 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.
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 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¶
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.
Supported 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 |
|
* |
|
|
|
|
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
AWS Glue |
latest |
|
|
|
|
|
|
|
|
|
API |
n/a |
Azure SQL DB |
latest |
|
|
|
|
|
|
|
|
|
native |
Microsoft JDBC driver for SQL Server - 9.4.0.jre11 |
Azure SQL Managed Instance |
12.0.2000.8 |
|
|
|
|
|
|
|
|
|
native |
Microsoft JDBC driver for SQL Server - 9.4.0.jre11 |
Azure Synapse |
latest |
|
|
|
|
|
|
|
|
|
native |
Microsoft JDBC driver for SQL Server - 10.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 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 |
Greenplum |
5, 6.3, 6.9 |
|
|
|
|
|
|
|
|
|
native |
PostgreSQL 42.3.3 |
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 |
|
|
|
|
|
|
|
|
|
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 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) |
Snowflake (AWS, Azure, GCP) |
latest |
|
|
|
|
|
|
|
|
|
native |
Snowflake JDBC Driver - 3.12.14 |
SQL Server on Azure VM |
2017, 2019 |
|
|
|
|
|
|
|
|
|
native |
Microsoft JDBC driver for SQL Server - 9.4.0.jre11 |
SQL Server |
2014, 2016, 2017, 2019 |
|
|
|
|
|
|
|
|
|
native |
Microsoft JDBC driver for SQL Server - 9.4.0.jre11 |
SQL Server RDS |
2014, 2016, 2017, 2019 |
|
|
|
|
|
|
|
|
|
native |
Microsoft JDBC driver for SQL Server - 9.4.0.jre11 |
Sybase |
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.
** Lineage and Popularity are calculated based on queries ingested from Compose.
File System Connectors¶
Connectors |
Supported Version |
Metadata Extraction |
Sampling |
Authentication Methods |
|---|---|---|---|---|
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.23 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 |
103.0.5060.114 |
Windows 10 |
Mozilla Firefox |
102.0 |
Windows 10 |
Microsoft Edge Chromium |
103.0.1264.62 |
Windows 10 |
SSO Catalog¶
Application |
Protocol |
|---|---|
Ping |
SAML 2.0 |
OKTA |
SAML 2.0 |
OneLogin |
SAML 2.0 |
Azure AD |
SAML 2.0 |
AD FS |
SAML 2.0 |
Auth0 |
SAML 2.0 |
Auth0 |
OAuth 2.0 / OpenID Connect 2.0 |
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 |
|
|
|
|
|
|
|
Azure Databricks |
|
|
|
|
|
|
|
Azure Synapse Analytics (DW) |
|
|
|
|
|
|
|
Azure SQL (SQL DB) |
|
|
|
|
|
|
|
Snowflake |
|
|
|
|
|
|
|
CSV |
|
|
|
|
|
|
|
SSO - Compose (OCF Connectors)¶
Database Type |
Azure AD |
AD FS |
OKTA |
PingFederate |
One Login |
Auth0 |
Snowflake IdP |
|---|---|---|---|---|---|---|---|
Amazon Redshift |
|
|
|
|
|
|
|
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.2?¶
This table contains the changes compared to the previous release.
Change |
Description |
|---|---|
Added support for new OCF Connectors |
Added PostgreSQL Enterprise, Greenplum, SAP Hana, Vertica, Teradata, Azure Databricks, Azure Databricks on Government Cloud, Informatica Power Center, SAP ECC , Tableau (Server and Online), Azure SQL Managed Instance, Snowflake |
Added support for new data sources as CustomDB |
Added SSAS, CSV |
Driver upgrades |
Upgraded Snowflake, MySQL, and Starburst Trino driver |
SQL Server RDS (OCF) |
Added support for version 2019 |
Starburst Trino |
Added support for version 380 -e LTS |
Supported browsers |
Updated browser versions |
Removed from the list of supported sources (These connectors are removed from the built-in sources, however can be added with OCF.) |
Vertica, Azure SQL Data Warehouse, MySQL, SQL Server, SQL Server RDS ,PostgreSQL (enterprise), PostgreSQL EC2, PostgreSQL RDS |
Change Log¶
This table contains corrections made between major releases when Alation finds issues with support of versions announced earlier.
Date |
Change |
|---|---|
30-09-22 |
Added Amazon S3 file system connector for the patch release 2022.3.5. |