Skip to main content
Question

Does FME support connecting to Azure SQL Data Warehouse or Snowflake?

  • September 9, 2020
  • 3 replies
  • 41 views

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.

3 replies

david_r
Celebrity
  • September 9, 2020

Forum|alt.badge.img+2

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

FME ODBC doc

FME JDBC doc


  • Author
  • September 14, 2020
jlutherthomas wrote:

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

FME ODBC doc

FME JDBC doc

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.


Reply


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