Data Factory
Needs VotesData Factory - Enhancement to FTP Connector to allow FTPES Protocol
Nicolas Worth on 11 Jun 2024 15:10:42
Hi,
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 (Using Host Key Finger-print). Here is where I am having a problem, it appears that the connector in Fabric does not support the explicit over TLS. The options you have for the FTP connection are very basic its just the host, port and authentication method (basic or anoynmous). I have tried to specify the FTP explicit protocol as part of the hostname "ftpes://" but when I try and use this I get the following error when trying to retrieve the file list "Access 'ftpes://' is not allowed on Azure integrate runtime.".
Can you enhance this connector in Fabric to support FTPES protocol. Currently to work around this issue we are having to use Azure Data Factory as this supports FTP Secure Transmission with SSL to then push this data into ADLS gen2 Fabric Warehouse.
Thanks
Administrator on 27 Nov 2024 08:41:52
have you tried with SFTP connector in Fabric?