BI Publisher (MOSC)

MOSC Banner

Using variable for source database

edited Sep 18, 2014 5:07AM in BI Publisher (MOSC) 1 commentAnswered

Hi,

Here is what I need, but I don't know if it's feasible, and how to do it:

I want to have a datamodel (let's call it DM), querying on a variable database.

For example, if the user is from UK, then the SQL will be executed against database_UK ; but if the user is in France, then, the same SQL should be executed on another database (database_FR).

Is there any way to something like this ?

Both databases have the same tables (name, columns, etc.).

Thanks in advance for any clue that could help !

Regards,

Alexia

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center