data connection from several databases same model same SQL

dida

New Member
Joined
Jun 27, 2011
Messages
15
hi
I want to get data from SQL, the problem is that in this SQL there are several databases
each for different company
the tables and model in each database in the same SQL host is exactly the same
I do not need one data base but several all together
finally I wish to create dashboard and reports from all databases in a way that I can slice the company=database or get aggregation from all the company=database together.
for now I build everything on on one data the duplicate it and change the database name but i get seperate files for each database which is not what I want....
HELP!
 
Last edited:

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Watch MrExcel Video

Forum statistics

Threads
1,099,263
Messages
5,467,643
Members
406,545
Latest member
puneet829

This Week's Hot Topics

Top