ODS Maintenance / Retention Settings

Last Modified

Wed Nov 11 22:56 GMT 2020

Description

  • How do we shrink a large ODS database.

Environment

  • Report Manager

Solution

  • In the Report Manager administration console under system setup and logs there is a data retention setting.
  • In the data retention settings you can tell Report Manager to keep all date in the ODS and warehouse.
    • The settings are from 3 months to "keep all data".
    • Example: if you only need to keep 2 years worth of data you can set these option to keep only 2 years with of data.
  • There is also a option to delete all unused ODS data.
    • If you have any custom reports do not select this option.
  • By default N-able N-central exports all data to the ODS database.
    • Then the ETL job runs moving the Data for the stock reports in Report Manager to the warehouse.
    • If you plan on creating custom reports that data may be pulled from the ODS in some cases.
    • Selecting the option to delete all unused ODS data will remove all data from the ODS not used for stock reports (but possibly for some custom reports or data the partner may use for other purposes, e.g. sql queries on the ODS, etc).
  • It is also recommended that you setup a maintenance plan in SQL for the Databases. See the Install Guide or Online Help.
  • Please review the installation guide for your Version of Report Manager. Review section called 'Add Report Manager Databases to a maintenance plan'
  • Finally, if disk space is still an issue, support can possibly assist further.