Version 2022.2¶
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.2. 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 |
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 |
MySQL (EC2) |
5.7, 8.0 |
|
|
|
|
|
|
version 8.0.26 |
Oracle |
12.1c, 19c |
|
|
|
|
|
|
19.1 |
Oracle E-Business Suite |
12.2.5 |
|
|
|
|
|
|
19.1 |
PostgreSQL (enterprise) |
10, 11, 12, 13, 14.1 |
|
|
|
|
|
|
PostgreSQL 42.3.3 |
PostgreSQL (open source) |
10, 11.4, 11.5, 12, 13, 14.1 |
|
|
|
|
|
|
PostgreSQL 42.3.3 |
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.13.6 |
SQL Server |
2012, 2014, 2016, 2017, 2019 |
** |
|
|
|
|
|
com.microsoft.sqlserver Version 9.4.0.jre11 (supports NTLM) |
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 |
Vertica |
7.2.3 |
|
|
|
|
|
|
version 7.2.1 |
SOURCES ON AWS RDS |
||||||||
MySQL |
5.7. 8.0 |
|
|
|
|
*** |
*** |
version 8.0.26 |
Oracle |
12c, 19c |
|
|
|
|
*** |
*** |
19.1 |
PostgreSQL (open source) |
10.0, 11.4, 11.5, 12, 13 |
|
|
|
|
*** |
*** |
PostgreSQL 42.3.3 |
SQL Server |
2012, 2014, 2016, 2017, 2019 |
** |
|
|
|
*** |
*** |
com.microsoft.sqlserver Version 9.4.0.jre11 |
AMAZON SOURCES |
||||||||
AWS Databricks |
9.1 LTS, 10.1 |
|
|
|
|
|
|
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 |
||||||||
Azure Synapse Analytics |
latest available at release date |
|
|
|
|
*** |
*** |
com.microsoft.sqlserver.jdbc.SQLServerDriver.com.microsoft.sqlserver. 9.4.0.jre11 |
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 |
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 |
Databricks Azure |
9.1 LTS, 10.1 |
|
|
|
|
|
|
|
|
Simba |
SimbaSparkJDBC-2.6.21 |
Databricks GCP |
9.1 LTS, 10.1 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 |
Starburst Enterprise Presto (Trino) on AWS |
360-e LTS |
|
|
|
|
|
|
|
|
Starburst |
presto-cli-350-executable.jar from starburst |
* 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 |
|
|
|
|
|
|
|
|
|
MySQL |
|
|
|
|
|
|
|
|
|
Oracle |
|
|
|
|
|
|
|
|
|
Oracle E-Business Suite |
|
|
|
|
|
|
|
|
|
PostgreSQl (enterprise) |
|
|
|
|
|
|
|
|
|
PostgreSQl (open source) |
|
|
|
|
|
|
|
|
|
EMR Presto on Hive |
|
|
|
|
|
|
|
|
|
Salesforce DB |
|
|
|
|
|
|
|
n/a |
|
SAP HANA |
|
|
|
|
|
|
|
|
|
SAS Base |
|
|
|
|
|
|
|
|
|
SingleStore (Former MemSQL) |
|
|
|
|
|
|
|
|
|
Snowflake |
|
|
|
|
|
|
|
|
|
SQL Server |
|
|
|
|
|
|
|
|
|
Sybase ASE |
|
|
|
|
|
|
|
|
|
Sybase IQ |
|
|
|
|
|
|
|
|
|
Teradata |
|
|
|
|
|
|
|
|
|
Vertica |
|
|
|
|
|
|
|
|
|
SOURCES ON AWS RDS |
|||||||||
MySQL |
|
|
|
|
|
|
|
|
|
Oracle |
|
|
|
|
|
|
|
|
|
PostgreSQL (open source) |
|
|
|
|
|
|
|
|
|
SQL Server |
|
|
|
|
|
|
|
|
|
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 Data Warehouse |
|
|
|
|
|
|
|
|
|
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 |
|
|
|
|
|
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 Presto (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) |
2012, 14, 16, 17, 18, 19 |
|
|
|
|
|
SSRS (with Sharepoint) |
2012, 16 |
|
|
|
|
|
* Tableau Online is not supported.
Supported OCF Connectors¶
BI Connectors¶
Connectors |
Supported Version |
Metadata Extraction |
Lineage |
Access Rules |
Stats |
SSL |
|---|---|---|---|---|---|---|
Looker |
latest (cloud), 22.x (on-prem) |
|
|
|
|
|
Power BI Pro |
latest |
|
|
|
|
|
Power BI Scanner API |
Power BI Pro and Premium versions |
|
|
|
|
|
SAP BO |
4.2 |
|
|
|
|
|
RDBMS Connectors¶
Connectors |
Version Supported |
Metadata Extraction |
Compose |
Sampling |
Column Profiling V1 |
Column Profiling V2 |
QLI* |
Popularity |
Lineage |
Driver |
Driver Version |
|---|---|---|---|---|---|---|---|---|---|---|---|
AWS Databricks |
9.1 LTS, 10.1, 10.4 LTS |
|
|
|
|
|
|
|
|
native |
SimbaSparkJDBC-2.6.21 |
AWS Glue |
latest |
|
|
|
|
|
|
|
|
API |
n/a |
Azure SQL DB |
latest |
|
|
|
|
|
|
|
|
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 |
DB2 |
10.5, 11.1, 11.5 |
|
|
|
|
|
|
|
|
native |
IBM Data Server driver for JDBC and SQLJ - 11.5 |
MySQL |
5.7, 8.0 |
|
|
|
|
|
|
|
|
native |
version 8.0.21 |
MySQL RDS |
5.7, 8.0 |
|
|
|
|
|
|
** |
** |
native |
version 8.0.21 |
Oracle |
12.1c, 19c |
|
|
|
|
|
|
|
|
native |
12.1.0.2-tlsPatch |
Oracle RDS |
12.1c, 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 |
Amazon Redshift |
latest |
|
|
|
|
|
|
|
|
native |
version 1.2.43.1067 |
SAP BW or SAP BW/4HANA |
latest |
|
|
|
|
|
|
|
|
API |
n/a |
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) |
SQL Server on Azure VM |
2017, 2019 |
|
|
|
|
|
|
|
|
native |
Microsoft JDBC driver for SQL Server - 9.4.0.jre11 |
SQL Server |
2012, 2014, 2016, 2017, 2019 |
|
|
|
|
|
|
|
|
native |
Microsoft JDBC driver for SQL Server - 9.4.0.jre11 |
SQL Server RDS |
2012, 2014, 2016, 2017 |
|
|
|
|
|
|
|
|
native |
Microsoft JDBC driver for SQL Server - 9.4.0.jre11 |
Sybase |
Sybase IQ 16 |
|
|
|
|
|
|
|
|
native |
com.sybase.jdbc4.jdbc.SybDriver (Sybase driver 4) |
* 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.
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 |
Lineage |
OCF |
AA V2 |
Scarlet |
|---|---|---|---|---|---|---|
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 |
100.0.4896.127 |
Windows 10 |
Mozilla Firefox |
99 |
Windows 10 |
Microsoft Edge Chromium |
100.0.1185.50 |
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¶
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 |
|
|
|
|
|
|
|
MDE - AuthService¶
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.
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.1?¶
This table contains the changes compared to the previous release.
Change |
Description |
|---|---|
Added support for new OCF Connectors |
Added SAP BW, SAP BW/4HANA, Power BI Scanner API, Azure Synapse, DB2, SAS Base, AWS Glue, Sybase IQ |
Added support for new data sources as CustomDB |
Added NetSuite |
Driver upgrades |
Upgraded AWS Databricks, Azure Databricks (CustomDB), GCP Databricks (Custom DB), PostgreSQL (OCF), PostgreSQL RDS (OCF) |
PostgreSQL (OCF) |
Added support for version 14.1 |
PostgreSQL RDS (OCF) |
Added support for version 14.1 |
Looker (OCF) |
Added support for version 22.x (On-Prem) |
HDFS CDP |
Added support for version 7.1.3 and 7.1.7 |
AWS Databricks (OCF) |
Added support for version 10.4 LTS |
GCP Databricks |
Added support for version 10.4 LTS |
Tableau |
Added support for version 2022.2 |
Hive 3 on CDP with Tez |
Added support for CDP version 7.1.7 |
Supported browsers |
Updated browser versions |
Supported OS Versions |
Added OEL 8.5 and Redhat 8.5 |
SSO - Catalog |
Added OAuth/OIDC |