Great news! Our brilliant engineers from the Customer Service Department developed a very useful and, I would say, critically important tool that helps Sitecore administrators in maintenance activities on the OMS 1.x database.
First off, it is well integrated into Sitecore’s Control Panel:
and provides a really nice wizard based interface that guides the user through main admin and maintenance tasks:
Looks very native if you ask me.
Here is where you can find more about it:
And here is a snippet from the project’s description:
This module provides a set of tasks that might be helpful to optimize the using of Sitecore Analytics…
- Clean up the unnecessary data from the Analytics database.
- Remove BOTs sessions.
- Perform the indexes rebuilding of the Analytics database.
- Quickly create a backup of the analytics data.
- Synchronize the Analytics Definitions to use the clean Analytics database on the existing solution.http://trac.sitecore.net/AnalyticsDatabaseManager