Easy Data Migration from Salesforce to SharePoint
RSSBus Data Providers are development tools that simplify a large variety of tasks. In this demo, we will show how you can use the RSSBus data providers to transfer data from one source to another.
Migrating data between sources is often tedious, but this is made simpler by using the RSSBus data providers which abstract out vendor-specific APIs into a standard interface. Mapping columns from source to destination can in fact take as little as a dozen lines of code.
The Salesforce.com to SharePoint Migration Assistant demonstrates how RSSBus Data Providers convert data from source to destination in an orderly process: enter your credentials, select the tables you want to migrate, map the columns, and go. The code in the demo is also highly modifiable. Since all the Data Providers use a common interface, changing the source or destinations to something else (e.g., QuickBooks, Google) is a matter of replacing the providers.
This sample is just a simple demo where we copy every row in the source table to the destination. Several improvements can be made that make this more robust. As an example, it is possible to update the destination with only the most recently modified data in the source. Implementing this is matter of altering the query the demo uses to pull down data from the source by adding to it some sort of condition.