03-21-2003 05:18 AM - edited 03-02-2019 06:02 AM
Are the CW2000 database schemas available? Is there an ODBC interface for the Sybase Anywhere database?
Solved! Go to Solution.
04-02-2003 12:51 PM
Other info would me the on-line help withing the RME help docs.
03-21-2003 10:37 AM
No. But you can use the RME Data Extraction Engine (DEE) to automate the export of configs and inventory:
04-02-2003 12:46 PM
I know of DEE, but have only seen the DEE white paper (http://www.cisco.com/warp/public/cc/pd/wr2k/rsmn/prodlit/cwdee_wp.htm). Is there any other documentation available?
04-02-2003 12:51 PM
Other info would me the on-line help withing the RME help docs.
08-11-2003 10:49 AM
I managed to find an ODBC driver for Sybase iAnywhere and get access directly to the CW2000 databases using an inventory extracting utility (but could also have been a reporting tool like Crystal). Anybody interested in the details can contact me offline at michael.imhoff@hp.com.
08-20-2003 07:39 AM
Hi Mike..
This is great information that you provided our dba (Jose)with. The info will be helpful for us to create and automate the custom reports that we require.
John
10-08-2003 10:35 AM
Numerous people has asked for this info so here it is. The screenshots you'll still have to get from me.
I did my testing with 5th edition on Windows 2000 using iAnywhere version 7.
The trick is to look at the ODBC configuration on the CW2000 server. I have made some screen dumps that shows the details.
I downloaded Sybase iAnywhere version 8 in a full installation image. You only need the ODBC driver on your remote system (also shown).
Then I configured this driver in the same way as on the server (also included). The important part is to remember the database password specified during the CW2000 installation. If you don't recall it this information can be found in clear text in a file in the CW2000 directory (once again look at the screen dumps). The passwords are however encrypted in the latest version.
The final step was to connect from a utility. This could be Crystal. In my case I used a utility from HP OpenView ServiceDesk. OVSD is a ITIL compliant service management tool for incident, problem, change, configuration and service level management handling (trouble ticketing application (plus more) if you know that term better).
In this way I got access to the RME database. My aim is to get inventory information out of this database and put it into the Configuration Management Database (CMDB) of OVSD.
I haven't got any further at this stage. The schemas are not documented by Cisco, so it's a reverse engineering task. The other obstacle is that the schemas could change without notice.
My other option is to use the DEE ( Data Extracting Engine ), which is provided as an unsupported add-on to RME 3.4 and is build into RME 3.5. This utility extracts inventory data into XML formatted files, which in turn can be imported by OVSD.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide