Ftp Process for Download file from SAP server to ETL server<br/>
FTP is an acronym for File Transfer Protocol. It represents a widely-used, but non-secure, method for transferring files between two computers. In our Scenario target is SAP Server and source is ETL Server. When you retrieve a file from the target server, you are performing a "get" operation. This is also known as "downloading".<br/>
Operating System AIX, Solaris <br/>
Interface fibre <br/>
Fabric Operating System 4.1 <br/>
Other Currently we are running in our production server through cron job at 9PM on sundays <br/>
NOTES (INCLUDING LIMITATIONS) <br/>
Tested in our production server (AIX, Solaris, Linux).<br/>
In SAP Server(Target Server) every week we scheduled jobs on Sundays between 6:00 PM to 9:00 PM through ABAP/4 programs for downloading files from SAP tables and save into text format by pipe separator between columns with filenames as _.txt. And it is kept in this path /ora/WE/focus. And also it creates a file named filepaths_.txt it contains the list of files which downloaded. <br/>
ETL Server:- <br/>
In ETL server(Source Server) every week we scheduled jobs on Sundays at 9:00 PM through shell script. This script will transfer all files from SAP server to ETL Server according to the input date which is passing. This are the input parameters hard corded in the script:- HOSTNAME=prism123.yyy.com (Server Name of source server - ETL server) <br/>
DATE=`date +%d%m%y` (Todays date in DDMMYY) <br/>
DT=`date +20%y%m%d` (Todays date in YYYYMMDD) <br/>
DOMAIN=/dsdata/Source (source Server path) <br/>
TARGET=/ora/WE/focus (target Server path) <br/>
host=10.100.44.44 (IP Address of target Server - SAP server) <br/>
Input file:- controlfile.txt - contains the list of files which has to be transfer from SAP to ETL. Concerned developer has to update this file if new source file needs.<br/>
filepath_.txt - creates in SAP server and ftp to ETL Server.<br/> <br/> transfered_files_.txt - creates in ETL server once files transferred.
And finally this script compares controlfile.txt and transferfile.txt, if it does not matches it will send email as 'failed' else it'll send 'success'.
NOTE: This contribution was migrated by Brocade from the former Brocade Connect community on January 23, 2008, on behalf of the author.