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

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Watch MrExcel Video

Forum statistics

Threads
1,102,294
Messages
5,485,998
Members
407,522
Latest member
rallan2020

This Week's Hot Topics

Top