Forum Discussion

jhcannon's avatar
jhcannon
Frequent Visitor
5 years ago

Connect to Different Datasource by User

Don't know if this is even possible!   Here is what I am trying to do.  We have multiple locations each with their own database.  All database schemas are identical.  I have created reports and das...
Need Help
jhcannon's avatar
jhcannon
Frequent Visitor
5 years ago

I really don't want to have multiple copies of each report.  We're looking at possibly 12-15 different locations and 30 or more reports/dashboards.  So that would be 500 to maintain instead of 30.  At this time, there are changes / additions to reports pretty much daily.  I expect that will level off at some point in the future but for now, I would rather not have to change 15 copies of a report if I can help it.

 

It just seems like there should be some way to connect to a different server depending on who is logged in.

 

I've been playing with parameters as the servername this afternoon some.  That may be a different way to handle this.  That seems to be working when I set the parameter manually, now to figure out how to set it based on the user.

aj1973's avatar
aj1973
Community Champion
5 years ago

jhcannon 

Yes I didn't think you could have so many servers, but using parameters as server name is also another way and to set up user filter you will need to Implement a RLS to you report.