Output Reporting Data to a JDBC Database

You can create your own JDBC database to store search or suggest query data, then set up the required connection details and fields to output in Exalead CloudView. For all reporters, you can configure the export to only include a subset of these fields. You can also specify additional fields. For details, see the procedures below.

This task shows you how to:

Create the JDBC Database
Add a JDBC Reporting Publisher

Create the JDBC Database

Create a JDBC database:
1. Create a dedicated table for each reporter. A table to store your search query data, a separate table to store suggest query data, etc.
2. Define the fields you want to report on.
Copy your JDBC driver to <DATADIR>/javabin.
On the Administration Console Home page, restart the searchserver and connector processes.
Add the JDBC reporting publisher. See Add a JDBC Reporting Publisher.

Add a JDBC Reporting Publisher

Follow the steps in Create the JDBC Database.
In the Administration Console, go to Search > Reporting.
Expand the configuration for the reporter to export. For example, for search queries, click search-api, for suggest queries, click suggest-reporting, etc.
Click Add reporting publisher.
1. Select JDBC Publisher.
2. Click Accept.

Click the newly added reporting publisher to display its configuration settings, and:

For Published fields, select the fields to include.

Specify the connection details to the database you created in the previous procedure:


Option	action
Driver	Enter the JDBC driver class name. For MySQL, it is `com.mysql.jdbc.Driver`.
Connection string	Enter the JDBC URL of the database.
Login	Enter your database login, if any.
Password	Enter your database password, if any.
Table	Enter the name of the database table you want to report on.

Click Apply.