Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
makdev11
New Contributor

Salesforce Bulk API

Hi Community,

I have come across an issue with one of the tables we read daily from salesforce.com.  It fails intermittently i.e. some days it runs fine and some days it stops reading data after fetching some records and just hangs indefinitely.  Current work around is we manually restart and sometimes it works right away, other times it takes 2-3 task restarts to get it working.  We have been monitoring saleforce connector logs, document and task logs it always at the same table.

Our resident salesforce.com developers have suggested us to use Bulk API but I have no prior knowledge about it.  Looked it up and says its possible through expressor.  But I wanted to know if anyone has used Bulk API without expressor or is there any work around for larger tables.

Suggestions appreciated.

Thanks

Mak

Tags (1)
1 Reply
makdev11
New Contributor

Re: Salesforce Bulk API

Hi Community,

Bulk API is part of the Salesforce connector v12.  You will need to make sure your salesforce Id used for extracting data has bulk API enabled on their end.  From the limited testing we were able to do it seems to only work with queries where you have no conditions in the where clause but this could change as we get further along into testing.

Thanks

Mak

Community Browser