Hello team!
I need to extract a Excel file from an SFTP server. I successfully created my SFTP datasource :
But I only see the ‘root’ folder on data selection section. When I click preview I can see all my files but I don’t know what to do to get them !
Could you help me on the next step ?
Thanks a lot!
Christine
Hi,
the way you work with CData connectors is a bit of a different mindset: choose the connector for the file/table/datastructure you want to extract and use the connection type for the interface. In your example, use one of the Excel connectors and use the connection settings for SFTP sources.
The SFTP connector allows you to see metadata of the SFTP server (and push and pull files if you are programming against it).
Hello!
Thanks for you help!, if I understand correctly, I should not use SFTP connector but cdata excel connector with connextion information I used in my SFTP setup ?
I will try it!
Br,
Christine
Hello! Just to let you know that I was able to extract the file with the cdata Excel and connection string from SFTP 
Have a good day!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.