Microsoft Dynamics 365 | Integration, Dataverse...

how i can connect with MySQL which is hosted on azure with Dynamic 365 (Online) via power Automate.

(0) Share

Report

Posted on by ZeeshanGhause

how i can connect with MySQL which is hosted on azure with Dynamic 365 (Online) via power Automate.

there is connector MySQL in power automate but it is for on premise it require gateway.

is there any workaround through i can connect with mysql ?

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (2)

Report

Hello,

You can create Http-triggerred AzureFunction that will do whatever you need with MySQL and return data if it's needed - clavinfernandes.wordpress.com/.../

Was this reply helpful? Yes No
ZeeshanGhause on at

Like (0)

Report

Thanks a33ik

In this way we have to write down lot of Code lines, Checks etc

We want an Automated Solution or Less Code , Could you please go through this scenario and requirement i know you are one of the right person...

i have portal(core .NET) and its DB(MYSQL) is being hosted on Azure online.I have D365 CRM Online. Now i want to push the data from portal DB(MYSQL) To D365 CRM Online. I want to schedule Realtime Jobs to do this type of work for the first time of data import and then whenever any change occur in table , i want to get that updated rows and want to push it in D365 CRM Online

Scenario:

Pulling data from mySQL db to Dynamics
Pulling all changes (changes / updates) from mySQL on a given entity since last run
Scheduling the process so the data is up to date in near real time

how we can achieve this?
via power Automate(it is only for on premise)?
via Custom apis(not best approach as huge data can create irretation)
Via kingswaysoft ETL (License required)
via power automate using SqlServer supporeted for online/onpremise crm(in this way have to migrate data from mysql to sqlserver)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

[deleted]

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (1)

Report

Hi,

I think best option to use Azure data factory for your requirement.

docs.microsoft.com/.../connector-dynamics-crm-office-365

Please mark my answer verified if i were helpful

Was this reply helpful? Yes No
ZeeshanGhause on at

Like (0)

Report

Thanks Bipin Kumar

Do you think we can do this via Azure data factory.

your shared URL refer to same type of source and Destination CRM not from/to MYSQL.

However I tried and find data type clash while transferring data from mysql to d365 via Azure Data factory it says int 32 and int 64 not matched

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (1)

Report

Hi,

You will have to add some sort of transformation logic in your Azure data factory pipeling to make it compatible with Dynamics.

Please mark my answer verified if i were helpful

Was this reply helpful? Yes No
ZeeshanGhause on at

Like (0)

Report

Thanks @Bipin Kumar

Could you please help me out how i can do that? how i can perform data type transformation in ADF?

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (1)

Report

Hi,

check below link.

docs.microsoft.com/.../copy-activity-schema-and-type-mapping

Please mark my answer verified if i were helpful

Was this reply helpful? Yes No
ZeeshanGhause on at

Like (0)

Report

Thanks @Bipin Kumar

Could you please help me more how i can schedule this for real time as well as for future prospective?

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (1)

Report

Hi,

Check below article to schedule your Azure Data Factory pipeline.

docs.microsoft.com/.../how-to-create-schedule-trigger

Please mark my answer verified if i were helpful

Was this reply helpful? Yes No