Skip to main content
Solved

Connecting to MSSQL from Flow Hosted

larsatomkeere
Contributor
Forum|alt.badge.img+8

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.

Best answer by hkingsbury

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

View original
danilo_fme
1 person upvoted this
  • danilo_fme
    danilo_fme
Did this help you find an answer to your question?

2 replies

hkingsbury
Celebrity
Forum|alt.badge.img+54
  • hkingsburyCelebrity
  • Celebrity
  • Best Answer
  • May 6, 2025

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

larsatomkeere
Contributor
Forum|alt.badge.img+8
  • larsatomkeereContributor
  • Author
  • Contributor
  • May 12, 2025

​@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?

Reply


Helpful Members This Week

Community Stats

31,313
Posts
118,737
Replies
38,899
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.