2023.3 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.3. 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¶
Data sources can no longer be added 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 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 2023.1?¶
This table contains the changes compared to the previous release.
Change |
Description |
|---|---|
MongoDB (CustomDB) |
Added support for version 5 and 6 |