With your existing license, you ARE entitled for SiteScope which is agentless data collector.

SiS can run SQL queries to any DB, as long as you can provide its JDBC driver. This may be quick and easy workaround to develop custom policy and monitor using OA.

ok i know that but customer wants to monitor it using OA so is there availability to make it with OA and what is the type of policy that works for that

Hello,

I had a quick google shows there is a Management Pack (MP):

https://www.microfocus.com/marketplace/itom/content/operations-bridge-unified-content-for-cassandra whic is documented here: https://docs.microfocus.com/doc/UC_Cassandra/24.3/ReleaseNotes

This is also Opentext supported, but this will need to be added to your contract so please speak to your Opentext Sales Representative.  I hope this answers your question.

However, if you did not want to use the MP...  Firstly, I know nothing about this DB.  Assuming you don't want to use the Opentext MP, managing anything with OA12 you follow the same method...

Decide which parts of hte application you want to manage and why (that's the difficult part), then how you can get this data and then if you want to create metrics how to store them so OA12 can use them.

To get this data you could use cqlsh or nodetool which is documented here: https://cassandra.apache.org/doc/stable/cassandra/tools/nodetool/nodetool.html.  For example:

Table health monitoring (cqlsh): SELECT address, data_center, rack, load FROM system_views.nodes;

Table size and space (cqlsh): SELECT keyspace_name, table_name, space_used_live, space_used_total FROM system_views.size_estimates;

notetool commands would include:

nodetool status

nodetool tpstats

There are some samples commands here: https://www.pythian.com/blog/technical-track/cassandra-information-using-nodetool and/or https://docs.datastax.com/en/developer/python-driver/3.29/index.html.

You can store metrics using this method:  Easily collect custom metrics using Perl and visualize in OBM 

All the best.