I have a similar system, with similar database model in 6 different servers.
I am able to produce a single business view on their behalf, given that they have a similar tables, but I have to create 6 different connections to find the source DB.
So, whenever we require a report I must allow it to be 6 occasions, each one of these utilizing a different connection.
It is possible to method to merge the tables of those DBs to 1 single DB connection, to ensure that with one report i am capable of getting all the details I want?
I am talking about, is it feasible related to the company View framework, without needing to depend on ETL and Data Warehouse solutions?
I suppose you're talking about a BI atmosphere. You can establish the db connections around the db-server and make up a db-take on one db-server. That might be your master server, in which you set on.