Capturing Salesforce object changes in real time with Talend ESB - 8.0

Capturing Salesforce object changes in real time with Talend ESB
Version
8.0
Language
English
Product
Talend Data Fabric
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Business applications > Salesforce components
Data Quality and Preparation > Third-party systems > Business applications > Salesforce components
Design and Development > Designing Routes
Design and Development > Third-party systems > Business applications > Salesforce components
Last publication date
2024-02-06

This article shows how to capture and propagate real time changes happening in Salesforce using Talend ESB.

Salesforce provides on-demand customer relationship management (CRM) software services and many Talend users have chosen Salesforce as their cloud CRM provider.

Some users want to capture real time changes occurring in Salesforce on their CRM data in order to propagate or synchronize those changes on third-party applications. It is somewhat similar to Change Data Capture with Relational Databases, but for Salesforce.

Overview

In order to capture and propagate real time changes happening in Salesforce, you need the following technologies:

Outbound Messaging is part of the workflow rule functionality in Salesforce. Workflow rules watch for specific kinds of field changes and trigger automatic Salesforce actions, such as sending an outbound message to external applications.

To understand this article, you need some knowledge of Salesforce and Outbound Messaging, Talend ESB and Mediation routes, Web Services technologies, and Apache ActiveMQ.

Environment

This article was written using the commercial version of Talend ESB which provides more features than the open source version.

This article is also valid for previous commercial versions of Talend ESB.

Prerequisites

  • You have a valid Salesforce account: a free Developer Edition account can be created for testing purposes on the Salesforce website at https://developer.salesforce.com/signup.
  • You have installed Talend Studio.
  • You have a installed Apache ActiveMQ: ActiveMQ is shipped with the Talend ESB installation. Alternatively, it can be downloaded from the Apache ActiveMQ website.

For more information on the procedure to install and configure both Talend ESB and ActiveMQ, see Talend Help Center .

Architecture of the flow to capture changes

The diagram below shows the architecture for this example:

  1. Salesforce User updates a Salesforce object.
  2. Salesforce sends an outbound message to Talend ESB to notify object update.
  3. Talend ESB persists the notification message in an ActiveMQ queue.
  4. Talend ESB receives acknowledgement of successful persistence in ActiveMQ.
  5. Talend ESB answers with a successful acknowledgement back to Salesforce.