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.
Watch the recorded webinar!
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.
Practical steps to developing your data integration strategy.