Which solution is recommended for importing prospect information into Salesforce on a nightly basis when using a batch process?

The recommended solution for importing prospect information into Salesforce on a nightly basis when using a batch process is change data capture with the Remote System as the data master. Change data capture (CDC) is particularly advantageous for batch processing scenarios because it efficiently tracks and captures changes in the source data without requiring the entire dataset to be transferred each time.

By utilizing CDC with the remote system as the data master, the integration can leverage the specific changes that have occurred since the last extraction. This method minimizes the volume of data being processed, as only incremental changes will be imported into Salesforce rather than performing a full data load every night. This results in better performance, reduced load times, and lower stress on both the source system and Salesforce.

In contrast, a real-time data integration using REST API typically caters to scenarios requiring immediate data availability, which doesn’t align with a batch processing approach conducted nightly. Manual data upload using CSV files is inefficient for regular updates, as it requires human intervention and can lead to errors. While change data capture with Salesforce as the data master is a viable option, it wouldn’t benefit from the efficiency of working with a remote system that possesses the most up-to-date information. Hence, the recommended solution focuses on the integration strategy that optimally utilizes updates