I've been trying to create a custom report and have reached the stage where a list of the stored procedures would be useful. I've downloaded and installed the Informix JDBC driver and integrated it with the Squirrel SQL client, but when I try to browse any part of the database it shows as being empty. I've tried two different operating systems using the same UCCX server and don't seem to be able to get around the problem. Any advice would be appreciated.
Not sure if you exported the UCCX DB to external Data Warehouse ?
If not, please do so as connecting directly to UCCX DB for custom reporting is not recommended & unsupported.
Q. How to export Historical Data to your own Data Warehouse?
A. Use third-party database administration tools such as SQuirreL SQL Client or AGS Server Studio to export Unified CCX historical data to your own data warehouse. Use "uccxhruser" as the username to connect to db_cra database.
Pls rate helpful posts by clicking on the stars below the post !!
The problem seems to have been caused by the JDBC driver. Version 3.70.JC1 can retrieve the tables without problems! It's still not possible to see the stored procedures with Squirrel SQL though. Eclipse with Data Tools Plugin gets you slightly further, but it doesn't seem to display the stored procedures fully. I'm now trying AGS Server Studio.
Am I right in thinking that in order to create custom reports, you need to create your own stored procedures? Does this involve learning the Informix Stored Procedure Language, or is there a simpler way to do it?
You have to create a SP to return the data as Crystal/HRC require you to run one statement to return the data, and you can't just run a 'select' with lots of joins. So you have to create a procedure that is called in one with the paramters set in the HRC client (start, end dates, filtering etc) and returns a single table.
There's no simple way to do it, but I:
Use that IBM 'boulder' site that crops up when you google anything and informix for researching syntax etc
Look at the UCCX standard SPs to see how they work - check the .xml definition file for a report to see what procedure it uses, and work out what it's doing.
When writing your own, use the standard UCCX reports as a basis - e.g. you can reuse some of the calculations, filtering parameters and style of writing.
I'm not able to access my old voice mail messages all of a sudden. The recording says something like 'the message is currently not available'. This has never happened before in all the years I have been using this system. I have t...
If you have 2 ISR routers, one acting as Failover, do we need to have both the same number of SRST licenses on the 2 routers?
No. You will only need the SRST licenses on the primary router. Because this feature...