data connection from several databases same model same SQL
Results 1 to 2 of 2

Thread: data connection from several databases same model same SQL
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2011
    Location
    Tel aviv - Israel
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default data connection from several databases same model same SQL

    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 by dida; Jul 20th, 2019 at 05:10 AM.

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,579
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    1 Thread(s)

    Default Re: data connection from several databases same model same SQL

    try to use PowerQuery aka Get&Transform
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •