topic FTP to VAX (OpenVMS) OS in Talend Studio

FTP to VAX (OpenVMS) OS

mgsteiner — Sat, 16 Nov 2024 08:02:07 GMT

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

Thanks a lot in advance

Re: FTP to VAX (OpenVMS) OS

fdenis — Wed, 27 Jun 2018 16:52:53 GMT

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

Re: FTP to VAX (OpenVMS) OS

mgsteiner — Thu, 28 Jun 2018 05:36:14 GMT

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

Have you perhaps used those with VAX?

Re: FTP to VAX (OpenVMS) OS

fdenis — Thu, 28 Jun 2018 08:24:28 GMT

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?

Re: FTP to VAX (OpenVMS) OS

mgsteiner — Thu, 28 Jun 2018 09:24:06 GMT

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?

FTP2VAX.JPG

Re: FTP to VAX (OpenVMS) OS

fdenis — Thu, 28 Jun 2018 09:42:42 GMT

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?

Re: FTP to VAX (OpenVMS) OS

mgsteiner — Thu, 28 Jun 2018 13:26:42 GMT

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'

Re: FTP to VAX (OpenVMS) OS

mgsteiner — Mon, 02 Jul 2018 12:01:17 GMT

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