cancel
Showing results for 
Search instead for 
Did you mean: 

Sybase SQL Anywhere client

TuxanForLife
Level 3


Has anyone tried to install a Sybase SQL Anywhere client and query the Ops Center database directly? 

I have Ops Center with Analytics so I can run an SQL query from Ops Center, but I'd like to have a better interface for writing the queries. Once they're generating the data I want to see, I can copy the SQL to Ops Center and have it generate the pretty graphs, tables and charts. 

I imagine that it's not supported. And that it's dangerous - you can blow things up if you modify the schemas etc. 
But is it possible?  Is there a better way to do the same thing? 

 

Similarly, has anyone taken the XML files that seem to describe the database and run them through a database visualizer program? If so, which one do you recommend? I'm looking to see if "XML viewer" or "GraphViz" can do it. 

1 ACCEPTED SOLUTION

Accepted Solutions

tom_sprouse
Level 6
Employee Accredited Certified

Also, we apparently have a recent Technote for this:

 

How to setup a remote ODBC connection to the OpsCenter Analytics database

 

http://www.symantec.com/docs/TECH141827

 

View solution in original post

5 REPLIES 5

tom_sprouse
Level 6
Employee Accredited Certified

Yes, Tuxan, you can use Sybase Tools to access the database directly.

Is it offically supported, no, and corrupting your database is a possiblity.

With that being said, if you wish to perform this action, please look for your server.conf file under /opscenter/server/db/conf

You must modify the LocalOnly entry to = NO instead of YES

Then use sybase to open the ODBC connection to the OpsCenter host using server 

OPSCENTER_hostname

Also, if you want to create a schema, please look at this Forum post....I have used it, and it has worked in the past. I have not tried 7.5

 

OpsCenter 7.1 - database schema

https://www-secure.symantec.com/connect/forums/opscenter-71-database-schema

--Tom

 

tom_sprouse
Level 6
Employee Accredited Certified

Also, we apparently have a recent Technote for this:

 

How to setup a remote ODBC connection to the OpsCenter Analytics database

 

http://www.symantec.com/docs/TECH141827

 

TuxanForLife
Level 3

Thank you, Tom. I'm excited to try.
Step One - Verify the OpsCenter box is being backed up correctly. Otherwise - talk about ironic egg on one's face.  ;)

 

tom_sprouse
Level 6
Employee Accredited Certified

Tuxan,

Correct, ensure you have daily dbbackup's of the database, as a regular file system backup will not capture the database files.

For information on that, please refer to Backing Up the OpsCenter Database 

http://www.symantec.com/docs/HOWTO42869

 

TuxanForLife
Level 3

I used SchemaSpy to dump all tables in  our Ops Center 7.5 instance into a big multi-tabbed webpage.
The attached file shows the tables, fields (including data types) and inter-table relationships - greatly simplifies writing reports.
Four or five table graphics didn't render nicely (and we have some tables used for migration leftover), but the data is still good.

Also, I saw some posts asking about database size and retention period. We believe that we maintain 730 days history in an environment that runs - 450k jobs in under 10GB of diskspace.