How to build connection between Azure database and Survey Monkey.

Question

How to build connection between Azure database and Survey Monkey.

Ankit Bharti 60

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.

Ankit Bharti 60 Reputation points

2023-11-14T14:38:02.0633333+00:00

I have built a connection between the Survey Monkey and the Azure Data Factory. But while previewing the data in the Factory Resources - Datasets. I am receiving an

error: A database operation failed with the following error: 'Failure to execute 'executeQuery', SQL State HY000, Error Code 0, The query failed with the following error:

[500] Could not execute the specified command: A table could not be found that matches Contact Collection Form_Responses.

<Query ID: ca9f503d-f36d-4633-b996-723bdc02b401>.'

Failure to execute 'executeQuery', SQL State HY000, Error Code 0, The query failed with the following error:

[500] Could not execute the specified command: A table could not be found that matches Contact Collection Form_Responses.

<Query ID: ca9f503d-f36d-4633-b996-723bdc02b401>., SqlErrorNumber=0,Class=16,State=1,

Due to which I cannot create a pipeline. Another concern that I have is that, when I open the Survey Monkey's exported data in the XLSX file, I can see there are two header. I am not sure why.

Accepted answer

0 additional answers

Your answer

Ankit Bharti 60 Reputation points

2023-11-14T14:38:02.0633333+00:00

I have built a connection between the Survey Monkey and the Azure Data Factory. But while previewing the data in the Factory Resources - Datasets. I am receiving an

error: A database operation failed with the following error: 'Failure to execute 'executeQuery', SQL State HY000, Error Code 0, The query failed with the following error:

[500] Could not execute the specified command: A table could not be found that matches Contact Collection Form_Responses.

<Query ID: ca9f503d-f36d-4633-b996-723bdc02b401>.'

Failure to execute 'executeQuery', SQL State HY000, Error Code 0, The query failed with the following error:

[500] Could not execute the specified command: A table could not be found that matches Contact Collection Form_Responses.

<Query ID: ca9f503d-f36d-4633-b996-723bdc02b401>., SqlErrorNumber=0,Class=16,State=1,

Due to which I cannot create a pipeline. Another concern that I have is that, when I open the Survey Monkey's exported data in the XLSX file, I can see there are two header. I am not sure why.

Answer 1

Amira Bedhiafi 33,071 Volunteer Moderator

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.

ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2023-11-14T12:16:41.4266667+00:00

Hi Ankit Bharti, Just checking if above answer helps. If yes, please consider hitting Accept Answer button. Accepted answers help community as well. Please let me know if any further queries. Thank you.
Ankit Bharti 60 Reputation points

2023-11-14T14:19:58.0966667+00:00

I have linked the server within the Azure Factory Dataset. But I am not able to preview the data. The am receiving the

error: A database operation failed with the following error: 'Failure to execute 'executeQuery', SQL State HY000, Error Code 0, The query failed with the following error:

[500] Could not execute the specified command: A table could not be found that matches Contact Collection Form_Responses.

<Query ID: ca9f503d-f36d-4633-b996-723bdc02b401>.'

Failure to execute 'executeQuery', SQL State HY000, Error Code 0, The query failed with the following error:

[500] Could not execute the specified command: A table could not be found that matches Contact Collection Form_Responses.

<Query ID: ca9f503d-f36d-4633-b996-723bdc02b401>., SqlErrorNumber=0,Class=16,State=1,

I am not sure why.

Share via

How to build connection between Azure database and Survey Monkey.

0 additional answers

Your answer