Forum Discussion

swaruss's avatar
swaruss
Frequent Visitor
3 years ago
Solved

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...
General Comment
Pipelines
  • ScottPowellECU's avatar
    ScottPowellECU
    3 years ago

    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

ScottPowellECU's avatar
ScottPowellECU
Advocate II
3 years ago

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

  • vitaly's avatar
    vitaly
    Advocate II
    3 years ago

    Yes, agreed. The Fabric documentation is currently rather sparse. I am just a customer like you ... hopefully someone from Microsoft's documentation team is listening 😀

    • weehyong's avatar
      weehyong
      Microsoft Employee
      3 years ago

      Thank you vitaly and ScottPowellECU  for the feedback.

      We are definitely listening.
      Will improve the docs, so it makes it easier for folks to get started.

  • swaruss's avatar
    swaruss
    Frequent Visitor
    3 years ago

    Thanks, yes I have never used ADF before and starting with Fabric was my way in, There are a lot of things which don't work for me in Fabric, but which for instance work in Power BI data flows, which is frustrating, because I expected a lot of things to be the same. Documentation from a perspective of someone new to Fabric and Azure would be massively more helpful.