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

ElasticSearch^1^ 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 Athena^2^

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

Actian Ingres

  • 12.1
  • Data Source

Certified

Actian Zen

  • v17.0
  • Data Source

Certified

HCL Informix

  • 15.0
  • Data Source

Certified

REST API^3^

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.