Community Groups are officially here!
We've released Groups, a new feature that enables us to connect community members of similar industries and interests in a shared, private space. You can check out all of the details here, including information about who can join, how to join, and what Groups are currently offered. Please leave your feedback through this Community Groups Feedback Survey.

linking Qualtrics Survey to SQL

Lorrie
Lorrie Oklahoma Qubie ✭

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

  • TomG
    TomG 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.

  • TomG
    TomG 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

  • Lorrie
    Lorrie Oklahoma Qubie ✭

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

  • Iftakher
    Iftakher Australia 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

  • TomG
    TomG Raleigh, NC 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.