topic Re: Unable to access OnPrem Sql Server Through Pipeline in Pipelines

Unable to access OnPrem Sql Server Through Pipeline

chandukasani — Wed, 19 Jul 2023 09:59:18 GMT

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 ?

Re: Unable to access OnPrem Sql Server Through Pipeline

GraceGu — Thu, 20 Jul 2023 02:52:00 GMT

This is not there yet. Can you vote this Fabirc idea Support for on-prem connectivity within Pipelines in Fabric?

Re: Unable to access OnPrem Sql Server Through Pipeline

chandukasani — Thu, 20 Jul 2023 04:37:36 GMT

Hi , GraceGu Thanks For Reply ,Is there any ETA For That One ?

Re: Unable to access OnPrem Sql Server Through Pipeline

sergej_og — Thu, 20 Jul 2023 08:49:00 GMT

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.

Re: Unable to access OnPrem Sql Server Through Pipeline

chandukasani — Mon, 24 Jul 2023 11:10:10 GMT

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

Re: Unable to access OnPrem Sql Server Through Pipeline

sergej_og — Mon, 24 Jul 2023 12:29:36 GMT

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".

Re: Unable to access OnPrem Sql Server Through Pipeline

chandukasani — Tue, 25 Jul 2023 07:11:01 GMT

Yes sergej_og They will be managed in the backend