In 16.4.1 MUX Reporting Module, is it possible to run queries against the transactional database?

[Paul Schofield]

Hello,

The customer (on premise) has several custom Jaspersoft reports that run queries against the live database (not the data warehouse) and the data retrieved is then dumped into Excel.

I'd like to recreate these in the new MUX Reporting, but I don't see a way to create a report that uses a query against the live database, the data source seems always to be the warehouse.

If I change the query to replace references to cmn_sec_users (for example) to cmn_sec_users@ppmdblink (they're on Oracle) then I receive an error saying using the link isn't allowed. I worked round this by creating a synonym for cmn_sec_users as cmn_sec_users@ppmdblink.

I could also create a view from the query (and use the databaselink again) in the warehouse and just pull the columns from the view.

But... Is there a way to create a report with a query against the live database without resorting to the above?

Paul

-------------------------------------------

[Suman Pramanik]

Hi Paul 

Until version 16.4.1, there is no provision to pass a DB link to read data from the Clarity schema. However, please monitor the release preview for version 16.4.2 for any updates or enhancements related to this capability.

------------------------------
Thanks & Regards
Suman Pramanik
------------------------------

[Paul Schofield]

Thanks Suman!

-------------------------------------------