[teiid-issues] [JBoss JIRA] (TEIID-2248) Implement Salesforce Bulk API for inserts/updates to Salesforce Connector

[Ramesh Reddy (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2248?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ramesh Reddy resolved TEIID-2248.
---------------------------------

    Resolution: Done


I ended up using the http://code.google.com/p/sfdc-wsc/ library after all, as it encapsulated lot of call and parsing details. I removed it's dependencies as Teiid does not use them.

The Bulk insert is only applicable for INSERT. There is code already for UPDATE and DELETE based upon multiple IDs. Also Bulk API does not support UPDATE/DELETE.

If there is an error inserting a row into SF, since the communication is ASYNC, there is no proper way to cancel the bulk job. So, the job continues, and reports which rows that have been not inserted. All these errors are currently exposed back to client as SQLWarning. Teiid can throw SQlException but that does not indicate whole job has been aborted, so I choose to implement as SQLWarning.
                
> Implement Salesforce Bulk API for inserts/updates to Salesforce Connector
> -------------------------------------------------------------------------
>
>                 Key: TEIID-2248
>                 URL: https://issues.jboss.org/browse/TEIID-2248
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Salesforce Connector
>            Reporter: Marc Shirley
>            Assignee: Ramesh Reddy
>             Fix For: 8.3
>
>
> Wish to utilize the Salesforce Bulk API for large inserts/updates.  The specific use case was for writing/updating a million record table back up to their Salesforce instance.  This will improve performance for large writes to the Salesforce instance.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira