topic Re: Copy data from MySQL in Pipelines

Copy data from MySQL

Kletzy — Fri, 11 Aug 2023 13:12:41 GMT

I am trying to use Copy data in a pipeline in Fabric to copy data from a MySQL DB hosted in Azure into my Lakehouse but cant find any connector option available for MySQL.

Please could you advise.

Re: Copy data from MySQL

DennesTorres — Fri, 11 Aug 2023 20:53:57 GMT

Hi,

Yes, pipelines don't have a connector to mySQL yet, but dataflows Gen 2 have

Kind Regards,

Dennes

Re: Copy data from MySQL

GraceGu — Mon, 14 Aug 2023 03:37:02 GMT

My SQL connector is not supported by data pipeline yet.

FYI.

Connector overview - Microsoft Fabric | Microsoft Learn for connectors supported by data pipeline today.

Vote on Fabric Idea: Expand connector selection for Data Factory Copy Activity for priority of the ask, and comment on specfiic connectors you are looking for.

Re: Copy data from MySQL

Kletzy — Wed, 16 Aug 2023 14:20:45 GMT

Is there no workaround at the moment? Documentation seems to indicate there may be a way.

Re: Copy data from MySQL

DennesTorres — Wed, 16 Aug 2023 14:30:47 GMT

Hi,

Besides using a dataflow and calling the dataflow from the pipeline?

I don't think so, I believe this is the only option. Why would the dataflow be a problem?

Kind Regards,

Dennes