Systems Supported by Jedox Integrator

image_pdfimage_print

Relational
Databases
1)

JDBC Driver Version

Supported DB Versions

Read/Write

Apache Derby

10.10.1.1

10.10.1.1

R/W

DB2

9.5

9.5

Read only

H2

1.3.176

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

MS SQL Server

4.2

2005, 2008, 2008 R2, 2012, 2014

R/W

My SQL

5.1.39

from 4.1 to 5.5

R/W

Oracle

12.1.0.1

from 11.1.0 to 12.1.0

R/W

PostgreSQL

9.4-1206

from 7.2

R/W

SAP HANA

1.0

1.0

R/W

SAP MaxDB

7.6

Info not available

Read only

Sqlite

3.8.11.2

3.8.11.2

R/W

 

File-based Data

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 2)

R/W

2007, 2010, 2013, 2016

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

Read only

 

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 OLAP

R/W

Jedox OLAP-Server 5.0 or higher

Lucanet

Read only

 

Salesforce

Read only

 

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

1) The ETL 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.

2) Parallel Access not possible due to restrictions of Microsoft Access Driver.

image_pdfimage_print
Was this post helpful?
NoYes (No Ratings Yet)
Loading...