Multiple Database Switching Based on User-Login

Summary

RPD - DataModeling

Content

Hello Team,

We are looking for database switching based on user login. We are able to achieve Database switching using session variable in RPD connection pool via datasource name section. But the requirement is to have more than 1 active database connection at a Time( i.e having more than 1 databases to retrieve data from at the same time). - Is this possible in BI - Administration tool RPD modeling ? Or any suggestions across this to resolve.

Thanks in advance.