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.
