SOQL Query with SSIS source component

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Cloud Applications
Post Reply
stevechown
Posts: 3
Joined: Tue 09 Feb 2016 12:16

SOQL Query with SSIS source component

Post by stevechown » Tue 09 Feb 2016 12:23

Does anyone know how to execute a SOQL query using the SSIS source component ? It looks to me like the only option is an SQL query.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: SOQL Query with SSIS source component

Post by Shalex » Tue 09 Feb 2016 16:34

There is no way to execute SOQL via Devart Salesforce Source at the moment. We will investigate the question and notify you about the result.

stevechown
Posts: 3
Joined: Tue 09 Feb 2016 12:16

Re: SOQL Query with SSIS source component

Post by stevechown » Tue 09 Feb 2016 17:16

Thanks for the reply. Below is what is on the devart website regarding this:

"Both SOQL and SQL for Querying Data

Our Salesforce Source component allows querying data with both SOQL and a subset of SQL-92."

This is very misleading if not true and the component does not allow querying data with SOQL.

We have a number of SOQL queries which we are finding difficult if not impossible to convert to SQL without the component downloading the complete data from the relevant tables and executing the query locally which takes considerably more time than our current practice of using the Salesforce data loader and a SOQL query.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: SOQL Query with SSIS source component

Post by Shalex » Wed 10 Feb 2016 13:16

Thank you for pointing this out. We will correct the product page. The SOQL support is limited and available only via SalesforceCommand (no use in Salesforce Source component).

dotConnect for Salesforce executes SQL statements, that are SQL-92 standard compliant: http://www.devart.com/dotconnect/salesf ... ement.html. Also you can use core SQLite functions (https://www.sqlite.org/lang_datefunc.html):

Code: Select all

SELECT Id FROM Account WHERE LastModifiedDate > date('now','-1 hours')

Post Reply