I am using Talend to fetch a data file from our IBM mainframe. I installed the FTP JAR and it allows me to make an FTP connection. I can log in and get a directory of what is in the mainframe using the get file list component. However, I do not seem to be able to get an individual file using tFTPGet.
How are the pathnames in the mainframe specified in Talend tFTPGet? I used FileZilla FTP Client to get into the mainframe see the file and the file is there, so it's not permissions related. I wonder if I specified the remote path and file mask correctly. I used:
Remote Path: "XXXX.YYYY.ZZZZ"
The path on the mainframe is XXXX.YYYY.ZZZZ.MYFILE
Do I need to specify the ending . in the remote path? that's the only thing I am thinking, perhaps Z/OS is not as forgiving? I know that on Z/OS there are no 'folders' or 'directories' the way we have them on Unix or Windows. What is the trick for specifying the remote path and name?
It is the latest 7.01 free version (we're evaluating)
The plot thickens. If I specify files in my 'home directory' or what passes as such on Z/OS the files can be retrieved with tFTPGet with no problem. So if I have my user ID called ZUSERID and three files of type .CSV under my home directory, tFTPGet works perfectly.
I specify "ZUSERID." as the remote path and "*.CSV" as the file mask and all 3 files arrive as expected.
But, when I try this in another 'home directory' for which I have access, it does not work.
i.e. if I specify "ZANOTHERID.SUBDIR" as the remote directory and "XXXXX.YYYY.FILENAME" as the file name it does not work.
The issue is that it seems to work if the file is in the top level directory immediately following the first dot. But a file deeper in the file system i.e. ZANOTHERID.SUBDIR.XXXXXX.YYYYY.FILENAME will not work (note ZANOTHERID is the root directory, SUBDIR is the subdirectory, and XXXX.YYYY.FILENAME is the filename.
Using Filezilla I was able to find out which part is the 'directory' and which is the file name. I specified it correctly, no success either. It seems to work only if the file is at the top level directory. It's not a permissions problem either, I have access. If the file is in root folder it works.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema