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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Contributor
Contributor

FTPS Talend connection problem (with existing certificate and keystore to be created)

Hello everybody ,

I'm trying to connect to an FTP with FTPS protocol (Require explicit FTP over TLS).

From filezilla I see that there is a chain of certificates below represented

0693p000009pzhRAAQ.png

0693p000009pziiAAA.png

If I open the trustedcerts.xml (filezilla) I have (apparently) only one certificate saved:

<? xml version = "1.0" encoding = "UTF-8"?>

<FileZilla3 version = "3.50.0" platform = "windows">

<TrustedCerts>

<Certificate>

<Data> xxxxxxxxxxxxxxxxx </Data>

<ActivationTime> 1588118400 </ActivationTime>

<ExpirationTime> 1619740799 </ExpirationTime>

<Host> XXXXX.it </Host>

<Port> 21 </Port>

<TrustSANs> 0 </TrustSANs>

</Certificate>

</TrustedCerts>

</FileZilla3>

A keystore is required within Talend.

How can I transform /import the certificate into a keystore recognized by Talend?

0693p000009pzj2AAA.png

Labels (2)
3 Replies
Jesperrekuh
Specialist
Specialist

Port 21 ? sftP uses ssh and should run over 22.

FTP and Port 21 is unidirect, I believe just for commands.

 

Something to consider:

Ssh FTP gofor tSystem and curl or scp ... way better handling and storing cookies or verbose or errors.

https://curl.haxx.se/docs/manual.html

Anonymous
Contributor
Contributor
Author

The server uses port 21.

The protocol is ftpS (not sftp).

Also I need to understand how to set up Talend (since filezilla does not require a keystore).

Anonymous
Contributor
Contributor
Author

I am currently trying to implement a custom class (in java) to overcome the problem but I would like to understand if it is the only option or if there are other ways to overcome the problem.