ODBC to CI_InfoObjects

[mblampe]

How do I create an ODBC to CI_InfoObjects?
I have a copy of the APS Database, but I don't see fields such as SI_LAST_RUN_TIME, SI_LOCAL_FILEPATH.

I would like to create a Crystal Report showing report run times during a data range and report error messages.

Is the only way to access the SI_ fields through .csp query or another language such as a java query?

 

[synapsevampire]

This is a Crystal Enterprise forum, which uses different structures, you might receive better responses in the Seagate Info forum.

Here's an interesting article from CD on performance monitoring:

http://support.crystaldecisions.com/communityCS/TechnicalPapers/si_advancedadmin.pdf

-k

 

[mblampe]

I want to set up an ODBC to a copy of the Crystal Enterprise 8.5 APS database.

Below is from CE 8.5 Launchpad, CSP Query Builder:

If you are not familiar with SQL syntax, click here. Otherwise, you can enter the query statement below to access the APS.
(eg. To select all reports in the aps, enter SELECT SI_ID, SI_NAME FROM CI_INFOOBJECTS WHERE SI_PROGID = 'CrystalEnterprise.Report')

 

[khartman]

Is there a way to report directly against the APS database? I have used the Query Builder tool provided with 8.5; however, I would like to generate a report which displays a grouping by folder of the report object which reside in the APS. The query builder does this but I have to run two reports. Including the SI_PARENTID field in the above query I can run a report against all CrystalEnterprise.Folder objects and then a second report which runs against the CrystalEnterprise.Report objects. then I have to manually match up the ID's to determine which parent folder the report object belongs in. There has to be a better way to do this.

Kenneth Hartman
Manager, EIS
Hughes Network Systems

http://www.hns.com

 

[Turkbear]

Hi,
The APS database stores its info in hashed and coded strings, etc. that are not readily accessed directly.

Look at the sample code provided in the Query Language Gulde (accessed from Launchpad) - It has most of the info you need to construct that kind of query ..