X hits on this document

313 views

0 shares

1 downloads

0 comments

100 / 131

  • 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

This configuration is used, when FTP_TRANSFER_METHOD <> NONE. In this configuration the data movements described will be performed:

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:

  • 1.

    Create a File data server pointing to the FTP server into which the extraction file will be pushed from SAP and picked up from for SQL*Loader. Set the parameters for this data server as follows: Host (Data Server): FTP server IP host name or IP address. This hostname / IP address must be accessible both from SAP system and from ODI agent. 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 to upload or download extraction files from the remote location. This path is used when uploading extraction files from the SAP system into the FTP server. It is also used by the agent to download the extraction files. Note that this path must use slashes and must end with a slash character.

Knowledge Modules Reference Guide

100/131

Document info
Document views313
Page views316
Page last viewedFri Dec 02 22:44:42 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments