Setting up a database link for the Snap WebHost login

1. Open the survey in Snap Professional.
2. Click on the toolbar (or select File | Database Link) to display the Database Linkage dialog box.
3. Click [New...] to create a new database link. The Database Wizard dialog is displayed.
4. Select the WebHost Survey/Invites radio button (default)
5. Click [Next>]. The Database linkage dialog is displayed.
6. Click [Select Database File...] and browse to the Excel or MS Access file containing the respondent IDs and data

   OR

   click [Build Data Link...] to build a link to an Oracle or SQL Database with the same information.

7. The Select the Table to use drop-down automatically displays a table name. If this is not the table you require, select a different table from the list. If you wish to filter the respondents so that this survey is only available to some members of the database, set an appropriate filter in the Where condition box. Click [Next>].

   

8. Select the Log in respondent radio button and select the respondent ID/login field from the drop-down list. This will be used to set up the Respondents in Snap WebHost. Click [Next>]. (Transferring data from the database is described in Seeding the questionnaire.)

   

9. You will see a summary of what the database link does. Enter a name for the link and click [Finish]. You will need to select the database link when you publish.

For further information about logins see Working with logins.

Note that you also need to include one or more appropriate paradata variables for the login in the survey.

See Also What you need in your database (for seed data, email invites and/or logins) Setting up email invites for Snap WebHost using a database link Seeding the questionnaire with data for Snap WebHost Setting up a database link for grouped questionnaires Selecting the database link