Supported Connectors
Ataccama ONE Platform 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 |
✔ |
✔ |
✗ |
Azure Data Lake Storage Gen2 |
Entra ID |
✔ |
✗ |
✗ |
Storage account access key |
✔ |
✗ |
✗ |
|
Azure Synapse Analytics |
Username and password |
✔ |
✔ |
✗ |
BigQuery |
Google services account key |
✔ |
✗ |
✔ |
Dropbox |
OAuth 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 OneDrive |
OAuth credentials |
✔ |
✗ |
✗ |
ONE Reports |
Integrated |
✔ |
✗ |
✗ |
Oracle |
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, only Snowflake connections support pushdown processing.
Ataccama ONE profiling jobs always run in pushdown in Snowflake and not in Ataccama’s cloud runtime.
You can configure whether pushdown processing is used for DQ evaluation jobs. To learn more, see Snowflake Pushdown Processing.
Data observability
Data observability supports the following connectors:
-
Apache Airflow with OpenLineage
-
dbt Core with OpenLineage
-
Dagster with OpenLineage
For details, see Pipeline Monitoring.
ONE Reports
In ONE Reports, you can work with the following data sources:
-
Amazon Aurora PostgreSQL
-
PostgreSQL
-
Snowflake
For details, see ONE Reports.
Lineage
Some connectors are supported exclusively for lineage. For a complete list of lineage connectors, see Supported Technologies.
Was this page useful?