How to build connection between Azure database and Survey Monkey.

Ankit Bharti 60 Reputation points
2023-11-10T18:15:37.0233333+00:00

I have been trying to link the Survey Monkey via Cloud Connection and the database which I have in the Azure SQL database. Please help me out to connect these two data sources.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,553 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,069 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,893 questions
{count} votes

Accepted answer
  1. Amira Bedhiafi 17,791 Reputation points
    2023-11-10T19:16:48.7733333+00:00

    You will start by creating a new instance of Azure Data Factory. Within the Data Factory, create a new pipeline.

    Then, you need to get an API key from Survey Monkey to access your survey data since it already provides REST API to manipulate data.

    In Azure Data Factory, create a linked service that connects to the Survey Monkey API. This might require custom connector development as Azure Data Factory doesn't have a built-in connector for Survey Monkey.

    CDATA is an example : https://www.cdata.com/kb/tech/surveymonkey-cloud-adf.rst

    Skyvia also : https://skyvia.com/data-integration/integrate-surveymonkey-sql-azure

    Then create a linked service to your Azure SQL Database and proceed with the mapping.


0 additional answers

Sort by: Most helpful