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 |
|
|
Certified |
Oracle RDBMS |
|
|
Certified |
PostgreSQL |
|
|
Certified |
IBM DB2 |
|
|
Certified |
Microsoft SQL Server |
|
|
Certified |
Microsoft SQL Azure |
|
|
Certified |
Snowflake |
|
Compatible |
|
Sybase ASE |
|
|
Compatible |
Sybase SQL Anywhere |
|
|
Compatible |
ElasticSearch^1^ Refer to the JasperReports® Server Release Notes for limitations with ElasticSearch. |
|
|
Certified |
Neo4j |
|
|
Certified |
Google BigQuery |
|
Certified |
|
TIBCO Data Virtualization |
|
|
Certified |
AWS Athena^2^ Only databases under the default catalog (AwsDataCatalog) will be displayed. |
|
|
Certified |
AWS Redshift |
|
Certified |
|
AWS RDS - PostgreSQL |
|
|
Certified |
Actian Ingres |
|
|
Certified |
Actian Zen |
|
|
Certified |
HCL Informix |
|
|
Certified |
REST API^3^ It is Compatible and tested only for Progress driver. |
|
Compatible |
|
Infobright |
|
Compatible only if the database complies to JDBC 2.1 and later standard. |
|
Vertica |
|
Compatible only if the database complies to JDBC 2.1 and later standard. |
|
Greenplum Database |
|
Compatible only if the database complies to JDBC 2.1 and later standard. |
|
Ingres Vectorwise |
|
Compatible only if the database complies to JDBC 2.1 and later standard. |
|
Netezza |
|
Compatible only if the database complies to JDBC 2.1 and later standard. |
|
Teradata |
|
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 |
|
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.