[resolved] tFtp tools

Highlighted
One Star
One Star

[resolved] tFtp tools

Hi,
I was wondering whether it is possible with Talend to read (not copy or get) files via an SFTP server.
I would like to briefly use tools such as tFileCompare, tWaitForFile, tFileInputExcel in a SFTP server.
Best regards
G47

Accepted Solutions
Highlighted
One Star
One Star

Re: [resolved] tFtp tools

Hi G47,
It seems your post is fixed. Could you please share your solution with us.
Best regards
Sabrina

Ok,
I just delete the tFTPFileList and it was ok
Best regards
G47

View solution in original post


All Replies
Highlighted
Four Stars

Re: [resolved] tFtp tools

Hi G47,
What is the actual business use case? SFTP/FTP is a file storage location. If you want to read, you need a client which is on your location machine... to read a file you need to either download a file or provide fto location ... In both the cases, you client tool which is used for reading the file is going to download the file at local disk in order to render the contents...
As an answer to your question.. in my opinion NO.
Vaibhav
Highlighted
One Star
One Star

Re: [resolved] tFtp tools

Hi G47,
What is the actual business use case? SFTP/FTP is a file storage location. If you want to read, you need a client which is on your location machine... to read a file you need to either download a file or provide fto location ... In both the cases, you client tool which is used for reading the file is going to download the file at local disk in order to render the contents...
As an answer to your question.. in my opinion NO.
Vaibhav

So if i want to read Files content via an SFTP server, first i need to copy the files in the same place (server) where my application is?
Best regards
G47
Highlighted
Four Stars

Re: [resolved] tFtp tools

Can you try
tFileInputDelimited --> Tlogrow
Create metadata of your target file and in place of location, give ftp path... Before this step, you will have to perform Authentication using tJava with ftp server..
Thanks
Vaibhav
Highlighted
One Star
One Star

Re: [resolved] tFtp tools

Can you try
tFileInputDelimited --> Tlogrow
Create metadata of your target file and in place of location, give ftp path... Before this step, you will have to perform Authentication using tJava with ftp server..
Thanks
Vaibhav

Thank you,
When i give ftp path i have this message: "you can not open this file with this program, try another location"
Best regards,
G47
Highlighted
Moderator

Re: [resolved] tFtp tools

Hi,

So far, there is no support for handling data by air. You have to get your files stored in ftp into local disk first then reading them.
The workflow should be:tFtpConnection-->tFtpget-->tfileinputdelimited-->tlogrow.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
One Star
One Star

Re: [resolved] tFtp tools

Hi,

So far, there is no support for handling data by air. You have to get your files stored in ftp into local disk first then reading them.
The workflow should be:tFtpConnection-->tFtpget-->tfileinputdelimited-->tlogrow.
Best regards
Sabrina

Thank you,
So I try this workflow (in the talend help center) but i have error.
So i use onSubjobOk to join tFTPFileList_1---------->tFTPGet_1 and the error disappears.
But i must complete again Host Field, port Field, username and passeword Field.
My error:
Exception in thread "main" java.lang.Error: Problème de compilation non résolu :
Type imbriqué MyProgressMonitor en double
at parsing.attempwithserver_0_1.attempWithServer.tFTPFileList_1Process(attempWithServer.java:577)
at parsing.attempwithserver_0_1.attempWithServer.tFTPConnection_1Process(attempWithServer.java:395)
at parsing.attempwithserver_0_1.attempWithServer.runJobInTOS(attempWithServer.java:1024)
at parsing.attempwithserver_0_1.attempWithServer.main(attempWithServer.java:874)

Best regards,
G47
Highlighted
Moderator

Re: [resolved] tFtp tools

Hi,
But i must complete again Host Field, port Field, username and passeword Field.

What's your requirment? Mask Host info through context value?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star
One Star

Re: [resolved] tFtp tools

Hi,
But i must complete again Host Field, port Field, username and passeword Field.

What's your requirment? Mask Host info through context value?
Best regards
Sabrina

Thank you,
I don't want to fill those field again and again, but when i check "Use an existing connection" and choose the connection.
I have this error:
Exception in component tFTPGet_1
com.jcraft.jsch.JSchException: session is down
at com.jcraft.jsch.Session.openChannel(Session.java:734)
at parsing.attempwithserver_0_1.attempWithServer.tFTPGet_1Process(attempWithServer.java:717)
at parsing.attempwithserver_0_1.attempWithServer.tFTPFileList_1Process(attempWithServer.java:556)
at parsing.attempwithserver_0_1.attempWithServer.tFTPConnection_1Process(attempWithServer.java:406)
at parsing.attempwithserver_0_1.attempWithServer.runJobInTOS(attempWithServer.java:1013)
at parsing.attempwithserver_0_1.attempWithServer.main(attempWithServer.java:863)
I follow this tutorial: https://help.talend.com/pages/viewpage.action?pageId=8123154#Raa67462
Best regards,
G47
Highlighted
Moderator

Re: [resolved] tFtp tools

Hi,
Exception in component tFTPGet_1
com.jcraft.jsch.JSchException: session is down

Have you already checked your ftp server configuration, timeout for example? What's the build version you are using?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
One Star
One Star

Re: [resolved] tFtp tools

Hi,
Exception in component tFTPGet_1
com.jcraft.jsch.JSchException: session is down

Have you already checked your ftp server configuration, timeout for example? What's rhe build version you are using?
Best regards
Sabrina

Hi,
I do a simulation and i used SolarWinds SFTP/SCP server and winscp on my pc.
Here is my configuration
Best regards
G47
Highlighted
Moderator

Re: [resolved] tFtp tools

Hi G47,
It seems your post is fixed. Could you please share your solution with us.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
One Star
One Star

Re: [resolved] tFtp tools

Hi G47,
It seems your post is fixed. Could you please share your solution with us.
Best regards
Sabrina

Ok,
I just delete the tFTPFileList and it was ok
Best regards
G47

View solution in original post

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog