Previous Topic  Next Topic

Data Source Connections

Designer requires access to your data source to retrieve data for reports, so before you can create reports in Designer, you need to set up a connection to your data source. Connections are defined, named, and stored in the catalog along with the reports and other resources that use them.

Designer supports the following connection types:

Connection Type Description
JDBC Connects to a relational database via a JDBC driver.
JSON Connects to a JSON data source and transforms the schemas in the data source to relational schemas.
XML Connects to and transforms an XML hierarchy model to a relational model.
SOAP Web Service Connects to a SOAP Web Service data source by importing a WSDL file. Designer supports SOAP Web Services defined by WSDL 1.1 or WSDL 2.0 as data sources.
MongoDB Connects to a MongoDB database and transforms the collections in the database to relational schemas.
Hive Connects to a relational database stored in a Hive data warehouse via a JDBC connection.
Elasticsearch Connects to an Elasticsearch data source and transforms the schemas in the data source to relational schemas.
User Defined Through the User Data Source API, 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 Designer directly supports XML format data source by wrapping the provided Hierarchical Data Source API. 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.

For more information about each connection type, see Connecting to Your Data Sources in the Logi Report Designer Guide.

We will explore the following in this topic:

Back to top

Previous Topic  Next Topic