Skip to main content

Configure and Enable Analytics Database

You need to identify and enable 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.

Fastpath

Admin Console: System > Settings > Analytics and then Database tab

Community Manager Reports and Impact Metrics data for content begin 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.

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.

After configuring the Analytics database, you can enable it to start collecting impact metrics and Community Manager Reports data on documents and blog posts:

  1. In the Database tab, select Enabled.
Related

Setting up Community Manager Reports plugin