You’re offline. This is a read only version of the page.
Hi.
I´m very new to Dynamics, so I don´t know how to import from a DB data I know that I can import files from Excel or CVS files. But I was wondering if there´s is an easy way to migrate data from Azure to Dynamics.
Thanks for your help.
Sincerely,
Michael.
*This post is locked for comments
I think, that the easiest way to import your data from a DB (SQL Azure in this case) to Dynamics (cloud) is to use 3rd-parties service - Skyvia. It`s a cloud-based solution, that does not require any coding knowledge.
Here you can find more info about import/export:
You can combine Azure Functions with Logic Apps.
azure.microsoft.com/.../app-service-logic-azure-functions
The Logic App can run when a new CSV is added to a SharePoint folder. Then, you can pass the file to an Azure Function to parse it and return the results. Then the Logic App can insert/update in CRM as needed.
Some other helpful links:
azure.microsoft.com/.../connectors-create-api-sharepointonline
hi Dev,
Were you able to achieve this using Azure Logic App? I am also having a similar scenario with only difference is that I have CSV files uploaded on SharePoint folder from where I need to import them in to CRM.
I am facing a lot many challenges, and not sure, whether this is possible through Azure Logic App or not?
If you can share your experiences and outline the solution, that would be too great.
Many thanks in advance.
Regards,
Nirman
Thanks a lot! Logic Apps seems the way to go.
Cheers.
Michael.
Hi Michael, if your data is simple and can be done in flat files then as Mark suggests is best. I have not tried the support ticket with a custom database so interesting to see when they would do that. If you have a more complex scenario where you want to perform logic and mapping then you might want to also want to check out Azure Logic Apps as they have a CRM Online connector as well as various other connectors that you might be able to use. The challenge you might need to figure out is, what is your trigger process so you know when to import data.
azure.microsoft.com/.../apis-list
azure.microsoft.com/.../connectors-create-api-crmonline
For the trigger you could do something like a recurrence every 5 minutes get top 100 rows where not imported from table, for each create a new CRM record. Let it run until all rows are imported and your done, or leave it running and as data gets added to the custom Azure DB it will be sync'd to CRM.
Hi Michael,
If you are doing it to an online CRM you would need to open a support ticket with Microsoft and have them do it. The other option is export the rows you need and import them as CSV
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (