linking Qualtrics Survey to SQL

LorrieLorrie OklahomaCommunity Member Qubie ✭

linking Qualtrics Survey to SQL

I need to link Qualtrics to a SQL server database and have Qualtrics bring rows of information over for my respondents to review and make decisions based on. Is there a way to do this?

Best Answers

  • TomGTomG Raleigh, NC Wizard ✭✭✭✭✭
    Accepted Answer

    Yes, add a web service call to your survey flow. The web service script will execute the SQL query and return output in json format that populates embedded data variables in Qualtrics.

  • TomGTomG Raleigh, NC Wizard ✭✭✭✭✭
    Accepted Answer

    @Lorrie said:
    Can I also set up a question option in Qualtrics where my respondent can search for a specific survey to review?

    I'm not sure I understand the question. Assuming it is related to your first question, you can pipe an answer to a question into an input parameter in your web service call. Then the web script could use it to build a WHERE clause in your SQL.

Answers

  • LorrieLorrie OklahomaCommunity Member Qubie ✭

    Can I also set up a question option in Qualtrics where my respondent can search for a specific survey to review?

  • IftakherIftakher AustraliaCommunity Member - Trial User Qubie ✭

    Hi Tom,

    Do you have an example on how to add a webservice script that can execute a SQL query in the survey flow? And, is it possible to connect to SQL server from Vocalise module for Dashboards and Reporting? Or can it only be done through csv?

    Kind Regards,
    Iftakher

  • TomGTomG Raleigh, NCCommunity Member Wizard ✭✭✭✭✭

    Here are directions for calling a web service from the survey flow. The actual script code will depend on a bunch of factors: scripting language, SQL database type, web server set-up, etc.

    I don't use Vocalize so I can't help there.

Sign In to Comment