One of the challenges with Dynamics CRM Online, and the cloud in general, is integrating cloud data with all your internal touch points and requirements.
If you want to do some detailed analysis of your account, contact or any entity data from Dynamics CRM, exporting a complete entity can take time and be laborious. Some companies like to have a 'backup' in case of extended outages.
Recently a client asked if he could download his 925000 row account table!
Download and install the trial (you can currently do this using the trial edition up to 10k rows without registering!)
Click the green 'Connect Data Source' on the left. Select the Dynamics CRM provider.
Enter in Dynamics CRM Online Details:
We must tell DS3 which columns we want to extract from the entity. The more columns we include, the more data that has to be downloaded which is therefore slower (Dynamics CRM will bring down about 1000 records per second). If you want ALL of the available columns, check the tick beside the 'Columns' item in the columns tree view on the left.
In this step we use DS3 to create a CSV file with the same shape (columns) as your source entity. Click tools on the menu bar, then Select the ‘Create CSV File’. Enter in the destination of the CSV file. This creates a new CSV file and points the destination of the download to it.
DS3 is more than just a download tool and is designed to synchronise two systems. In this case the CSV file is empty but we still have to compare it to the online entity. For performance you can change the Page Size in the CRM settings to be 5000 (the max permitted).
When it has finished synchronizinga, all of the data will be written to the csv file. All your records will now be in the CSV files, for some more interesting downloads you can download to a SQL Table, an XML File , an XML Dataset, an Excel Sheet etc.
This can be automated now using the DS3's Server component to just incrementally download the changes.