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.
Page 1 / 1
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/
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.
Azure SQL DW Connection strings examples
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.