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...