Skip to main content
Solved

Connecting to MSSQL from Flow Hosted

  • May 6, 2025
  • 2 replies
  • 57 views
larsatomkeere
Contributor
Forum|alt.badge.img+9

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?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

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

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

larsatomkeere
Contributor
Forum|alt.badge.img+9
  • larsatomkeereContributor
  • Author
  • Contributor
  • 12 replies
  • 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?

Community Stats

32,099
Posts
121,889
Replies
39,743
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.