Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

ODBC and/or JDBC

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

Using IDSMC 1.2

Solaris 8

3 REPLIES
Cisco Employee

Re: ODBC and/or JDBC

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

Cisco Employee

Re: ODBC and/or JDBC

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.

Cisco Employee

Re: ODBC and/or JDBC

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

104
Views
0
Helpful
3
Replies
CreatePlease to create content