Skip to main content

We have an FME Flow Hosted instance running and I need to connect to an MS SQL Server. I have seen from the Reader/Writer documentation that MS SQL is not supported from FME Flow Hosted.

Does anyone have a suggestion how we could still connect to MS SQL?

The question is very relevant to us, since we plan to migrate to an FME Flow that will also run from an Linux-instance, which seems to be the cause why it isn’t possible to connect to MS SQL.

N.B. Our current FME version is 2024.0.3.

I wonder if you could use the generic ODBC or JDBC Reader?

​@hkingsbury That was my thought indeed and in the end we succeeded.

However, it is important to know that the ODBC-connection needs to be set in de ODBC-application (C:\Windows\System32\odbcad32.exe)

Now we run into two issues

  1. The ODBC-connection set in de ODBC-application is not uploaded to FME Flow Hosted and thus not recognized properly.
  2. the installed version of the ODBC-driver does not seem to support the geometry/geography columns used by MS SQL Server.

​@warrendev Chris, do you have any experience with this?

Community Stats

32,002
Posts
121,535
Replies
39,619
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.