Cannot preview data from Salesforce.com in Data Virtualization
You get an error when you try to preview data from Salesforce.com.
Symptoms
When you try to preview data from the Salesforce.com, you see the following error
message:
[DataDirect][SForce JDBC Driver][SForce]MALFORMED_QUERY: OBJECT_NAME: a filter on a COLUMN_NAME column is required
Causes
Certain objects on the Salesforce.com data source require at least one filter for query executions.
Resolving the problem
Use the SQL editor to preview the data. Ensure that you add a filter on aWHERE
clause to your query. For example, you can use the EntityDefinition filter.