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 ?

All responses (13)

Answers (0)

Elijah Stownton 192 on at

Like (0)

Report

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

As an alternative, you can use a 3rd party tool to connect SQL Azure and Dynamics 365. Try Skyvia - it is a no-code data integration product with a freemium model.
Community Member on at

Like (0)

Report

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

dbForge Studio for MySQL is a universal GUI tool for MySQL and MariaDB database development, management, and administration. The IDE allows you to create and execute queries, develop and debug stored routines, automate database object management, analyze table data via an intuitive interface.
ZeeshanGhause on at

Like (0)

Report

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

Thanks @Biping Kumar

what i have done so far i have introduced staging SQL DB in between D365 and MYSQL and have dumbed the data from mysql to sql and then D365 okay i can schedule it as well.

but there is one big limitation that is SQL/MYSQL can't be destination in ADF

now what i can do
Suggested answer

Bipin D365 28,981 Moderator on at

Like (1)

Report

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

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
ZeeshanGhause on at

Like (0)

Report

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

Thanks @Bipin Kumar

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

Bipin D365 28,981 Moderator on at

Like (1)

Report

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

Hi,

check below link.

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

Please mark my answer verified if i were helpful
ZeeshanGhause on at

Like (0)

Report

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

Thanks @Bipin Kumar

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

Bipin D365 28,981 Moderator on at

Like (1)

Report

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

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
ZeeshanGhause on at

Like (0)

Report

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

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
Suggested answer

Bipin D365 28,981 Moderator on at

Like (1)

Report

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

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