Configuring the Analytics Database

Identify the Analytics database so Community Manager Reports and Impact Metrics can use it to collect data.

Community Manager Reports and Impact Metrics data for content begins accumulating when you configure and enable the Analytics database. You cannot capture Impact Metrics data from before this happens unless you use Cloud Analytics instead of the Analytics database.

Note:
Fastpath: Admin Console: System > Settings > Analytics > Database

To configure the database:

  1. 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.
  2. 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.
  3. Use the defaults for Minimum Database Connections, Maximum Database Connections, and Connection Timeout fields. You can adjust these fields to fit your community's specific needs later, if necessary.
  4. Click Test Connection to see if Jive can make the connection to the database.
  5. Click Save.