I want to connect Azure Synapse Database to Informatica version 10.2 but it requires Level 2 Certified ODBC drivers to connect. Where can I get it from?

Question

I want to connect Azure Synapse Database to Informatica version 10.2 but it requires Level 2 Certified ODBC drivers to connect. Where can I get it from?

I was having difficulty to connect Azure Synapse database with Informatica Server. I contacted Informatica Vendor and they told me to get Level 2 Certified ODBC drives, please tell me where I can obtain it from.

Thank you

Answer 1

@Meet Patel

Thank you for reaching out.

The supported tools by Microsoft are mentioned in the following doc. https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/get-started-azure-data-studio

Please do check the link below. It was not specified which level it is using for the ODBC driver, and I could not find it anywhere.

https://www.cdata.com/drivers/azuresynapse/odbc/

You could also use the Microsoft Azure Synapse SQL Connector to connect to Azure Synapse SQL from Informatica. Here are the details:

Connector Overview:

• The Microsoft Azure Synapse SQL Connector allows you to read data from or write data to Azure Synapse SQL.
• You can create a Microsoft Azure Synapse SQL connection and use it in Data Integration mappings and tasks within Informatica. https://docs.informatica.com/integration-cloud/cloud-data-integration-connectors/current-version/microsoft-azure-synapse-sql-connector/introduction-to-microsoft-azure-synapse-sql-connector.html

The connector is optimized for large data sets and can perform better than traditional methods like ODBC or JDBC.

Regards,

Oury