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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Community Support
Community Support

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
Community Support
Community Support

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
Super User
Super User

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
FabricCarousel_June2024

Fabric Monthly Update - June 2024

Check out the June 2024 Fabric update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.