Hello, Yes, Airbyte can be suitable for your task as it is an open-source data integration engine that helps consolidate data in your data warehouses, lakes, and databases. It supports various synchronization modes, including full refresh and incremental updates. For the first phase, you can use Airbyte's
full refresh synchronization mode, which retrieves all available data from the source and writes it to the destination. There are two variants of full refresh:
overwrite and
append. You can learn more about full refresh synchronization in this [tutorial](
https://airbyte.com/tutorials/full-data-synchronization). For the second phase, you can use Airbyte's
incremental synchronization mode, which replicates only the data that has been inserted or updated since the previous sync. Incremental sync is more efficient than full refresh as it reduces the amount of data copied on each sync operation. You can learn more about incremental synchronization in this [tutorial](
https://airbyte.com/tutorials/incremental-data-synchronization). However, it's important to note that some connectors may not support incremental sync yet. For example, the [LinkedIn Pages source](
https://docs.airbyte.com/integrations/sources/linkedin-pages) currently supports only full refresh, with incremental sync coming soon. To get started with Airbyte, you can follow the tutorials on [full refresh data synchronization](
https://airbyte.com/tutorials/full-data-synchronization) and [incremental data synchronization](
https://airbyte.com/tutorials/incremental-data-synchronization). Please ensure that Airbyte has connectors for the specific external systems you want to integrate, such as SharePoint and Salesforce. If not, you may need to develop custom connectors to meet your requirements.