Data Source Connections
Before you can create reports in Logi JReport Designer, you need to set up a connection to allow Logi JReport Designer to retrieve data from your data source for the reports. If you are using SQL queries Logi JReport needs to import the database schema, which allows Logi JReport to run the queries that provide the data for reports. Connections are defined, named, and stored in the catalog along with the reports and other resources that use them.
Logi JReport is extremely efficient when working with data sources that are in a relational database (RDBMS). The Java Database Connectivity (JDBC) connections are the basic approaches for connecting to a database for data. Other data source types can also be accessed.
This topic describes the following connection types:
- JDBC Connection: Connects to a relational database via a JDBC driver.
- JSON Connection: Connects to a JSON data source and transforms the schemas in the data source to relational schemas.
- XML Connection: Connects to and transforms an XML hierarchy model to a relational model.
- SOAP Web Service Connection: Connects to a SOAP Web Service data source by importing a WSDL file. Logi JReport Designer supports SOAP Web Services defined by WSDL 1.1 or WSDL 2.0 as data sources.
- MongoDB Connection: Connects to a MongoDB database and transforms the collections in the database to relational schemas.
- Hive Connection: Connects to a relational database stored in a Hive data warehouse via a JDBC connection.
- Elasticsearch Connection: Connects to an Elasticsearch data source and transforms the schemas in the data source to relational schemas.
- User Defined Data Source: Through the UDS API, Logi JReport Designer can access data from an external data source, such as a text file or Excel file, which is not stored in a database or when there is no JDBC driver available.
- Hierarchical Data Source: Logi JReport Designer directly supports XML format data source by wrapping the provided HDS API. Logi JReport Designer's built-in classes can implement the XML format hierarchical data source interface. You can directly import an XML data source to a catalog using the Catalog Manager.
See an example: The SampleComponents catalog, included with Logi JReport Designer, contains reports that have examples of different data source connections. Open the following report to see the connection examples: