Solved

Using FME to connect to a MS SQL Server linked server

  • 11 October 2022
  • 1 reply
  • 5 views
nedwaterman
Rank
Badge +3

Hi all,

I need to connect to a linked server in my SQL Server. Is there a method of connecting to a Server Object using FME?

Alternatively I have a query that collects my data but running it through the SQLCreator doesn't produce any attribution (presumably because FME doesn't natively connect to the data).

Thanks

Neil

icon

Best answer by kailinatsafe 18 October 2022, 16:02

View original

1 reply

kailinatsafe
Rank
Userlevel 3
Badge +13

Hello @nedwaterman​, thanks for posting! Great question! FME does appear to be able to read from linked server objects. I created a linked server connection in SMSS and was able to consume records using the SQLCreator. You may want to double check your credentials and or query in FME! I’ve included the query below. Note: Be sure to check the results and look in the Feature information window, or expose the attributes to see them in the table view.

 

Select * from [linked server name].[catalog/db name].[schema].[table]

 

 Happy to help, Kailin

Reply


Community Stats

28,692
Posts
109,432
Replies
36,542
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.