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
mainframe flat file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
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.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.