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).
| Source | Supported versions or drivers |
|---|---|
Oracle |
JDBC Version: Oracle ojdbc8 |
Azure SQL Database |
Latest version |
Azure Data Lake Storage Gen1 |
Latest (cloud) |
Azure Data Lake Storage Gen2 |
Latest (cloud) |
Amazon Athena |
Latest (cloud) |
PostgreSQL |
JDBC Version: PostgreSQL JDBC v42.3.2 and later |
Amazon Aurora PostgreSQL |
Latest (cloud) |
Amazon Aurora MySQL |
Latest (cloud) |
EDB PostgreSQL Platform |
Latest version |
Amazon Redshift |
Latest (cloud) |
Apache Avro |
1.x |
Apache Hive |
v1.x, v3.x |
Apache Impala |
2.x, 3.x, 4.x |
Apache OCR |
1.x |
AWS EMR |
5.32 |
AWS SQS |
Latest (cloud) |
Azure Synapse Analytics |
Latest (cloud) |
Microsoft SQL Server |
10.2 and later |
CSV |
n/a |
DBF file |
n/a |
Excel |
n/a |
Local File Systems |
n/a |
Delta Lake |
0.x, 1.x |
Google Cloud |
Latest (cloud) |
JMS |
1.1 |
Kafka |
2.x, 3x. |
One Drive |
Latest (cloud) |
Parquet |
1.x, 2.x |
Snowflake |
Latest (cloud) |
MySQL |
Latest version |
MariaDB |
Latest version |
Salesforce JDBC |
CData |
Salesforce Native |
Latest (cloud) |
BigQuery |
Latest (cloud) |
SAP RFC |
SAP R/3 S/4HANA |
Amazon S3 |
Latest (cloud) |
Google Drive |
Latest (cloud) |
Was this page useful?