I have a customer wanting some custom Crystal Reports based on Operations Manager (or the DFM database to be precise). Can this be done by connecting directly to the Sybase database, or does the data need to be exported first? If we wanted to run regular reports for instance, this could make scheduling a bit tricky.
Any pointers would be much appreciated. I know I can do a lot with Operations Manager custom reports anyway, but the customer already has a lot of Crystal Report writers and they can make short work of the reports for management summaries once they get the database structure and connections all sorted.
I apologize for beating a dead horse, but I cannot figure out how to connect to the database backend. I understand what I'm being asked to do, but I cannot find the Adaptive Server Anywhere 9.0 ODBC driver (in fact the one on my Operations Manager server doesn't even work). I've created many ODBC connections in the past, so that's not the issue.
The technical document doesn't explain how to use the JAR files to create a JDBC connection. I can't seem to find any documentation on how to use these files.
Funnily enough I was just looking at this last night, I tried the same copying the dll's and it didnt work, so I downloaded the ianywhere v10 developer edition and installed very little, just the client tools, it then worked. However I was messing about for ages before I realised that I had created a 64bit ODBC connection.
rather than running the 64bit version which is:
I have created an ODBC connection as I am looking at pulling the data from the ops mgr database into SQL using an SSIS package so that I can get my monthly capacity report to pull the aggr and vol stats for some volumes.