Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team ,
we are unable to access the data which is available in the SQL Server (On-Prem), Are there any Integration RunTime Limitations on this One ?
@chandukasani
Do you have a SHIR in use? I hope so, you (will) need one.
Hope communication (firewall rules established?) between SQL Server host to SHIR host is available.
In my experience so far (for enabling connection to on-prem SQL DB) you have to share your SHIR with your ADF, after that you are able zo connect to on-prem SQL Server.
Please check firewall rules and sharing SHIR with your ADF.
Hi @sergej_og Are you suggesting for the fabric pipelines or with adf pipelines ,just to get clarity because in fabric it will managed in the backend right
Hi @chandukasani,
in this specific case I meant an ADF pipeline (beacuse fabric components are still in preview).
I assume that fabric pipelines have same functionality like ADF pipelines.
Not sure what you mean by "in fabric it will manged in the backend".
This is not there yet. Can you vote this Fabirc idea Support for on-prem connectivity within Pipelines in Fabric?