Copy Job (preview) On-Premise to Fabric DW

[cesarsan7]

Hi Guys,

I'm trying to use the new Copy Job (preview) in Data Factory for Microsoft Fabric, but I have a question about that. Does Copy Job support SQL Server on-premise as the source and Fabric Data Warehouse as the destination? What are the steps to do that?

Thanks,

Cesar

 

[ToddChitt]

I know this is marked as SOLVED but I have an issue similar. 

I tried setting up a new Copy Job (preview) using an on-premise SQL Server as the source, and a new Fabric SQL Database as the sink. When I went to make the Source connection, it would NOT let me use the Personal Mode Gateway that I JUST set up. The list of gateways available showed "(none)". The SQL Server is loaded on my laptop, running SQL Developer 2019. 

Also, if I go into Manage Connections and Gateways, if I try to set up a NEW Conneciton, it does not let me use the gateway.

[Anonymous · Accepted solution]

Hi, @cesarsan7 

Copy job(preview) support On-premises SQL Server, for more details you can refer to the document below.

What is Copy job (preview) in Data Factory - Microsoft Fabric | Microsoft Learn
How to create a Copy job (preview) in Data Factory - Microsoft Fabric | Microsoft Learn

Create connection to On-premises SQL Server

Create a new or select an existing Warehouse.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[CalebCarter927]

 v-yaningy-msft I get the following message at the Review + Save stage for on-prem sql server incremental copy to fabric warehouse via on-premises data gateway.

Is there an ETA when this will be supported?

[Yacine911]

i get the same message