Salesforce Data Pipelines is a high-performance data platform that can clean, transform, and enrich large volumes of data at scale. Data Pipelines offer two different types: input and output connectors. Use an input connector to extract data from a data source. Use an output connector to load the recipe results into a target.
Step 1: Go to Setup → Permissions set → Data Pipelines Base User and assign the permission to the respective user.
Step 2: Enable the data pipeline. Go to setup → quickFindbox → data pipelines
Step 3: Now open the Data Manager app from the app launcher. Add a new connection.
Step 4: In this example, we are going to move data to another Salesforce org. So that, Select salesforce connector,
Step 5: Add your salesforce username and password with the security token
To move or retrieve data from the target org. Please add an output connector.
Step 6: Select objects and columns for both connections.
Step 7: Go to Data Asset Tab → upload sample contact data set.
Step 8: Select the recipe tab and create a new recipe. It will redirect you to the data manager builder.
Step 9: Now we can start to configure to migrate the data. Add new input data. We can select a dataset we uploaded earlier.
Step 10: Again add input data and select the external salesforce connector you created earlier on the connection. This process will fetch the data from the target object from manipulation.
Step 11: Connect the two nodes. While connecting the node, it will ask you to select the action. Please select append to create data and map the fields.
Step 12: Add an output node and select the output connection for the Write to field. Select the output connector you created and select the target object. Then select the operation, whether you are going to insert or update.
Step 13: Finally, save and run the recipe. And check the status on the data manager screen.