Azure Synapse Analytics linked services connectors not available

Question

Hello.

I would like to connect to Synapse Analytics using linked services. Are there any prebuilt connectors available for these platforms in Azure Synapse Analytics?

Answer 1

Hi @Pankaj Jagdale

Yes, Azure Synapse Analytics supports prebuilt connectors. Here are some of them:

• Azure Blob Storage
• Azure Cognitive Search Index
• Azure Cosmos DB for NoSQL
• Azure Cosmos DB for PostgreSQL
• Azure Cosmos DB for MongoDB
• Azure Data Explorer
• Azure Data Lake Storage Gen1
• Azure Data Lake Storage Gen2
• Azure Database for MariaDB
• Azure Database for MySQL
• Azure Database for PostgreSQL
• Azure Databricks Delta Lake
• Azure Files
• Azure SQL Database
• Azure SQL Managed Instance
• Azure Synapse Analytics

In addition to these, Azure Synapse Analytics also supports connectors for other databases like Oracle, SQL Server, MySQL, PostgreSQL, and more.

Also, for connecting to Synapse SQL, Azure Synapse Analytics supports ADO.NET, ODBC, PHP, and JDBC.

** Important: Note that the availability of these connectors may depend on the specific requirements and configurations of your Azure Synapse Analytics setup.

More info:

• https://learn.microsoft.com/en-us/azure/data-factory/connector-overview
• https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/connect-overview

Wishing you well,

shirivo

Answer 2

Hello @Pankaj Jagdale

Azure Synapse Analytics provides a wide range of pre-built connectors for various data sources, but I am not able find having any pre-built connectors for Salentica, Orion, and Envestnet CRM.

Did you try generic connectors such as ODBC or JDBC to connect to Salentica, Orion, and Envestnet CRM. These connectors provide a standard interface for connecting to various data sources and can be used with Azure Synapse Analytics.

Integrate with more data stores