Configuring Analytics database

You should 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.

Fastpath: Admin Console: System > Settings > Analytics, then Database tab

To configure the database:

  1. In the Admin Console, go to System > Settings > Analytics, then open the Database tab.
  2. In Database Driver Presets, select the preset database driver.
  3. In Database URL and JDBC Driver Class, enter the required setting using the pre-filled settings as an example.
  4. In Username and Password, enter the database user name and password, so that Jive can establish a connection to the database.
    Similar to the core database user, the Analytics database user must be able to create and modify schemas, and they must have permission to select, insert, update, and delete queries.
  5. In Min Connections, Maximum Connections, Connection Timeout, use the default settings.
    You can adjust these fields to fit your community's specific needs later, if necessary.
  6. Click Test Connection to see if Jive can make the connection to the database.
  7. Click Save.