Forum Discussion

nicworth's avatar
nicworth
Regular Visitor
2 years ago
Solved

Connection to FTP Server using explicit FTP over TLS

Hi All, I am trying to setup a pipeline to ingest CSV files from a vendors FTP server, the current connection type they only allow is 'Explicit FTP over TLS' so it is a FTP connection and not SFTP (...
Pipelines
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi nicworth ,

    In that case, you can load data to ADLS Gen 2 or Blob Storage using ADF and later you can use Fabric Pipelines to pull the data from ADLS Gen2 to Lakehouse.

    However, your suggestion is definitely valuable! We use customer feedback like yours to prioritize future features. The more users who request the ability to customize backgrounds, the higher it moves on our list.

     

    Appreciate if you could share the feedback on our Microsoft Fabric Ideas. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

     

    I hope this information helps. If you have any further queries please do let us know.

  • nicworth's avatar
    nicworth
    Regular Visitor
    2 years ago

    Hi,

    It is not SFTP, it is an explicit TLS FTP protocol that is only supported by the vendor system. Protocol "ftpes://", as said this is achieveable in ADF but it appears the connector in Fabric Data Factory does not have the same features unfortunately.

     

    Thanks

    Nic

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi nicworth ,

      In that case, you can load data to ADLS Gen 2 or Blob Storage using ADF and later you can use Fabric Pipelines to pull the data from ADLS Gen2 to Lakehouse.

      However, your suggestion is definitely valuable! We use customer feedback like yours to prioritize future features. The more users who request the ability to customize backgrounds, the higher it moves on our list.

       

      Appreciate if you could share the feedback on our Microsoft Fabric Ideas. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

       

      I hope this information helps. If you have any further queries please do let us know.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi nicworth ,

        We haven’t heard from you on the last response and was just checking back to see if your query was answered.
        Otherwise, will respond back with the more details and we will try to help .

        Thanks

    • Kaviraj11's avatar
      Kaviraj11
      Solution Sage
      2 years ago

      I'm facing the same issue here. Let me know when you come across the solution. Would be much appreciated.