Forum Discussion
Copy Data from SQL Server only available with Basic authentication
If I try to do a Copy Task from SQL server (via on prem data gateway) in a Pipeline, I only have the option of basic authentication. All our SQL Servers use Windows authentication. Why would this not be available as an authentication option?
Thanks Vitaly, that's what I thought - but the OP seemed to suggest otherwise. Appreciate the clarification.
One bit of feedback on the documentation you linked - it's completely written from a "the user knows Azure Data Factory" standpoint. If one of the goals of Fabric is to introduce it to people that haven't used ADF yet (like me), it's very difficult to understand that Self-hosted integration runtimes is still in progress of design means "you can't do a copy activity between on-prem and Fabric". IMO it would be a good idea to go back through that document and rewrite from a "person doesn't know Azure Data Factory, but still needs to know this functionality doesn't work" standpoint
Thanks!
Scott
7 Replies
swaruss - is there anything you can do to post a screenshot of how you added a Copy Task using an on-prem gateway? I've been trying to do this (for weeks now), but I'm completely unable to get my gateways to show up.
Here's a screenshot of what I see. I'm choosing "external" - but then it asks for a connection. This dialog never shows all of our existing gateway connections. It takes me to a screen where I have to build a new connection - and these don't appear to be using a gateway, they seem to be trying to connect directly to the database (which is impossible because our databases aren't open to the world).
Any advice would be greatly appreciated, I'd LOVE to use the copy data task with a gateway server, but no clue on how to get this working.
Thanks in advance!
Scott
Scott_PowellThe scenario you are describing is unsupported in Fabric. The Self-hosted IR / Data Gateway that's needed for Fabric pipelines to connect to on-prem data sources is not available in yet.
Please reference the official confirmation at Differences between Data Factory in Fabric and Azure - Microsoft Fabric | Microsoft Learn
Thanks Vitaly, that's what I thought - but the OP seemed to suggest otherwise. Appreciate the clarification.
One bit of feedback on the documentation you linked - it's completely written from a "the user knows Azure Data Factory" standpoint. If one of the goals of Fabric is to introduce it to people that haven't used ADF yet (like me), it's very difficult to understand that Self-hosted integration runtimes is still in progress of design means "you can't do a copy activity between on-prem and Fabric". IMO it would be a good idea to go back through that document and rewrite from a "person doesn't know Azure Data Factory, but still needs to know this functionality doesn't work" standpoint
Thanks!
Scott
