A data source is a resource in the repository that specifies how and where to obtain the data displayed by reports
JasperReports Server provides data source types for relational databases, most flavors of big data, and for specialized data such as Amazon Web Services and JavaBean data. Virtual data sources allow you to combine several data sources into one.
JasperReports Server can access any relational database that supports the SQL query language through the JDBC (Java DataBase Connectivity) API. In this case, you can configure two types of data sources in the repository:
• | JDBC data source – Establishes a direct connection to the database server using its JDBC driver. After installation, JasperReports Server includes JDBC drivers to access |
• | JNDI data source – Relies on the JNDI (Java Naming and Directory Interface) service of your application server to access a database connection. You must first configure your application server to install its JDBC drivers and configure its database connections. With JNDI data sources, the configuration of the application server determines the number of shared connections. Note that the application server connects to the database using JDBC, meaning that JNDI data sources are available for all databases that support JDBC. |
JasperReports Server also supports some specialized data sources:
• | Amazon Web Services (AWS) data source – Accesses data stored in your AWS data store using JasperReports Server, either on-premises or in the cloud. |
• | Microsoft Azure SQL data source - Allows you to access data stored in your Azure SQL Server database. |
• | Virtual data source – Allows you to combine multiple data sources into a single data source and join them within a Domain. You can also wrap a data source for big data to be used in a Domain. |
• | MongoDB – This custom data source for MongoDB supports Jaspersoft's own MongoDB Query Language. A MongoDB JDBC driver is also available. |
• | XLS and XLSX data sources – Allows you to generate reports based on data in the XLS and XLSX formats. |
• | File data source – Allows you to generate reports based on data in XML and JSON formats. |
• | Bean data source – Allows you to access data encapsulated in JavaBeans. |
• | Internal diagnostic data source – A custom data source for the server's own diagnostic data. The diagnostic information is available only to system admins (superuser by default). For more information, see Using the Diagnostic Data in Reports. |
In the case of analysis data, JasperReports Server supports OLAP data sources (such as Mondrian and XML/A connections). For information about analysis data sources, refer to the TIBCO Jaspersoft OLAP Ultimate Guide.
This chapter contains the following sections:
• | Attributes in Data Source Definitions |
• | JDBC Data Sources |
• | Managing JDBC Drivers |
• | JNDI Data Sources |
• | AWS Data Sources |
• | Azure SQL Data Sources |
• | Hadoop-Hive Data Sources |
• | MongoDB Data Sources |
• | Virtual Data Sources |
• | TIBCO Data Virtualization |
• | XLS and XLSX Data Sources |
• | File Data Sources |
• | Bean Data Sources |