Solved

Configure SQL Server 2012 to receive HTTP POST data

Posted on 2013-06-18
6
917 Views
Last Modified: 2013-11-19

Intro

I designed a SurveyGizmo questionnaire for a client.

When a respondent completes a questionnaire, I manually export a CSV file then load into Excel or a SQL Server development database to prototype reports. This is inefficient, especially as this could reach 100s of respondents when it is fully launched!

SurveyGizmo inform me that I can setup a HTTP CONNECT (see image) action that will send respondent data directly to SQL Server 2012 via HTTP GET or HTTP POST. However, I will need to configure SQL Server 2012 to enable this.

Questions

How do I setup a  SQL Server 2012 Developer Edition to listen to HTTP POST requests, receive and populate a staging table in a database?

The image below requires a URL, presumably from SQL Server 2012. How do I enable this?

Thanks!

John Aeris

Output from SurveyGizmo
0
Comment
Question by:JohnAeris
  • 2
6 Comments
 
LVL 29

Expert Comment

by:Kumaraswamy R
ID: 39256075
0
 

Author Comment

by:JohnAeris
ID: 39256708
@rkworlds: Thanks for the quick feedback!

I am a BI Developer by trade, so SQL, Analysis and Reporting! Not had to configure anything like this before so any further insight would be invaluable.
0
 
LVL 38

Accepted Solution

by:
Jim P. earned 500 total points
ID: 39264800
How do I setup a  SQL Server 2012 Developer Edition

The Developer Edition is no licensed for this. You might be able to do it, but it is not within the license agreement.

You should be legal with the Express version. I'm not sure of the status of standard edition for this.
0
 

Author Closing Comment

by:JohnAeris
ID: 39274455
OK,
Thanks for the knowledge, didn't quite get a solid response however.

After some research, will use MySQL as a staging database then do an ETL process with SQL Server. Will definitely keep on eye out on the versions and licensing.

Thanks!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now