Systems Supported by Jedox Integrator

Relational databases

Database Supported DB versions Driver class JDBC URL prefix Read/write
IBM DB2 11.1 com.ibm.db2.jcc.DB2Driver db2 Read only
MariaDB 5.5.3, 10.1, 10.2, 10.3, 10.4, 10.5
org.mariadb.jdbc.Driver
mysql R/W
MS SQL Server Azure SQL Database, Azure Synapse Analytics, Azure SQL Managed Instance, SQL Server 2012, 2012 R2, 2016, 2019, 2022 com.microsoft.sqlserver.jdbc.SQLServerDriver sqlserver R/W
My SQL 5.5 and later
org.mariadb.jdbc.Driver
mysql R/W
Oracle 21c, 19c, 18c, and 12.2 oracle.jdbc.driver.OracleDriver oracle:thin R/W
PostgreSQL 8.2 and later org.postgresql.Driver postgresql R/W
SAP HANA 2.0 com.sap.db.jdbc.Driver sap R/W

Snowflake

7.27 and later

net.snowflake.client.jdbc.SnowflakeDriver

snowflake

R/W

SQLite

3.46.1.0

org.sqlite.JDBC

sqlite

R/W

The Integrator Server can also read data from databases that aren't listed here, if a JDBC driver is available for the database. To connect to another version of a database for which a JDBC driver is shipped by Jedox, it is necessary to replace that JDBC driver's jar file with the required version's jar file.

For a list of supported SAP systems to which Jedox Integrator can connect, please see the article SAP Components Supported by Jedox.

File-based data sources

File type Read/Write Comment
CSV R/W Comma-separated values
Microsoft Excel R/W XLSX and XLS files
JSON R/W  
Qlik QVX W QlikView data eXchange format
Tableau HYPER W Proprietary file format of Tableau Software
XML R/W  
File directories R  
Microsoft Access R/W 2013, 2016
Note: parallel access is not possible due to restrictions of Microsoft Access Driver.

Parquet

R/W

 

Data services and protocols

File type Read/Write Comment
FTP R/W  
HTTP, HTTPS R  

SFTP

R/W

 

LDAP server R  
REST R/W HTTP methods GET / POST / PUT / PATCH / DELETE; Basic Authentication, OAuth2 with client credentials; SSL
SOAP web Services R Generic SOAP-based Web Services, SSL is supported
TLS (Transport Layer Security) - Version 1.3
WebDAV R/W  

Other systems

File type Read/Write Comment

Azure Blob Storage / Data Lake (Microsoft)

R/W

 

Cosmos DB

R

 

Groovy (script engine) - Apache Groovy version 3.0.22
Google Sheets R/W API v4 is currently supported.
Hadoop HDFS R/W  
Jedox In-Memory DB R/W Jedox In-Memory DB 2022.2 and higher
Lucanet R  
One Drive (Microsoft ) R/W  
Power BI (Microsoft ) W  
Mongo DB R  
Qlik Sense Server R/W Qlik Sense April 2019; Qlik Sense Server version: 13.12.1
R - Statistical computing; 4.3.0
Salesforce R/W  

Sharepoint (Microsoft )

R/W

 

Tableau Server W

Jedox versions older than 2023.2 do not support Tableau versions 10.5 and later, due to Tableau's switch to Hyper API.

Updated November 19, 2024