Relational databases
|
Database |
Supported DB versions |
Driver class |
JDBC URL prefix |
Read/write |
|---|---|---|---|---|
|
Apache Derby |
10.15.2.0 |
Embedded: org.apache.derby.jdbc.EmbeddedDriver |
Embedded: 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 |
Embedded: hsqldb:file |
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; REST connection support POST / PUT / PATCH methods when used in JSON or XML loads. |
| 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 22.2 |
| 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 |
Jedox versions older than 2023.2 do not support Tableau versions 10.5 and later, due to Tableau's switch to Hyper API. |
Updated August 13, 2024