2024.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 2024.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¶
You can no longer be add the data sources via built-in connectors by default. See Deprecated Connectors for the end of support information. To add a data source, use RDBMS OCF Connectors.
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 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 DynamoDB |
|
|
|
|
|
|
|
AWS EMR |
|
|
|
|
|
|
|
Azure Databricks |
|
|
|
|
|
|
|
Azure Synapse Analytics (DW) |
|
|
|
|
|
|
|
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 DynamoDB |
|
|
AWS Glue |
|
|
Amazon S3 |
|
* |
* This feature is Beta - 2021.3 and above.