UCCE 9.x - Connecting to external database?

Hey,

I was thinking outside the box and got an idea to combine figures from different systems (databases) within the Cisco reporting tool.

This would be very beneficial for me since the scheduling function works very well in Cisco.

As an example: I want a report which first show Cisco figures, and then I have a column from our E-mail system at the end.

Have anyone tried this before, or anyone who knows if this is possible?

I tried a PHP SQL connect command at the end of a report definition - which Cisco did not like.

mysql_connect('dbhost', 'dbname', 'dbpw') or die(mysql_error());

If this doesn't work I´ll do it in Report Builder but then I won´t have the cool scheduling functions.

Thanks in advance!

Robert,

There's no reason to expect a PHP command to work in a CUIC report definition. CUIC is expecting SQL queries, not PHP.

It's possible to perform queries that gather data from multiple databases on the same server. It is also possible to query multiple servers at once if they're set up as linked servers. Some details here:

http://stackoverflow.com/questions/1144051/selecting-data-from-two-different-servers-in-sql-server

Is your second server a MySQL server? I have no idea if this would work with MySQL.

-Jameson

Jameson,

HA! Got it working with the following command:

SELECT

*

FROM

[SERVER2NAME].[THEDB].[THEOWNER].[THETABLE]

Thank you for the help!! I`m sorry I couldnt find the answer myself.