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: 
mgsteiner
Contributor
Contributor

FTP to VAX (OpenVMS) OS

Hello all,

I have to connect from Talend using FTP to an OpenVMS server to do the following actions:

 

1.-  Put Files (which is already working)

2.- Getting the File Properties (name and size) from the file already transferred to the OpenVMS Server

3.- Rename that file

 

Could you provide me some hints regarding which Talend component I can use to do the tasks 2 and 3?.

Any help will be great 0683p000009MACn.png

Thanks a lot in advance

Labels (3)
7 Replies
fdenis
Master
Master

I guess you are looking for tFTPFileProperties and tFTPRename.
Regards,
mgsteiner
Contributor
Contributor
Author

Thanks for the reply.
Yes I have tried that but seems not to work for VAX OS.

Have you perhaps used those with VAX?

fdenis
Master
Master

I do not use vax but did you have any ftp tool manualy doing that?
or did you have ssh connection on your open vms?
mgsteiner
Contributor
Contributor
Author

No. I'm doing that manually, executing FTP to VAX, transferring the file and renaming it. 

But, I want to do it with Talend without implementing Java code.

 

Those components you mentioned I'm trying to use them but in the case of tFTPFileProperties, I'm getting 'null' values when I'm looking for any field (i.e.: size, basename, dir, etc).

I just dont know if I'm missing something in the configuration of the component or something.

Here is what I'm using to connect , execute an ftp put, get the file properties and show the output in console when running (see the picture attached). Also is included the properties of the tFTPFileProperties

 

Any idea? 0683p000009MACn.png


FTP2VAX.JPG
fdenis
Master
Master

it can be ftp version on open vms that why I ask about manual access.
what is file system on open vms? unix, windows, other
did you conect it using putty?
mgsteiner
Contributor
Contributor
Author

I have OpenVMS 7.3 and I can do FTP and Telnet sessions.

Now, due to naming convention problems I could make the tFTPRename component work . 

So, now I'm still missing to gather the file properties in VAX in order to calculate the sizes and check whether the input and target file sizes are ok.

I'm not able to get the values from tFTPFileProperties. All of them comes with 'null'

 

mgsteiner
Contributor
Contributor
Author

I'm working on it and I will post the workaround when I'm finish.

BR