User Community Service Desk Downloads
If you can't find the product or version you're looking for, visit support.ataccama.com/downloads

Supported Data Sources

In addition to the data sources supported out of the box, ONE can integrate with other sources provided that there is a JDBC driver available or that an API connector can be created for it (if the source supports only API interactions).

Big data sources

Source Recommended version Supported by

AWS EMR

5.32

Catalog, Spark DPE

Apache Hive

v1.x, v3.x

Catalog, Spark DPE

Apache Impala

2.x, 3.x, 4.x

Catalog, ONE Desktop, Spark DPE

Cassandra

3.11.12

Catalog, ONE Desktop

Cloudera Hadoop

5.x, 6.x, 7.x

Catalog

Databricks

9.1 LTS, 10.x

Catalog

Hortonworks Hadoop

2.x, 3.x

Catalog

Kafka

2.x, 3x

ONE Desktop

File types

Source Recommended version Supported by

Apache Avro

1.x

Catalog via Virtual Catalog Items, ONE Desktop, Spark DPE

Apache ORC

1.x

Catalog via Virtual Catalog Items, Spark DPE

Delta Lake

0.x, 1.x

Spark DPE, Spark DPE via Virtual Catalog Items

Parquet

1.x, 2.x

Catalog, ONE Desktop, Spark DPE

CSV

Catalog, ONE Desktop, Spark DPE

DBF File

Catalog via Virtual Catalog Items, ONE Desktop

Microsoft Excel

Catalog, Catalog via Virtual Catalog Items, ONE Desktop

Local file systems

Catalog, Catalog via Virtual Catalog Items

Cobol Copybook

Catalog via Virtual Catalog Items, ONE Desktop

File and object storages

Source Supported by

Azure Data Lake Storage Gen1

Catalog via Virtual Catalog Items, ONE Desktop

Azure Data Lake Storage Gen2

Catalog, ONE Desktop, Spark DPE

Amazon S3

Catalog, Catalog via Virtual Catalog Items, ONE Desktop

Google Cloud Storage

Catalog, Catalog via Virtual Catalog Items

Google Drive

Catalog, Catalog via Virtual Catalog Items, ONE Desktop

ONE supports the latest versions of cloud-based sources.
Source Recommended version Supported by

Azure SQL Database

Latest

Catalog, ONE Desktop

Amazon Athena

Latest

Catalog, ONE Desktop

Amazon Aurora MySQL

Latest

Catalog, ONE Desktop

Amazon Redshift

Latest

Catalog, ONE Desktop

Amazon Simple Queue Service (SQS)

N/A in-house connector

Azure Synapse Analytics (SQL DW or SQL pools)

Latest

Connecting to Azure Synapse with Azure Service Principal
jdbc:sqlserver://name.database.windows.net:1433;database=my_database; encrypt=true; trustServerCertificate=false; hostNameInCertificate=*.database.windows.net; loginTimeout=30;authentication: ActiveDirectoryServicePrincipal; AADSecurePrincipalId=<PrincipalID>;AADSecurePrincipalSecret=<PrincipalSecret>

Catalog, ONE Desktop

BigQuery

1.2.25.1029

Catalog, ONE Desktop

Snowflake

Latest

Catalog, ONE Desktop

Azure Cosmos DB

Latest

Catalog

Elasticsearch

Latest

Catalog

Apache Derby

JDBC version: 10.14.2.0; driver: org.apache.derby:derbyclient

Dremio

JDBC driver: 20.1.0-202202061055110045-36733c65

IBM Informix

JDBC version: 4.10.8.1; driver: jdbc-4.10.8.1.jar

Catalog, ONE Desktop

IBM DB2

JDBC version: 10.5.0.5; driver: db2jcc4-4.31.10.jar

Catalog, ONE Desktop

IBM Netezza

Latest

Catalog, ONE Desktop

Oracle

JDBC version: Oracle ojdbc8; driver: com.oracle.database.jdbc:ojdbc8

Catalog, ONE Desktop

Amazon Aurora PostgreSQL

JDBC version: PostgreSQL JDBC v42.3.2 and later; driver: org.postgresql:postgresql

Catalog, ONE Desktop

Redis

JDBC version: 22.0.8322.0; driver: cdata.jdbc.redis.jar

Catalog, ONE Desktop

Microsoft SQL Server

JDBC version: v10.2 and later; driver: com.microsoft.sqlserver:mssql-jdbc

Catalog, ONE Desktop

MySQL

JDBC version: 8.0.31; driver: mysql:mysql-connector-java

Catalog, ONE Desktop

MariaDB

JDBC version: 8.0.29; driver: org.mariadb.jdbc:mariadb-java-client

Catalog, ONE Desktop

MongoDB

Latest

Catalog, ONE Desktop

HP Vertica

Latest

Presto

Latest

Catalog, ONE Desktop

ScyllaDB

Latest

Catalog, ONE Desktop

Sqlite

JDBC driver: 3.39.3.0; driver: org.xerial:sqlite-jdbc

Catalog

Salesforce

JDBC version: 21.0.7955.0; driver: cdata-jdbc-salesforce-21.0.7955.0.jar

Catalog

SAP RFC

JDBC version: SAP R/3 S/4HANA 2.10.19; driver: sapjco3.jar

Catalog, ONE Desktop

Sybase

JDBC version: 1.3.1; driver: jtds-1.3.1.jar

Catalog, ONE Desktop

Teradata

JDBC version: 17.10.00.14; driver: terajdbc4-17.10.00.14.jar

Catalog, ONE Desktop

JMS (version 1.1)

N/A in-house connector

ONE Desktop

Azure Data Explorer (ADX)

(from version 14.5.1 and later)

JDBC version: v10.2 and later; driver: com.microsoft.sqlserver:mssql-jdbc

Catalog, ONE Desktop

MANTA

Type of deployment and modules Supported authentication methods

Ataccama Cloud Dedicated

  • MSSQL: SQL Server Auth, NTLM Auth, Azure AD Service Principle and KeyVault, Azure Key Vault with AAD Client Credential,

  • Oracle: SQL Server Auth, NTLM Auth, Azure AD Service Principle and KeyVault, Azure Key Vault with AAD Client Credential,

  • PostgreSQL: SQL Server Auth, NTLM Auth, Azure AD Service Principle and KeyVault, Azure Key Vault with AAD Client Credential,

  • Snowflake: Snowflake AAD Service Principal, Azure Service Principal with Key Vault

  • *Service Account (Username and Password)

Ataccama Cloud Dedicated with Hybrid DPE (on-prem)

  • MSSQL: JavaKerberos, SQL Server Auth Method, NTLM, Azure AD Service Principle and KeyVault, Azure Key Vault with AAD Client Credential.

  • Oracle: JavaKerberos, SQL Server Auth Method, NTLM, Azure AD Service Principle and KeyVault, Azure Key Vault with AAD Client Credential.

  • PostgreSQL: JavaKerberos, SQL Server Auth Method, NTLM, Azure AD Service Principle and KeyVault, Azure Key Vault with AAD Client Credential.

  • Snowflake: Snowflake AAD Service Principal, Azure Service Principal with Key Vault

  • *Service Account (Username and Password)

Ataccama Cloud Dedicated | Manta(V41)

  • MSSQL, Oracle, PostgreSQL MSSQL: NTLM Auth Method, SQL Server Auth Method

  • Oracle: NTLM Auth Method, SQL Server Auth Method

  • PostgreSQL: NTLM Auth Method, SQL Server Auth Method

  • *Service Account (Username and Password)

Ataccama Cloud Dedicated with Hybrid DPE (on-prem)

Manta(V36)

Was this page useful?