Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
dhorrall
Helper I
Helper I

Can I use legacy 'DataFactory' to write/update Fabric Synapse data?

We use legacy DataFactory.  Can I use this environment to 'write' to  Synapse Warehouse in Fabric, or do I have to use the 'DataFactory' components within Fabric?

1 ACCEPTED SOLUTION
HimanshuS-msft
Microsoft Employee
Microsoft Employee

Hello @dhorrall 
Considering the azure-datafactory we will have to create a linked service and to create a linked service we will need authentication type . As rightly called out by @bcdobbs we do have the endpoint exposed but I am not sure if we can set the authentication type . So to me it looks like this is not possible.
But to be sure I am reaching out to the internal type to have more clarification on this . 
Thanks
Himanshu 



 

View solution in original post

3 REPLIES 3
HimanshuS-msft
Microsoft Employee
Microsoft Employee

Hello @dhorrall 
Considering the azure-datafactory we will have to create a linked service and to create a linked service we will need authentication type . As rightly called out by @bcdobbs we do have the endpoint exposed but I am not sure if we can set the authentication type . So to me it looks like this is not possible.
But to be sure I am reaching out to the internal type to have more clarification on this . 
Thanks
Himanshu 



 

I've done some testing and agreed I can't make it authenticate.

 

I was hopeful I could give a service princpal workspace access and then use that to authenticate but it doesn't like that either! If I pursuade it I will update.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
bcdobbs
Community Champion
Community Champion

I think you should be able to but haven't tried yet. The warehouse artefact exposes a sql endpoint which can be used outside of Fabric. I suspect you just set that up as a linked service in ADF.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors