Get Data from Multiple Databases SQL Server Answered

Dhia Shahateet

Dears

How i can get data from multiple databases sql server to DASHBOARD 

i have two server one for SAP B1 and the second for other system (POs).  i need to get data from two server and join it 

i wite QUERY like this 

select *  from [COUNTER-1\SQLEXPRESS].[posmulti1].[dbo].[PSalesMaster]

on SQL server management studio Query is running but is dashboard design not running 

Comments

1 comment

Date Votes
  • Comment author
    Thomas
    • Official comment

    Hi,

    You can select other databases running in the same server with the SQL syntax "dbo.", but you cannot access other database servers.

    Best regards,

    Thomas

Please sign in to leave a comment.