Data Productivity Cloud Pipeline

Author: Matillion
Date Posted: Mar 25, 2025
Last Modified: Mar 26, 2025

Load Salesforce Data Incrementally

This pre-built pipeline can be used to load Salesforce data into Amazon Redshift.

For tables with an incremental column, e.g. SystemModStamp, only the latest changes will extracted each time the pipeline runs. For other tables, a full extract will be performed each time.

Pipeline features include

  • Syncronizing rows deleted in Salesforce.
  • Automatically handling schema changes within Salesforce.

Installation

  1. Open a branch on your Data Productivity Cloud project.
  2. Click “Add > Browse Exchange”
Image ofBrowse the Matillion Exchange to find pipelines to import
Browse the Matillion Exchange to find pipelines to import
  1. Search for “Load Salesforce Data Incrementally” and select the pipeline to import it into your project.
  2. You should now have a folder named “Imported from Exchange > Load Salesforce Data Incrementally” containing the latest version of this pipeline.

Usage

Open the orchestration pipeline “Imported from Exchange > Load Salesforce Data Incrementally > Example”.

Follow the instructions on the notes in this pipeline to copy the Run Orchestration component into your own orchestration pipeline, and configure it to load your Salesforce data into your data platform.

Image ofConfigure the Run Orchestration component to load the files into your data platform
Configure the Run Orchestration component to load the files into your data platform

Downloads

Licensed under: Matillion Free Subscription License

Installation Instructions

How to Install a Data Productivity Cloud Pipeline