From Bright Pattern Documentation
Jump to: navigation, search
 
Line 2: Line 2:
 
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.
 
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.
+
 
 +
[[File:reporting-db-spec-image2.png|thumb|600px|center|]]
  
  
'''Step 1: Create a data adapter.'''
+
== Procedure ==
 +
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.
  
* In ''Repository Explorer'', select and right-click '''Data Adapters'''.
+
=== Step 1: Create a data adapter ===
* Then select '''Create Data Adapter'''.
+
# In ''Repository Explorer'', select and right-click '''Data Adapters'''.<br /><br />
 +
# Then select '''Create Data Adapter'''.
  
  
Line 14: Line 17:
  
  
 +
=== Step 2: Choose your connection ===
 
* In the window that pops up, select '''Database JDBC Connection''' and click '''Next'''.
 
* In the window that pops up, select '''Database JDBC Connection''' and click '''Next'''.
  
Line 20: Line 24:
  
  
'''Step 2: Specify JDBC properties.'''
+
=== Step 3: Specify JDBC properties ===
 
 
 
You will be defining the properties (i.e., driver, database server host, authentication) for the Java Database connection.
 
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:
 
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
+
* '''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 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://&lt;your database server host name&gt;:3306/&lt; your reporting database name&gt;''
+
* '''JDBC Url:''' ''jdbc:mariadb://&lt;your database server host name&gt;:3306/&lt; your reporting database name&gt;''
** '''Username:''' Username for access to your Reporting Database
+
* '''Username:''' Username for access to your Reporting Database
** '''Password:''' Password for access to your Reporting Database
+
* '''Password:''' Password for access to your Reporting Database
* Click ''Finish''.
 
  
 +
Then click '''Finish'''.
  
Note the following:
+
=== Notes ===
 
* For database server host name, database name, and username, open the Contact Center Administrator application and navigate to [[contact-center-administrator-guide/ReportingSettings|Reporting Settings]].
 
* For database server host name, database name, and username, open the Contact Center Administrator application and navigate to [[contact-center-administrator-guide/ReportingSettings|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.
 
* 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.
  
  
[[File:reporting-db-spec-image2.png|thumb|600px|center|]]
 
  
  
<center>[[custom-reporting-tutorial/ImportingLibraries|< Previous]]  |  [[custom-reporting-tutorial/ImportingLocalizationResources|Next >]]</center>
+
 
  
  
 
</translate>
 
</translate>

Revision as of 17:30, 29 August 2018

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.


Reporting-db-spec-image2.png


Procedure

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

  1. In Repository Explorer, select and right-click Data Adapters.

  2. Then select Create Data Adapter.


Repository > Create Data Adapter


Step 2: Choose your connection

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


Create Data Adapter > Database JDBC Connection


Step 3: 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

Then click Finish.

Notes

  • 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.




< Previous