Systems Supported by Jedox Integrator

Relational databases

Database

Supported DB versions

Driver class

JDBC URL prefix

Read/write

Apache Derby

10.14.2.0

Embedded: org.apache.derby.jdbc.EmbeddedDriver
Server: org.apache.derby.jdbc.ClientDriver

Embedded: derby
Server: derby

R/W

DB2

11.1

com.ibm.db2.jcc.DB2Driver

db2

Read only

H2

1.4.200

org.h2.Driver

h2:mem

R/W

HSQLDB

2.3.3

Embedded: org.hsqldb.jdbcDriver
Server: org.hsqldb.jdbcDriver

Embedded: hsqldb:file
Server: hsqldb:hsql

R/W

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 2019, 2017, 2016, 2014, 2012, and 2008, PDW 2008R2 AU34, SQL Server 2008 R2

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

from 8.2

org.postgresql.Driver

postgresql

R/W

SAP HANA

2.0

com.sap.db.jdbc.Driver

sap

R/W

SAP MaxDB

Read only

SQLite

3.8.11.2

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 SAP Connector.

File-based data sources

File type Read/Write Comment
CSV files R/W Comma-separated values
File directories Read only

HYPER files

Write only Proprietary file format of Tableau Software
(Tableau data extract)
JSON files R/W
Microsoft Access R/W 2013, 2016
Note: parallel access is not possible due to restrictions of Microsoft Access Driver.
Microsoft Excel R/W 2013, 2016, 2019
QVX files Write only QlikView data eXchange format
XML files R/W

Data services and protocols

FTP R/W
HTTP, HTTPS Read only
LDAP Server Read only
REST-based Web Services Read only HTTP-Methods GET, POST;
Basic Authentication, OAuth2 with client credentials; SSL
SOAP Web Services Read only Generic SOAP-based Web Services, SSL is supported
TLS (Transport Layer Security) - Versions 1.2 and 1.3
WebDAV R/W

Other systems

Apache Groovy (Script engine) Groovy version 2.4.13
Apache Hive R/W Supported distribution: Hortonworks Data Platform (HDP) 2.6.4
Hadoop HDFS R/W Supported distribution: Hortonworks Data Platform (HDP) 2.6.4
Jedox In-Memory DB R/W Jedox In-Memory DB 5.0 or higher
Lucanet Read only
Microsoft One Drive R/W
Microsoft Power BI Write only
Mongo DB Read only
Qlik Sense Server R/W Qlik Sense April 2019; Qlik Sense Server version: 13.12.1

R

NA

Statistical computing; 4.1.3

Salesforce R/W
Tableau Server Write only

Updated November 25, 2022