Get Data from Multiple Databases SQL Server Respondida

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 

Comentarios

1 comentario

Fecha Votos
  • Comment author
    Thomas
    • Comentario oficial

    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

Iniciar sesión para dejar un comentario.