Getting data out of Salesforce in near-realtime

Learn the different ways to get data off the Salesforce platform in near real-time using both on-platform and external solutions. In this session, we covered the the platform option like Outbound messages, Apex Callouts, and Salesforce connects and Off-platform options like Heroku Connect, Steaming Api, Change Data Capture, and Polling.

On Platform Options

1) Outbound Messaging

Pros

 

    • Automatic Retry

    • No Code Required

Cons

 

    • Order are Not Guaranteed

    • No Guaranteed Timeframe

    • Not Great with Large Data Volumes

    • No Related Data

    • Lack of Strong Security

2) Apex Callouts

Pros

 

    • Flexible Data Types

    • More Security Options

Cons

 

    • Order are Not Guaranteed

    • No Guaranteed Timeframe

    • No Retry

    • Difficult to Log Failures

    • Governor Limits

    • Must be in an @future call

3) Salesforce Connect (AKA External Data Source)

Pros

 

    • Real-time

    • Low Development Cost

Cons

 

    • Cost

    • Reliant On Endpoint Type

    • Limited Write Capabilities

Off Platform Options

1) Heroku Connect

Pros

 

    • Bi-directional Data Sync

    • Fairly Turn-key

Cons

 

    • Cost

    • Might Be Overkill

2) Streaming

Pros

 

    • True Realtime

    • Message Reliability

    • Message Durability

Cons

 

    • Lots of Work

    • Governor Limits Can Be Tricky

3) Change Data Capture

Pros

 

    • True Realtime

    • Message Reliability

    • Message Durability

    •  

Cons

 

    • No Related Data

    • Lots of Work

4) Polling (REST / SOAP)

Pros

 

    • Get Exactly What You Want

    • Bundle Multiple Queries

    • Large Data Ready

Cons

 

    • API Call Limits

    • Number of Records

    • Datetimes Stored to Second

    • Frequency

But what about…? Data Loader & Platform Event

 

    • Platform events aren’t a way to get data out.  They could be used in conjunction with the Streaming API

    • Data loader isn’t realtime

Here is recording of session:

YouTube video

Speaker         : Patrick Connelly
Date                : Saturday, 06 July, 2019 10:00 AM EST ( 7:30 PM IST

Please subscribe our YouTube channel to get notification for video upload.

Check our “Session in 2019” page for all upcoming and old sessions of 2019

5/5

Amit Chaudhary
Amit Chaudhary

Amit Chaudhary is Salesforce Application & System Architect and working on Salesforce Platform since 2010. He is Salesforce MVP since 2017 and have 17 Salesforce Certificates.

He is a active blogger and founder of Apex Hours.

Articles: 461

Leave a Reply

Your email address will not be published. Required fields are marked *