X hits on this document

356 views

0 shares

1 downloads

0 comments

113 / 131

T h i s c o n f i g u r a t i o n i s u s e d , w h e n F T P _ T R A N S F E R _ M E T H O D = N O N E . I n t h i s c o n f i g u r a t i o n t h e d a t movements described will be performed: a

  • 1.

    The ABAP program extracts the data and pushes the data file to the FTP server defined by the FTP data server. The file is stored in the directory given by the FTP server's data schema.

  • 2.

    SQLLDR locates the data file using the work schema of the FTP server and uploads the data into Oracle DB.

This configuration requires the following Topology settings in ODI:

  • 1.

    Create a File data server pointing to the FTP server/ ODI Agent box: Host (Data Server): FTP server/ ODI Agent IP host name or IP address. This Hostname / IP address must be accessible from SAP system. User: Username to log into FTP server. Password: Password for the user.

  • 2.

    In this File data server create a Physical Schema representing the folder in the FTP host where the extraction file will be pushed. Specify the Data and Work Schemas as follows: Data Schema: Path on the FTP server for SAP extraction files. This path is used when uploading extraction files from the SAP system into the FTP server. Note that this path must use slashes and must end with a slash character. Work Schema: Local path on the FTP server’s machine. This path is used by the agent/SQLLDR installed on this machine to access the extraction files. As Work Schema is an OS file name, slashes/ backslashes should be used according to OS. Path names need to end on slash/ backslash.

The path names given on Data and Work schemas are usually not the same: the FTP service may provide access to a FTP directory named /sapfiles while the files can be stored locally in c:\inetpub\ftproot\sapfiles. .

Configuration 2: FTP Server is not installed on ODI Agent machine

T h i s c o n f i g u r a t i o n i s u s e d , w h e n F T P _ T R A N S F E R _ M E T H O D < > N O N E . I n t h i s c o n f i g u r a t i o n t h e d a t movements described will be performed: a

1.

The ABAP program extracts the data and pushes the data file to the FTP server defined by the FTP data server. The file is stored in the directory given by the FTP server's data schema.

  • 2.

    The ODI agent downloads the file into the directory given by KM Option TEMP_DIR.

  • 3.

    SQLLDR loads this file up into Oracle DB

This configuration requires the following Topology settings in ODI:

Knowledge Modules Reference Guide

113/131

Document info
Document views356
Page views359
Page last viewedMon Dec 05 14:02:35 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments