Dynamics Community Forum Thread Details

How to export data from online Dynamics CRM to on premise SQL Server database

Hi,

We converted from an on premise Dynamics 365 CRM to a cloud version. We had a few SSIS packages that exported from Dynamics 365 and imports them to a SQL Server database. This worked fine when our CRM was also on premise. But it no longer works as the CRM is located in the cloud.

I was wondering if there is a way to create similar tasks that would export data from the cloud CRM to the on premise SQL Server? I read about KingswaySoft, but it's a bit pricey and I doubt we'll go this route. I also tried to use Power Automate, but I get the following error when I tried to query the records in the Accounts entity:

Http request failed as there is an error: 'Cannot write more bytes to the buffer than the configured maximum buffer size: 104857600.'.

Sincerely,

Jason

Hi Jason ,

Thank you for writing to us . I see we are wanting to perform the export of the CRM data from cloud to SQL on premises database.

Here is a link which has the same discussion https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/262903/export-data-from-crm-online-to-sql-data-base/832999 which was done previously.

Also regarding the usage of the Power Automate the error message you are receiving is a limitation as of now and we already have filed a suggestion for it

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Increase-the-maximum-buffer-size-from-100/idi-p/172620

Please mark my answer as verified if you found it helpful. Please let me know if you have any other questions around the above.

Bhartendu Pandey

Support Engineer - Customer Engagement- Dynamics CRM/PowerApps/Power Automate

Microsoft

Quick Links