web services inferface for HP SIM ?

[Jens Schröder]

We'd like to make the information, that is collected by HP SIM and stored in the underlying database, available to another database application (on a different machine). For different reasons (future requirements, flexibility etc.) there is a preference towards a web interface via SOAP.
Does any kind of plug-in or extension for the HP SIM 4.2 exist? If not, could you suggest any kind of data link alternatively?
Thanks in advance!

[David Claypool]

Your best bet would be to ODBC to the database itself on a read-only basis.

[Peter Sonander]

Is there some documenation of the database structure for SIM?

[Jens Schröder]

Hi David, yes, a direct database link via ODBC, JDBC or whatever would be feasable. However, our querying db-apps are majorily web applications, which by nature rather ask for a SOAP solution. Also, if the queried subset of data changes lateron or other querying systems follow, the necessary adjustment effort is deemed greater for a direct db link via ODBC.

Referring to your question, Peter, we thought of profiting from the SQL-queries of the standard reports. There's a download link for the sql queries performed in the upper left corner of every report. I hope to get any missing db information by means of the db management tool.