Get Data from Multiple Databases SQL Server

Respondida

Dhia Shahateet

• 26 de abril de 2023 06:47

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 

Vote

0

• Comentario oficial

  

  Thomas

  • 26 de abril de 2023 07:42

  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.