Is it possible to query the Crystal CMS database and get meaningful data back? The data appears to be encrypted.
I am running Business Objects Crystal Report Server version 11.5
+1
A:
I had a similar problem on my workstation at the office. It sounds like you need to reinstall (that's what worked for me). This is a known bug according BussinessObjects (I had to call them and use our maintenance support). Hopefully you can find more information by searching for, 'Crystal Business query corruption' instead of calling them if the reinstall doesn't work for you.
They told me the data is not encrypted, but occasionally components don't install correctly and the queries come back in a binary form that is all garbled.
Good luck!
A:
My experience is that the data is not encrypted but that it is not really readable. Your best option is to use the Auditor Universes to build you some reports. You can also check out the SQL that the auditor Universes are uses as a baseline for constructing additional reporting.
Mike Farmer
2008-09-17 05:05:01
+2
A:
Actually what I discovered I needed to do was use the administration tools available from the Administration Launchpad. I was not responsible for installing Crystal and did not even realise this existed. The query builder and also the "Report Datasources" feature that were available from here was exactly what I needed.
Evs
2008-09-17 05:36:42
+2
A:
Use the Query Builder tool to query the CMS: http://%5Bserver%5D/businessobjects/enterprise115/WebTools/websamples/query/. For more information about the query language, see http://devlibrary.businessobjects.com/businessobjectsxi/en/en/BOE_SDK/boesdk_dotNet_doc/doc/boesdk_net_doc/html/QueryLanguageReference.html#2146566.
The properties that are returned by this query are store in a serialized state (I'm guessing binary and encrypted) in the Properties field in the infoobject database table (I can't remember the actual name of the table).
Craig
2009-11-09 01:50:59
I was not aware of the Query builder, and the API. The only thing I dont like now knowing this, is its another thing to add to my already long task list :)
Lima
2010-01-22 02:38:29
A:
There are also several third party solutions out there that naturally layer "on top of" the CMS or Central Management Server to abstract the proprietary storage format into human-readable form. We develop a native database driver to the CMS which can be found at http://www.infolytik.com/products.
full disclosure: I'm the main developer and founder of Infolytik.
Atul
2010-03-26 13:26:42