Using the Direct Query Method

Use the Direct Query method to work with remote data in real time, rather than importing a local copy. As you define filters, aggregate fields, or join tables, the connector executes the underlying queries to CData Connect. Direct Query can be used when you cannot import data due to a large data set that may slow CData Connect, or in the event the data is actively changing and needs real-time updates.

Direct Query Limit

The Direct Query method is limited by the DirectQueryLimit connection property. If all of the following are true, the limit is replaced from the query to the settings in DirectQueryLimit.

• The QueryPassthrough=false
• The query is a SELECT
• There is a LIMIT clause or equivalent (like TOP)
• The value of the LIMIT is greater than allowed by DirectQueryLimit settings