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 API's 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.