Creating a Data AdapterData 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.'''Note that creating a data adapter is not required unless you have direct database access; direct database access is a licensed fee.'''[[File:reporting-db-spec-image2.png|thumb|600px|center|]]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.# Then select '''Create Data Adapter'''.[[File:Create-Data-Adapter.png|450px|thumbnail|center|Repository > Create Data Adapter]]* In the window that pops up, select '''Database JDBC Connection''' and click '''Next'''.[[File:Database-JDBC.png|450px|thumbnail|center|Create Data Adapter > Database JDBC 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:* '''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 DatabaseThen click '''Finish'''.* 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]].
