Active IQ Unified Manager Discussions

Operations Manager and Crystal Reports

chriskranz
8,746 Views

I'm about to start reading through http://media.netapp.com/documents/tr-3690.pdf but I wanted to ask quickly on here to see if anyone has done this before.

I have a customer wanting some custom Crystal Reports based on Operations Manager (or the DFM database to be precise). Can this be done by connecting directly to the Sybase database, or does the data need to be exported first? If we wanted to run regular reports for instance, this could make scheduling a bit tricky.

Any pointers would be much appreciated. I know I can do a lot with Operations Manager custom reports anyway, but the customer already has a lot of Crystal Report writers and they can make short work of the reports for management summaries once they get the database structure and connections all sorted.

Cheers...

1 ACCEPTED SOLUTION

raja
8,746 Views

You do not need to export the database. Crystal Reports can connect to DFM database directly to get the data over ODBC.

In the TR, you can look at Section 3.5 - Case A:


Case A: Storage administrator wants to access directly the DataFabric Manager database views from third-party reporting tools such as Crystal Report to generate customized storage capacity reports.

Thanks,

Raj.

View solution in original post

11 REPLIES 11
Public