Dynamic Database Connection on Report Refresh

[Former Member]

Hi,

I have a WEBI Report & Universe, which is duplicated inorder to fetch data from diff database based on each country.

i.e. If i have 3 countries (as databases are diff) for each country i have got specific Report and Universe. Same User can generate the report for diff countries.

Is there a solution to have only single report and single Universe for multiple databases? i.e. Can i switch database connection dynamically at report refresh.

All, the possible solutions are welcome (including SDKs).

Best Regards,

Anu

[former_member142702 · Accepted solution]

An option is to use universe restrictions for that. But the database you connect to is defined through the group memebership of the user that is starting the report.

If this does not fit your use case you have to use an SDK based solution (custom build)

Another option is to use the Data Federator.

Regards,

Stratos

Edited by: Efstratios Karaivazoglou on Oct 4, 2010 1:14 PM