ODBC and/or JDBC

[emusican]

Is the VMS2.2 alarm database remotely queryable using ODBC and/or JDBC? If so, how?

Using IDSMC 1.2

Solaris 8

[martucci]

Hi,

it is not possible to directly access the database remotely.

what we do is providing an export utility for having the data in a format that can then be parsed and the data can be added to a remote db.

the utility is IdsAlarm.exe

Look at the instruction son how to use it at this link

http://www.cisco.com/en/US/partner/products/sw/cscowork/ps3991/products_user_guide_chapter09186a00800e4368.html#22

It is provided regarding of the platform in which you are running and starting from IDSMC 1.2 that you already have.

regards

Francesca

[chalejr]

Not currently. Although we do not block JDBC access, we do not formally support it as of today. We are working toward allowing external access but currently the database performance does not allow us to run concurrent with other applications accessing the same table set.

[martucci]

It is not possible to remotely query the alarm database used by Security Monitor.

At the ame time we provide a script that is possible to use generating a database rule for exporting the alarms in a specific format (IdsAlarm, and then you can parse them and import them in your own database using the format you want.

Here is the link were you can refer to for more information on the usage of the script.

http://www.cisco.com/en/US/partner/products/sw/cscowork/ps3991/products_user_guide_chapter09186a008018d96f.html#130939

http://www.cisco.com/univercd/cc/td/doc/product/rtrmgmt/cw2000/mon_sec/secmon12/ug/ch05.htm

Francesca