Before you can create reports in Logi Report Designer, you need to set up a connection to allow Logi Report Designer to retrieve data from your data source for the reports. If you are using SQL queries Logi Report needs to import the database schema, which allows Logi Report 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 Report 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 Report 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 Report 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 Report Designer directly supports XML format data source by wrapping the provided HDS API. Logi Report 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 Report Designer, contains reports that have examples of different data source connections. Open the following report to see the connection examples: