How to Import Salesforce Account data to CC

Thanks @bas! 

I certainly understand how it will be hard to get a good estimate. I’m hoping to provide a clearer picture to my Salesforce admin because they are concerned about the SFDC rate limit. I have a follow-up analysis that I would appreciate some help with, if possible.

We will use the Export and Import integrations. The documentation states that each of them runs every 6 hours to process accounts. Furthermore, the Export integration runs every 10 minutes to process community member activity.

• This totals 152 “runs” per day. Are there scenarios that would result in more than the 152 runs?

We have 665,191 contacts and 157,677 accounts in SFDC. 

• How do the syncs work, especially the first time these integrations run? Are these batch operations, or are operations carried out for each individual account? 
• Are there any settings on the inSided side for managing SFDC API calls / frequency? Have the integrations been designed to respect any rate limits?

I appreciate the assistance and expertise!

​​​​​​​

Hi @logicalhare , please not that while I was on holiday @arminfpop took over and is routing this to our engineering team. A bit more patience please, we’ll get back to you :) 

I don’t see the option to test this integration in sandbox. Is that the case? I only see the option to export community data to Salesforce, not import data from Salesforce to the community.

@logicalhare Hey Javier! I’ve updated your configs in your staging environment so you should now be able to see the option to import data from Salesforce to the Community 🙂

Thanks Joyce!

@logicalhare I’d love to hear how you go with understanding how the syncs work and how efficient they are/aren’t. 

We couldn’t find an answer to this other than it looks like everything is synced with each run…

We’re looking into an API solution where we can control the rates, what is synced etc.

If you discover that the the Salesforce integration is actually reasonably efficient then this would give us the chance to change our approach and save quite a bit of time :) 


 

@BenSmokeBall We’ve been testing in the staging environment but haven’t got a bunch of representative data yet. Hoping to meet with inSided this week to ask some follow up questions. Will keep you posted!

Hi @logicalhare @BenSmokeBall 

We received some rough numbers back from engineering. As you will understand, it is all quite dependent on the size of the community and the activities.

For import we query all the contacts and accounts (optionally) every 12 hrs. Each response could carry up to 2000 items, so we have to make <number_of_contacts>/2000 number of calls, the same for accounts.
For export we make a call per activity of a community user linked to a contact, so it depends purely on community activities.

And regarding the first run:

It is the same every 12 hours: all contacts with emails set are queried in batches of 2000 and (if company integration enabled) accounts are queried in batches of 2000.
We start pushing activities since the moment integration is enabled, so no burst of API calls is expected.

We do not offer configuration of these settings and the integration has not been optimized/designed to limit requests.

Regarding building your own API-based integration, I would advise you to await the new data / BI-tooling initiative:

Hope this helps!

Thank you @bas 

Quick follow-up:

• What is the optional part of the import? I don’t see anything that indicates an optional configuration in the setup to select contacts versus accounts.
  
  “For import we query all the contacts and accounts (optionally) every 12 hrs”
  
  It is the same every 12 hours: all contacts with emails set are queried in batches of 2000 and (if company integration enabled) accounts are queried in batches of 2000.

Ah yes sorry, I should’ve been clearer.

The salesforce integration has several parts, the “import Salesforce Account data to inSided” can be turned off, then it won’t sync/query accounts.