Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2019-06-06 08:53 AM

Talend ftp connexion / Encryption

Bonjour, 

 

implementing a new step in my talend job sending file to a third party ftp server.

The third party is asking me to encrypt the transfer "Require implicit FTP over TLS".

how to specify it in a tFTPConnection and/or tFTPPut ?

 

thank you for your help.

Damien

Labels (2)
Labels
543 Views
0 Likes
7 Replies
TRF
Champion II
Champion II
‎2019-06-06 11:44 AM

Tick the option "Support SFTP" on tFTPConnection or tFTPPut components

543 Views
0 Likes
Anonymous
Not applicable
‎2019-06-06 11:54 AM
Author

Bonjour TRF, 

it's what I did ... see attached 

 

but I have reject : 

 

[2019-06-06 14:48] Upload file on Trax FTP :
Exception in component tFTPConnection_1
com.jcraft.jsch.JSchException: connection is closed by foreign host
at com.jcraft.jsch.Session.connect(Session.java:269)
at com.jcraft.jsch.Session.connect(Session.java:183)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.tFTPConnection_1Process(APM_TRAX_ExtractActualFlights_NewFTP.java:5626)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.tLoop_1Process(APM_TRAX_ExtractActualFlights_NewFTP.java:5421)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.tWarn_7Process(APM_TRAX_ExtractActualFlights_NewFTP.java:5248)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.tWarn_6Process(APM_TRAX_ExtractActualFlights_NewFTP.java:5128)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.tWarn_3Process(APM_TRAX_ExtractActualFlights_NewFTP.java:5017)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.tWarn_2Process(APM_TRAX_ExtractActualFlights_NewFTP.java:4896)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.tWarn_1Process(APM_TRAX_ExtractActualFlights_NewFTP.java:4771)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.runJobInTOS(APM_TRAX_ExtractActualFlights_NewFTP.java:6845)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.main(APM_TRAX_ExtractActualFlights_NewFTP.java:6586)
Exception in component tFTPPut_1
java.lang.NullPointerException
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.tFTPPut_1Process(APM_TRAX_ExtractActualFlights_NewFTP.java:5753)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.tFTPConnection_1_error(APM_TRAX_ExtractActualFlights_NewFTP.java:609)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP$TalendException.printStackTrace(APM_TRAX_ExtractActualFlights_NewFTP.java:376)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP$TalendException.printStackTrace(APM_TRAX_ExtractActualFlights_NewFTP.java:364)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP$TalendException.printStackTrace(APM_TRAX_ExtractActualFlights_NewFTP.java:364)
2019-06-06 14:48:13|tkRRd6|tkRRd6|tkRRd6|FLIGHTS|APM_TRAX_ExtractActualFlights_NewFTP|PROD|6|Java Exception|tFTPPut_1|java.lang.NullPointerException:null|1
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP$TalendException.printStackTrace(APM_TRAX_ExtractActualFlights_NewFTP.java:364)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP$TalendException.printStackTrace(APM_TRAX_ExtractActualFlights_NewFTP.java:364)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP$TalendException.printStackTrace(APM_TRAX_ExtractActualFlights_NewFTP.java:364)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP$TalendException.printStackTrace(APM_TRAX_ExtractActualFlights_NewFTP.java:364)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.runJobInTOS(APM_TRAX_ExtractActualFlights_NewFTP.java:6852)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.main(APM_TRAX_ExtractActualFlights_NewFTP.java:6586)
2019-06-06 14:48:14|tkRRd6|tkRRd6|tkRRd6|FLIGHTS|APM_TRAX_ExtractActualFlights_NewFTP|PROD|6|Java Exception|tFTPConnection_1|com.jcraft.jsch.JSchException:connection is closed by foreign host|1
[statistics] disconnected
Job APM_TRAX_ExtractActualFlights_NewFTP ended at 14:48 06/06/2019. [exit code=1]


Capture tftp1.PNG
543 Views
0 Likes
TRF
Champion II
Champion II
‎2019-06-06 12:25 PM

Are you able to use a tool such as Filezilla to transfer your file via stfp?

This is to validate there is not a connection error due your server configuration or something like that.

543 Views
0 Likes
Anonymous
Not applicable
‎2019-06-06 12:43 PM
Author

Yes, it works correctly.

 

Status: Connection established, initializing TLS...
Status: Verifying certificate...
Status: TLS connection established, waiting for welcome message...
Status: Logged in
Status: Retrieving directory listing...
Status: Directory listing of "/" successful

543 Views
0 Likes
Anonymous
Not applicable
‎2019-06-11 06:47 AM
Author

So it works correctly with Filezilla, not with Talend Studio 5.6 (yes I know, I am aware that is an old version ... but we plan to migrate with the support of Talend after summer).

 

Any idea in the settings I should have in my tFTPConnexion or tFTPput ?

 

See attached filezilla inputs


filezilla ok.PNG
543 Views
0 Likes
Anonymous
Not applicable
‎2019-06-14 04:13 PM
Author

Starting job TestNewFTP at 19:07 14/06/2019.

[statistics] connecting to socket on port 3570
[statistics] connected
[2019-06-14 19:07] Check context before upload : PROD
java.io.FileNotFoundException:
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at java.io.FileInputStream.<init>(Unknown Source)
at flights.testnewftp_0_5.TestNewFTP$1MyTrust_tFTPConnection_1.getTrustManagers(TestNewFTP.java:4502)
at flights.testnewftp_0_5.TestNewFTP$1MyTrust_tFTPConnection_1.access$0(TestNewFTP.java:4490)
at flights.testnewftp_0_5.TestNewFTP.tFTPConnection_1Process(TestNewFTP.java:4521)
at flights.testnewftp_0_5.TestNewFTP.tWarn_6Process(TestNewFTP.java:4400)
at flights.testnewftp_0_5.TestNewFTP.runJobInTOS(TestNewFTP.java:5311)
at flights.testnewftp_0_5.TestNewFTP.main(TestNewFTP.java:5052)
Exception in component tFTPPut_1
java.lang.NullPointerException
at flights.testnewftp_0_5.TestNewFTP.tFTPPut_1Process(TestNewFTP.java:4774)
at flights.testnewftp_0_5.TestNewFTP.tWarn_1Process(TestNewFTP.java:4687)
at flights.testnewftp_0_5.TestNewFTP.tWarn_6Process(TestNewFTP.java:4418)
at flights.testnewftp_0_5.TestNewFTP.runJobInTOS(TestNewFTP.java:5311)
[2019-06-14 19:07] Etape 2:
2019-06-14 19:07:04|KZeb7v|KZeb7v|KZeb7v|FLIGHTS|TestNewFTP|PROD|6|Java Exception|tFTPPut_1|java.lang.NullPointerException:null|1
at flights.testnewftp_0_5.TestNewFTP.main(TestNewFTP.java:5052)
[statistics] disconnected
Job TestNewFTP ended at 19:07 14/06/2019. [exit code=1]

543 Views
0 Likes
Anonymous
Not applicable
‎2019-06-21 12:42 PM
Author

it seems that we need to use a SSL certificate to produce the requested information ...

 

https://community.talend.com/t5/Design-and-Development/tFTPPut-using-FTPS-Support-for-TLS-SSL-Implic...

 

not easy ...

543 Views
0 Likes