mainframe flat file

djoni · Post by **djoni** » Thu Oct 13, 2005 7:16 pm

My source is a flat file on mainframe, my target is Oracle on AIX where my EE server is.
Am I right that I can use the FTP plug-in?
Where must I install the plug-in?
What else do I need?
djoni

vmcburney · Post by **vmcburney** » Thu Oct 13, 2005 7:57 pm

You can use the FTP plugin, this lets you start processing rows of data as they arrive on your server. I prefer to use an FTP script and bring the file across as soon as it is ready, then process them on the DataStage server as per the processing batch schedule. This provides for a more secure FTP process and file archiving on the server. It also lets you compress and ftp the file in necessary.

djoni · Post by **djoni** » Fri Oct 14, 2005 7:23 am

Does this mean the FTP plug-in is not secure and does not have that compressing capability?
djoni

kcbland · Post by **kcbland** » Fri Oct 14, 2005 7:31 am

FTP plugin is using FTP, which is not SFTP. If you want high-performance data transfer across a network that is secure, then use a secure command line program with compression logic.

djoni · Post by **djoni** » Fri Oct 14, 2005 7:52 am

Where must I install the FTP plug-in?
On the source, target, EE server, FTP server platform, ... ?
djoni

ray.wurlod · Post by **ray.wurlod** » Fri Oct 14, 2005 8:03 am

Plug-in stages can only be installed on the DataStage server. You use the package installer (dspackinst script) to achieve this. If there is a custom GUI, then you install this on the DataStage client machine using a standard InstallShield setup.exe program.