Skip to content

Databases

The following table lists databases that are supported for:

  • JasperReports® Server 10.1.0

  • Jaspersoft® Studio Pro 10.1.0

  • JasperReports® IO Pro 10.1.0

  • JasperReports® Web Studio Pro 10.1.0

Database

Version

Type

Commercial

Bean

Certified

JNDI

Certified

Jaspersoft (Mondrian) Connection

Certified

XML/A Connection

Certified

Custom (e.g. Hibernate, XML, etc.)

Certified

MySQL

  • 8.4
  • Data Source
  • Repository

Certified

Oracle RDBMS

  • 19c
  • 23ai
  • 26ai
  • Data Source
  • Repository

Certified

PostgreSQL

  • 14
  • 15
  • 16
  • 17
  • Data Source
  • Repository

Certified

IBM DB2

  • 11.5
  • Data Source
  • Repository

Certified

Microsoft SQL Server

  • 2016
  • 2017
  • 2019
  • 2022
  • Data Source
  • Repository

Certified

Microsoft SQL Azure

  • Latest

Data Source

Certified

Snowflake

Data Source

Compatible

Sybase ASE

  • 15.7

Data Source

Compatible

Sybase SQL Anywhere

  • 17

Data Source

Compatible

ElasticSearch1 Refer to the JasperReports® Server Release Notes for limitations with ElasticSearch.

  • 8.12.1

Data Source

Certified

Neo4j

  • 4.0.4

Data Source

Certified

Google BigQuery

Data Source

Certified

TIBCO Data Virtualization

  • 8.8.x

Data Source

Certified

AWS Athena2

Only databases under the default catalog (AwsDataCatalog) will be displayed.
  • 2
  • 3

Data Source

Certified

AWS Redshift

Data Source

Certified

AWS RDS - PostgreSQL

  • 12
  • 13
  • 14
  • 15

Data Source

Certified

REST API3

It is Compatible and tested only for Progress driver.

Data Source

Compatible

Infobright

Data Source

Compatible only if the database complies to JDBC 2.1 and later standard.

Vertica

Data Source

Compatible only if the database complies to JDBC 2.1 and later standard.

Greenplum Database

Data Source

Compatible only if the database complies to JDBC 2.1 and later standard.

Ingres Vectorwise

Data Source

Compatible only if the database complies to JDBC 2.1 and later standard.

Netezza

Data Source

Compatible only if the database complies to JDBC 2.1 and later standard.

Teradata

Data Source

Compatible only if the database complies to JDBC 2.1 and later standard.

Big Data Certified Support (JDBC Drivers)

The following table lists JDBC Drivers that are supported for:

  • JasperReports® Server 10.1.0

  • Jaspersoft® Studio Pro 10.1.0

  • JasperReports® IO Pro 10.1.0

  • JasperReports® Web Studio Pro 10.1.0

Note

Virtual connections are supported only on JasperReports® Server (JRS).

Data Source

Versions

JasperReports® Server
MongoDB

6.x

Certified
7 Certified

Apache Hive

4.0.0

Certified

Impala

4.0

Certified

Cassandra

3.10 - 3.11

Certified

Spark SQL

2.3.3 - 3.1.2

Certified

Salesforce

Compatible

DataStax Enterprise
  • 6.0
  • 6.8

Compatible

The following data sources are tested for Progress Driver replacement:

  • Elasticsearch

  • Neo4j

  • MongoDB

  • Apache Hive

  • Impala

  • Cassandra

  • Spark SQL

  • Apache Spark

  • Snowflake

  • Mongo DB native

  • Azure SQL

  • Google BigQuery

  • Autonomous REST JDBC

For details, see the JasperReports Server Administrator Guide.

JDBC/SQL Support Note

JasperReports Server data Domains (which dynamically generate queries) work with any JDBC 2.1 and SQL-92 or higher compliant data source.