You can access any survey, and related data, in your account. The CData MCP Server for SurveyMonkey models entities in the SurveyMonkey API as tables, views, and stored procedures.

These are defined in schema files, which are configuration files with a simple format that makes the schemas easy to extend.

Using Query Processing

The server offloads as much of the SELECT statement processing as possible to the SurveyMonkey APIs and then processes the rest of the query within the server. The following sections document API limitations and requirements.

Filtering Limitations

Most views require at least one filter condition to retrieve data. When querying such views the OR operator will be supported only under the following conditions: 1. It is not combined with other AND operators 2. Both, left and right sides of the OR operator use the same fields and use Equal (=) for comparison. For the views that do not require any filter condition the OR condition will be evaluated on the client

Views

The server models surveys and survey statistics as relational Views. Views are tables that are typically read-only.

Stored Procedures

Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.