Import data from a Azure DB

(0) Share

Report

Posted on by Community Member

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 have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

TheMarkChristie 10,328 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Colin V on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks a lot! Logic Apps seems the way to go.

Cheers.

Michael.

Was this reply helpful? Yes No
Nirman on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Tim Dutcher 2,100 on at

Like (0)

Report
Copy link

Link copied!

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

azure.microsoft.com/.../app-service-logic-loops-and-scopes

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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:

skyvia.com/.../integrate-dynamics-crm-sql-azure

Was this reply helpful? Yes No