EM connector to Azure Synapse?

Cambridge2022 · March 17, 2022, 10:56am

Hi

Is it possible create a connector from EasyMorph to Azure Synapse?
I tried to create a Microsft SQL Server connector with Datahub in Azure Synapse, then it pops up an error message, attached. Any ideas? Thanks!

BR.Cam

dgudkov · March 17, 2022, 12:29pm

Welcome to the Community, Cam!

We never tried to connect to Azure Synapse using the SQL Server connector so don’t promise it would work. You can try the following settings:

See here how to find your server name: Connect to Synapse SQL - Azure Synapse Analytics | Microsoft Docs.

Specify also these custom properties in the connector:

Cambridge2022 · March 17, 2022, 1:47pm

Many thanks dgudkov! Will check it out.

Cambridge2022 · March 22, 2022, 12:51pm

Hi dgudkov,

It’s not working.
See the error message attached.
Could it due to the authentication?
In Microsoft SQL Management Studio (SSMS) Authentication method calls Active Directory – Universal with MFA support. I was able to connect the Azure Synapse in SSMS.

Now the question is, how could I connect EasyMorph to SSMS to query the data?
Thanks!

dgudkov · March 22, 2022, 1:23pm

Can you post a screenshot of your connector settings?

Cambridge2022 · March 22, 2022, 1:39pm

Here you go.

dgudkov · March 23, 2022, 11:41pm

We did a bit more investigation and it appears that the native SQL Server connector can’t work with Synapse. You need to use the ODBC connector:

Configure an ODBC connection (system DSN) to Synapse in Windows settings
In EasyMorph, create an ODBC connector that uses the DSN. Use the “SQL Server” SQL dialect in the connector.

Cambridge2022 · March 28, 2022, 6:32am

Many thanks dgudkov! Yes, it’s working now.

For those with same problem like me:
Here are some key steps snapshot for your information.