Systems Supported by Jedox Integrator

image_pdfimage_print

Relational databases

Databases

JDBC driver version

Supported DB versions

Read/write

Apache Derby

10.14.2.0

10.14.2.0

R/W

DB2

9.5

9.5

Read only

H2

1.4.197

1.3.176

R/W

HSQLDB

2.3.3

2.3.3

R/W

Ingres

4.1.4

Actian Ingres 10.2, Vector 3.5

Read only

MariaDB

2.3.0

5.5, 10.0, 10.2 and 10.3

R/W

MS SQL Server

6.4.0

2008 R2, 2012, 2014, 2016, 2017

R/W

My SQL

2.3.0

5.7

R/W

Oracle

12.1.0.1

from 11.1.0 to 12.1.0

R/W

PostgreSQL

42.2.4

from 8.2

R/W

SAP HANA

1.0

1.0

R/W

SAP MaxDB

Deprecated

 

Read only

SQLite

3.8.11.2

3.8.11.2

R/W

The Integrator Server can also read data from databases that aren’t listed here, if a JDBC driver or an ODBC 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 Systems Supported by Jedox SAP Connector.

File-based data

File type Read/Write Comment
CSV files R/W Comma-separated values
JSON files R/W  
XML files R/W  
QVX files Write only QlikView data eXchange format
File directories Read only  
Microsoft Excel R/W 2010, 2013, 2016
Microsoft Access  R/W 2010, 2013, 2016
Note: parallel access is not possible due to restrictions of Microsoft Access Driver.

TDE files

Write only Proprietary file format of Tableau Software
(Tableau data extract)

Data Services and Protocols

LDAP Server Read only  
HTTP, HTTPS Read only  
FTP R/W  
SOAP Web services Read only Generic SOAP-based Webservices,  SSL is supported
REST-based Web services Read only HTTP-Methods GET, POST;
Basic Authentication, OAuth2 with client credentials; SSL
WebDAV R/W  

Other Systems

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

 

image_pdfimage_print