SOQL Query with SSIS source component
-
- Posts: 3
- Joined: Tue 09 Feb 2016 12:16
SOQL Query with SSIS source component
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.
Re: SOQL Query with SSIS source component
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.
-
- Posts: 3
- Joined: Tue 09 Feb 2016 12:16
Re: SOQL Query with SSIS source component
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.
"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.
Re: SOQL Query with SSIS source component
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):
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')