topic Re: Reading and Writing data from Synapse to Fabric Warehouse in Data Engineering

Reading and Writing data from Synapse to Fabric Warehouse

Amit0167 — Fri, 12 Apr 2024 10:02:07 GMT

Hi,

I have an existing pipeline in ADF that populated my Raw layer data in ADLS2 and then SilverLayer Data in Synapse Dedicated Pool. I want to create a new task in same pipeline to populate a table in Fabric Warehouse.

I have created a Service Principle for Fabric and i tried creating a liniked service in ADF but i am getting an error

Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'xxxxxxxxxxxxxxxxxxxxx-xxxxxxxxxxxxxxxxxxxxx.datawarehouse.fabric.microsoft.com', Database: 'xxxxxxxxxxxxxxxxxxxxx', User: ''. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.
Login failed due to invalid authentication methods., SqlErrorNumber=18456,Class=14,State=1,

I tried this link but for the inbound Network Security, i am lost somewhere Set up and use private links for secure access to Fabric (Preview) - Microsoft Fabric | Microsoft Learn

any help is appreciated.

Re: Reading and Writing data from Synapse to Fabric Warehouse

v-cboorla-msft — Fri, 12 Apr 2024 14:37:11 GMT

Hi @Amit0167

Thanks for using Microsoft Fabric Community.

Apologies for the inconvenience.

It would be helpful if you could you please share screenshots of any error messages you've encountered, along with your current pipeline configuration. This additional information will help me to understand and guide you in better way.

Thank you.

Re: Reading and Writing data from Synapse to Fabric Warehouse

AmitGarg — Tue, 16 Apr 2024 14:05:41 GMT

Please find the image...

Re: Reading and Writing data from Synapse to Fabric Warehouse

AmitGarg — Thu, 18 Apr 2024 07:59:17 GMT

I have got the solution to my porblem now....

Re: Reading and Writing data from Synapse to Fabric Warehouse

v-cboorla-msft — Thu, 18 Apr 2024 08:16:47 GMT

Hi @AmitGarg

Glad that you were able to find some insights and appreciate if you could share the same with the community as it can be helpful to others.
Please continue using Fabric Community for further queries.

Thanks.