Using variable for source database
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