From Bright Pattern Documentation
< 5.8:Custom-reporting-tutorial
Revision as of 21:22, 8 June 2018 by Tracy (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
Other languages:
English • ‎日本語
• 5.2 • 5.3 • 5.8

Creating a Data Adapter

Data adapters allow Jaspersoft Studio to use SQL queries to get data from your Reporting Database. In the following procedure, you will create a data adapter that uses the Java Database Connectivity (JDBC) API for the programming language Java, which defines how a database can be accessed by a client. JDBC provides methods to query and update data in a database.

To create a data adapter, navigate to the Repository Explorer tab in the left-hand corner of the screen, and proceed through the following steps.


Step 1: Create a data adapter.

  • In Repository Explorer, select and right-click Data Adapters.
  • Then select Create Data Adapter.


Repository > Create Data Adapter


  • In the window that pops up, select Database JDBC Connection and click Next.


Create Data Adapter > Database JDBC Connection


Step 2: Specify JDBC properties.

You will be defining the properties (i.e., driver, database server host, authentication) for the Java Database connection.

In the window that pops up, specify the following:

    • Name: Name of the data adapter; note that "New Data Adapter" is the default name but it may be renamed
    • JDBC Driver: org.mariadb.jdbc.Driver (Note: copy and paste this driver name into the field, or use the pull-down menu to select this driver.)
    • JDBC Url: jdbc:mariadb://<your database server host name>:3306/< your reporting database name>
    • Username: Username for access to your Reporting Database
    • Password: Password for access to your Reporting Database
  • Click Finish.


Note the following:

  • For database server host name, database name, and username, open the Contact Center Administrator application and navigate to Reporting Settings.
  • In the JDBC Url field, do not include "<" or ">" symbols. Replace "<your database server host name>" and "<your reporting database name>" with your respective host and database names.


Reporting-db-spec-image2.png


< Previous | Next >
< Previous