[teiid-issues] [JBoss JIRA] (TEIID-4284) Implement Salesforce Bulk API for SELECTS to Salesforce Connector

[sameer P (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13306812#comment-13306812 ] 

sameer P edited comment on TEIID-4284 at 10/13/16 12:12 PM:
------------------------------------------------------------

Yes exactly Steven, and one more interesting thing is that, as I went through the Salesforce web UI which shows the number of batches that will be created for a submitted query, there will always be a single batch that will be created on first query (irrespective of how big the table is). And from the second execution of the same query on wards, the query will be distributed into batches. Is this the expected behavior?  


was (Author: sameerp):
Yes exactly Steven, and one more interesting thing is that, there will always be a single batch that will be created on first query (irrespective of how big the table is) and from the second execution of the same query on wards, the query will be distributed into batches. Is this the expected behavior?  

> Implement Salesforce Bulk API for SELECTS to Salesforce Connector
> -----------------------------------------------------------------
>
>                 Key: TEIID-4284
>                 URL: https://issues.jboss.org/browse/TEIID-4284
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Salesforce Connector
>    Affects Versions: 8.13.5
>         Environment: With Salesforce datasource
>            Reporter: sameer P
>            Assignee: Steven Hawkins
>             Fix For: 9.1
>
>
> There is some huge data (many GBs) in the Salesforce which has around 1.5 million rows and doing some simple select * on it fails with QUERY_TIMEOUT.  
> The salesforce guys suggested to try Bulk API for select with PK chunking as stated in https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/asynch_api_code_curl_walkthrough_pk_chunking.htm . 



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)