Downloads

Supported Connectors

Ataccama ONE offers a range of connectors allowing you to integrate with databases, cloud data warehouses, cloud storage, and business applications.

This article outlines the key capabilities supported by each connector, helping you understand which connectors are best suited for your specific use cases.

Catalog, edge processing, and lineage connectors

The following table shows which connectors support data processing, edge processing, and lineage, along with their available authentication methods.

These connectors can be used in Catalog, Data quality, and Reference data modules.

Technology Credentials Data processing & catalog Edge processing Lineage

Amazon Aurora MySQL

Username and password

✔

✔

✗

Amazon Aurora PostgreSQL

Username and password

✔

✔

✗

Amazon Redshift

Username and password

✔

✔

✗

Amazon S3

AWS access key, AWS assume role

✔

✔

✗

Azure Data Lake Storage Gen2

Entra ID

✔

✗

✗

Storage account access key

✔

✗

✗

Azure Synapse Analytics

Username and password

✔

✔

✗

BigQuery

Google services account key

✔

✔

✔

Databricks

OAuth credentials

✔

✔

✗

Personal access token (PAT)

✔

✔

✔

Dropbox

OAuth credentials

✔

✗

✗

Generic connector

Driver-specific credentials

✔

✔

✗

Google Cloud Storage

Google services account key

✔

✗

✗

Google Drive

OAuth credentials

✔

✗

✗

MariaDB

Username and password

✔

✔

✗

MSSQL Server

Entra ID

✔

✔

✔

Username and password

✔

✔

✔

MySQL

Username and password

✔

✔

✗

Microsoft Fabric Lakehouse

Entra ID

✔

✔

✗

Microsoft OneDrive

OAuth credentials

✔

✗

✗

Oracle

Username and password

✔

✗

✔

Palantir Foundry

Username and password

✔

✔

✗

PostgreSQL

Username and password

✔

✔

✗

Power BI

Entra ID

✔

✗

✔

Reference data

Integrated

✔

✔

✗

Salesforce

Username, password, and token

✔

✗

✗

OAuth credentials

✔

✗

✗

Snowflake

Username and password

✔

✔

✗

Snowflake OAuth credentials

✔

✔

✗

Key-pair authentication

✔

✔

✔

Entra ID

✔

✔

✗

Sybase

Username and password

✔

✗

✗

Tableau

Tableau credentials

✔

✗

✔

Teradata

Username and password

✔

✗

✗

Pushdown processing

Currently, Snowflake and Databricks connections support pushdown execution.

For these connections, profiling jobs always run in pushdown and not in Ataccama’s runtime.

You can configure whether pushdown processing is used for DQ evaluation. To learn more, see Pushdown Processing and When to Use Pushdown for DQ Evaluation.

Data observability

Data observability supports the following connectors:

  • Apache Airflow with OpenLineage

  • dbt Core with OpenLineage

  • Dagster with OpenLineage

  • AWS Glue with OpenLineage

  • Azure Data Factory with OpenLineage

  • GCP Cloud Data Fusion with OpenLineage

For details, see Pipeline Monitoring.

Freshness monitoring can scan the following sources directly:

  • Databricks

  • Snowflake

  • PostgreSQL

  • Amazon Aurora PostgreSQL

  • MS SQL Server, including Azure SQL

  • BigQuery

  • Oracle

This list applies to source scanning only. Freshness monitoring can also cover other sources through pipeline monitoring. For details, see Freshness Monitoring.

Lineage

Some connectors are supported exclusively for lineage. For a complete list of lineage connectors, see Supported Technologies.

Was this page useful?