Export data from CRM online to SQL data base

(0) Share

Report

Posted on by noo

130

Good afternoon.
There is a question of exporting data from CPM online to SQL data base
as far as I already know there is a solution - the export of data from the srm system to Azhur SQL. Besides an AZURE, is it possible to use some other base (free)? What are the solutions?
Maybe there is a standard functionality?

Thank you in advance.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

Hi Dima ,

the only way to export crm data-to-sql is passing from Azure.

Once time you have all your data on sql you can plan to do what you need (like move it to other platform).

This is the best tutorial to do it:

https://d365blogger.com/tag/crm-online-data-export/

Hope it helps!

If you found the answer helpful, please mark as Verified

Join my network on LinkedIn Follow me on Twitter

Thank You & Best Regards

Francesco Picchi

Microsoft Dynamics CRM Consultant, Bologna+Milano, ITALY

Independent Contractor

http://www.francescopicchi.com

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yeap, it`s possible. Take a look at Skyvia - cloud-based solution for no-coding integration with broad mapping and flexible scheduling features.

Free plan available

Was this reply helpful? Yes No
Enrico Bertaiola on at

Like (0)

Report

It depends....what you intend for "free". :)

If you want to make an architecture for test/dev/lab, I suggest to create a VM in azure with sql server dev edition installed

(I suppose it works also with express edition, but i need full feature to design a complete environment for dev purpose)

I'm using a vm A2 Basic with 3.5 giga ram and 130 storage (about 15€/month)

You can create a keyvault with a connection string to connect to sql server onpremises instead of sql azure.

ps: remind to open 1433 port in azure for all ip, or for ip of data export service in your region (more secure)

Was this reply helpful? Yes No
Mike Larson on at

Like (1)

Report

Here is the detailed description of Dynamics CRM and SQL Azure integration by Skyvia platform. You can also take a look at Scribe, by the way it was recently acquired by Tibco.

Was this reply helpful? Yes No