Configure Analytics Database

You need to identify the Analytics database so Community Manager Reports can use it to collect data. Complete the database form in the Admin Console by providing the Analytics database that you want to use.

Community Manager Reports and Impact Metrics data for content begins accumulating when you configure and enable the Analytics Database. You can capture Impact Metrics and get Community Manager Reports only for the period captured in the Analytics Database.

To configure the database:

1. In the Admin Console, go to System > Settings > Analytics, and then select the Database tab.
2. In Database Driver Presets, select the preset database driver and use the information prefilled into the Database URL and JDBC Driver Class fields. Make sure you change host-name and database-name to their actual values.
3. In Username and Password, enter the database user name and password so Jive can establish a connection to the database.

   As with the core database user, the Analytics database user should be able to create and modify schemas, and they have permission to select, insert, update, and delete queries.

4. Use the defaults in Min Connections for minimum database connections, in Maximum Connections for maximum database connections, and in Connection Timeout for connection timeout in minutes.

   You can adjust these fields to fit your community's specific needs later, if necessary.

5. Click Test Connection to see if Jive can make the connection to the database.
6. Click Save.