2023.1 Native and Custom DB Connectors¶
Refer to the tables below for information on supported databases, file systems, BI tools, and their versions.
Important
Alation has certified support for the versions in this matrix with release 2023.1. If your Alation instance uses a different release, refer to the Support Matrix corresponding to this release.
If you do not find the version of interest in this Support Matrix, contact Alation Support for clarifications.
Data Sources Supported with Native Connectors¶
The database types in this table can be added using native (built-in) connectors and drivers.
Note that Query Log Ingestion (QLI) is not currently supported for data sources deployed on AWS RDS.
Database |
Supported Version |
Metadata Extraction (MDE) |
Table Sampling |
Query Log Ingestion (QLI) * |
Lineage |
Column Level Lineage |
Compose |
|---|---|---|---|---|---|---|---|
DB2 (LUW) |
10.5, 11.1, 11.5 |
|
|
|
|
|
|
Greenplum |
5, 6 |
|
|
|
|
|
|
MongoDB |
4.4 |
|
|
|
|
|
|
Oracle |
19c |
|
|
|
|
|
|
Oracle E-Business Suite |
12.2.5 |
|
|
|
|
|
|
EMR Presto on Hive |
Presto 0.238.3 EMR 6.0, 6.1, 6.2, 6.4 |
|
|
|
|
|
|
Salesforce DB |
Summer 2021 |
|
|
|
|
|
|
SAP HANA |
2.0 |
|
|
|
|
|
|
SAS Base (data files in SAS server) |
9.4 |
|
|
|
*** |
|
|
SingleStore ( Former MemSQL) |
7 |
|
|
|
*** |
|
|
Snowflake (AWS, Azure, GCP) |
latest available at release date |
|
|
|
|
|
|
Sybase ASE |
16.0 |
|
|
|
|
|
|
Sybase IQ |
16 |
|
|
|
|
|
|
Teradata |
16.10, 16.20, 17.0 |
|
|
|
|
|
|
SOURCES ON AWS RDS |
|||||||
Oracle |
19c |
|
|
|
*** |
|
|
AMAZON SOURCES |
|||||||
AWS Databricks |
9.1 LTS |
|
|
|
|
|
|
AWS Glue |
latest available at release date |
|
|
|
|
|
|
Amazon Redshift |
latest available at release date |
|
|
|
|
|
|
Amazon Redshift Spectrum |
latest available at release date |
|
|
|
|
|
|
GOOGLE SOURCES |
|||||||
Google BigQuery |
latest available release date |
|
|
|
|
|
|
HADOOP SOURCES |
|||||||
Hive on CDH |
CDH 6.2, 6.3 |
|
|
|
|
|
|
Hive with AWS Glue as Metastore |
latest available release date |
|
|
|
|
|
|
Hive 3 on EMR with Tez |
EMR 6.0, 6.4 |
|
|
|
*** |
|
|
Hive 3 on CDP with Tez |
CDP 7.1.3, 7.1.7 |
|
|
|
*** |
|
|
Impala |
CDH 6.3 |
|
|
|
|
|
|
MS AZURE SOURCES |
|||||||
Hive 3 on Azure HDInsight |
4.0 |
|
|
|
|
|
|
* Note that Alation does not support QLI for data sources on RDS added using native (built-in) connectors.
** Case sensitivity is not supported.
*** Lineage is calculated based on queries ingested from Compose.
BI Sources Supported with Native Connectors for BI Tools¶
This table lists BI tools supported with the native (built-in) 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 2022.3 |
|
|
|
|
|
MicroStrategy GBM V2 |
2020 Cloud |
|
|
|
|
|
SSRS (without Sharepoint) |
2014, 2016, 2017, 2019 |
|
|
|
|
|
SSRS (with Sharepoint) |
2016 |
|
|
|
|
|
* Tableau Online is not supported with the native connector for Tableau but is supported with the corresponding OCF connector (see Tableau).
File Systems Supported with Native Connectors¶
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.
Data Sources Supported with Custom DB¶
Note that CData drivers can be purchased from Alation. See CData Drivers for details.
Database Type |
Supported Version |
Metadata Extraction |
Table Sampling |
Profiling |
QLI |
Lineage |
Column Level Lineage |
Compose |
|---|---|---|---|---|---|---|---|---|
Amazon Athena |
Engine versions 1, 2 |
|
|
|
|
|
|
|
Azure Analysis Services |
latest |
|
|
|
|
|
|
** |
Azure Synapse Analytics (Azure DW) |
latest |
|
|
|
|
|
|
|
Cassandra |
3.11, 4.0.1 |
|
|
|
|
* |
|
|
Confluent Kafka |
2.7.x |
|
|
|
|
|
|
|
Cosmos DB |
latest |
|
|
|
|
* |
|
|
CSV |
n/a |
|
|
|
|
|
|
|
Databricks Azure |
9.1 LTS |
|
|
|
|
|
|
|
Databricks GCP |
9.1 LTS, 10.4 LTS |
|
|
|
|
* |
|
|
Denodo |
8 |
|
|
|
|
|
|
|
Amazon DynamoDB |
2019.11.21 |
|
|
|
|
* |
|
|
ElasticSearch |
6.0 |
|
|
|
|
|
|
|
EMR Presto on Hive |
EMR 6.0, 6.1, 6.2, 6.4 Presto 0.238.3 |
|
|
|
|
|
|
|
EMR Presto on Hive with AWS Glue |
EMR 6.0, 6.1, 6.2, 6.4 Presto 0.238.3 |
|
|
|
|
|
|
|
EMR SparkSQL on Hive |
EMR 6.1, 6.2, 6.4 Spark 3.x |
|
|
|
|
* |
|
|
GitHub (Beta) |
3.x |
|
|
|
|
|
|
|
MariaDB |
latest |
|
|
|
|
|
|
|
MarkLogic |
10.0 |
|
|
|
|
|
|
|
MongoDB |
4.2, 4.4, 5, 6 |
|
|
|
|
* |
|
|
MongoDB Atlas on AWS |
4.2, 4.4 |
|
|
|
|
* |
|
|
MS Dynamics 365 |
9.1 |
|
|
|
|
|
|
** |
NetSuite |
2021.2 |
|
|
|
|
|
|
|
Parquet (Amazon S3) |
Apache Parquet API V2.0 |
|
|
|
|
|
|
|
Parquet (ADLS Gen2) |
Apache Parquet API V2.0 |
|
|
|
|
|
|
|
Salesforce |
Summer 2021 |
|
|
|
|
|
|
|
ServiceNow |
latest |
|
|
|
|
|
|
|
Splunk |
8.2.x |
|
|
|
|
|
|
|
SSAS |
2014, 2016 |
|
|
|
|
|
|
|
Starburst Enterprise (Trino) |
380-e LTS on AWS |
|
|
|
|
|
|
|
* Lineage is calculated based on queries ingested from Compose.
** Only SQL Compliance Queries are supported. Create Schemas, Tables, and Views are not supported.
Authentication Methods¶
Authentication Methods Supported for Native Data Sources¶
Note that for all databases 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 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.
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) |
|
|
|
|
|
SSO with 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 |
|
|
|
|
|
|
|
MS Dynamics 365 |
|
|
|
|
|
|
|
MDE through AuthService (Native and Custom DB Connectors)¶
AWS data sources support MDE and Profiling with authentication with an 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.
What is Different Compared to 2022.4?¶
This table contains the changes compared to the previous release.
Change |
Description |
|---|---|
Added support for new data sources as CustomDB |
Added MS Dynamics 365 |
Tableau |
Added support for version 2022.3 |
SSO Compose |
Updated SSO Compose support for Native and Custom DB connectors |
Change Log¶
This table contains corrections made between major releases when Alation finds issues with support of versions announced earlier.
Date |
Change |
|---|---|
05/24/23 |
Added support for MongoDB versions 5 and 6. |