CData Data Providers are development tools that simplify a large variety of tasks. In this demo we will show how you can use the CData data providers to transfer data from one source to another.

Migrating data between sources is made simpler by using the CData data providers, which abstract out vendor-specific APIs into a standard interface. You can use CData data providers to migrate data without relying on third-party servers to host the migration. Mapping columns from source to destination can take as little as a dozen lines of code.

The Salesforce.com to SharePoint Migration Assistant demonstrates how CData Data Providers convert data from source to destination. Data migration consists of three basic steps:

• Enter your credentials
• Select the tables you want to migrate
• Map the columns.

Each step can easily be modified to migrate data between any CData Data Providers. 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.

In the sample application, every row in the source table is transferred 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 adding a filter to the query used to pull down data from the source. For example:

SELECT * FROM Account WHERE LastModifiedDate > '1/1/2015'