When to use an external database

When your organization has more than 50 GB of data to store, Content Security Reporter requires a separate external database outside of the database already installed for McAfee ePO.

McAfee recommends using an external database for the following situations.

  • There is more than 50 GB of data to store
  • In a medium- to large-size organization
  • Do not want to condense log records into page views
  • Need to increase performance
  • Need additional database management tools

To store report data, connect Content Security Reporter to one of the following supported external database platforms.

You can connect to an external database using SSL connection.

  • Microsoft SQL Server 2008
  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2014
  • Microsoft SQL Server 2016
  • MySQL 5.5
  • MySQL 5.6
  • MySQL 5.7
Note: Refer to the product documentation for your external database for instructions about backing up the database.

Note: Content Security Reporter 2.5.0 does not support Microsoft SQL Server 2005. Before upgrading to Content Security Reporter 2.5.0, you must upgrade your Microsoft SQL Server to one of the supported versions.