Any good strategies for mirroring repository/topology in a database?

Hi TC,

can you explain a little bit more about what you want to do ? Historical data or just real time data (mirror the data in SQL) ? To do reports after that ? To simplify request for real time data ?

--Fred

This is mainly for reporting. I would like a quicker way to query one-off statistic requests witht he added benefit of not impacting production systems with the queries.

Since the desired information may include current device/interface status or current availability metrics the DB will have to have topology and real time notification information.

The insertion of incoming alerts is not really a problem, it is the creation/maintenance/synchronization of the topology DB that I am looking to do.

- TC

TC,

We have a product called RapidInsight that may meet your needs. RapidInsight Smarts plugin includes connectors to retrieve both notifications and topology objects from Smarts and store in RapidInsight repository, which provides powerful search capabilities.

You can use google like queries to search the repository, save your queries, run them periodically, etc. Connectors subscribe to the Smarts servers and continuously update both topology and notifications data in RapidInsight.

RapidInsight provides a much higher level API to work with data in Smarts and other data sources that includes powerful search capabilities to build any type of customized reporting etc. You probably won't need a database but if you'd like to push the data into a database, that's also easy to do as RapidInsight handles Smarts interface and provides database integration layer as well.

You can find out more about it on our website http://www.ifountain.org/rapidinsight, there is also a demo to get a feel for the user interface. Please feel free to contact me directly if you'd like to discuss anything.


Regards,

Berkay Mollamustafaoglu
http://www.ifountain.com
http://twitter.com/berkay
Ph: + 1 703 349 0538
mberkay on yahoo, google and skype