How to pull mssql server 2019 data from remote server?

See more:

SQL

remote

stored-procedure

Hi
I need to pull remote data to local server(In Premises) for
Analyzing report for Management Dashboard

I have used Merge command in Stored Procedure, it works fine in same
instance or same network SQL Server. we have remote server credential.
It is also our server.

But how to pull data from remote server.

Pls advice me

Thank you...

Maideen

What I have tried:

It is my Stored Procedure

	MERGE [dbo].[tbl_Finance] AS TARGET
	USING edgeadv.[dbo].[MOHead] AS SOURCE 
	ON (TARGET.DocNo = SOURCE.DocNo) 

/* =============================================
	UPDATE 
	===========================================*/
	WHEN MATCHED AND

		TARGET.DOCNO <> SOURCE.DOCNO OR TARGET.DOCDATE <> SOURCE.DOCDATE OR
		TARGET.CATEGORY <> SOURCE.CATEGORY OR TARGET.TYPE <> SOURCE.MOTYPE OR
		TARGET.SUBTOTAL <> SOURCE.SUBTOTAL OR TARGET.GSTP<> SOURCE.GST OR
		TARGET.GSTR <> SOURCE.GSTAMT OR TARGET.GROSS <> SOURCE.TOTALGROSS OR
		TARGET.NETTTOTAL <> SOURCE.NETTTOTAL OR TARGET.TAX <> SOURCE.GSTAMT
	THEN 
	UPDATE 
		SET
		TARGET.DOCNO = SOURCE.DOCNO , TARGET.DOCDATE = SOURCE.DOCDATE ,
		TARGET.CATEGORY = SOURCE.CATEGORY , TARGET.TYPE = SOURCE.MOTYPE ,
		TARGET.SUBTOTAL = SOURCE.SUBTOTAL , TARGET.GSTP = SOURCE.GST ,
		TARGET.GSTR = SOURCE.GSTAMT, TARGET.GROSS = SOURCE.TOTALGROSS ,
		TARGET.NETTTOTAL = SOURCE.NETTTOTAL, TARGET.TAX = SOURCE.GSTAMT
	
/* =============================================
	INSERT
	===========================================*/
	WHEN NOT MATCHED BY TARGET THEN 
	INSERT 
	(DocNo, DocDate, Category, Type, SubTotal, GSTP, GSTR, Gross, Tax, NettTotal)
	VALUES
	(SOURCE.DocNo, SOURCE.DocDate, SOURCE.Category, SOURCE.MOType, SOURCE.SubTotal, 
	 SOURCE.GST, SOURCE.GSTAMT, SOURCE.TOTALGross, SOURCE.GSTAMT, SOURCE.NettTotal )
;