Data Productivity Cloud Pipeline
Author: Matillion
Date Posted: Mar 25, 2025
Last Modified: Mar 26, 2025
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
- Open a branch on your Data Productivity Cloud project.
- Click “Add > Browse Exchange”

- Search for “Load Salesforce Data Incrementally” and select the pipeline to import it into your project.
- 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.

Downloads
Licensed under: Matillion Free Subscription License
- Download pre_built_pipelines_salesforce_redshift_20250325.zip
- Target: Redshift