The "Data Export" feature introduced in Operations Manager 3.7 exports following two types of data:
DataFabric Manager Server (DFM) Data: This comprises the information provided by the custom report catalogs in the DataFabric Manager server.
Performance Advisor (PA) data: This comprises the performance data stored in flat files which are present in perfArchiveDir location.
The Data Export feature exports both DFM and PA data to CSV or Tab separated text files.
A Storage Administrator would ideally like to isolate/offload the reporting functions to a secondary server instead of the Operations Manager Server. This will help in reducing the load on the server while running heavy Reports.
To achieve this, the Storage Administrator would have to load the DFM and PA data to third party database.
This is achieved in two steps:
1. Configure Data Export feature so that DFM and PA data is exported to CSV or Tab separated text files.
2. Load this exported data from text files to third party database
The attached zip contains:
A sample script DataExportDump.pl which helps in loading the exported DFM and PA data in CSV or Tab separated files to MySQL database.
A schema file DataExportTables.sql to create required DFM and PA tables in MySQL database.
Documentation on how to use this tool
Download Link: Operations Manager Server Data Export Tool