Does FME support connecting to Azure SQL Data Warehouse or Snowflake? We want to be able to connect to and move data from either (or both) of those data sources into postgresql.
Question
Does FME support connecting to Azure SQL Data Warehouse or Snowflake?
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.
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.
FME can both read and write to Snowflake (spatial and non-spatial):
- https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/snowflake_nonspatial/snowflake_nonspatial.htm
- https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/snowflake_spatial/snowflake_spatial.htm
Concerning SQL DW (now called Synapse Analytics), I'm not sure.
See also: https://www.safe.com/fme/formats-matrix/
+2Hi @mmirobelli
Whilst I haven't personally read any data from Azure SQL Data Warehouse, you could try this Reader first.
If that doesn't work, it looks like it's possible to connect using ODBC/JDBC, which FME does support.
Hi @mmirobelli
Whilst I haven't personally read any data from Azure SQL Data Warehouse, you could try this Reader first.
If that doesn't work, it looks like it's possible to connect using ODBC/JDBC, which FME does support.
Thanks for the information. I upgraded to 2020.1 in order to access the Snowflake reader/writer. I'll try the recommended reader(s) for Synapse Analytics.