Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Table of Contents

Search

  1. Preface
  2. Connectors and Connections
  3. Data Ingestion and Replication connectors
  4. Data Ingestion and Replication connection properties

Connectors and Connections

Connectors and Connections

Hierarchical data extraction from SAP ODP objects

Hierarchical data extraction from SAP ODP objects

Before you use an SAP ODP Extractor connection to extract hierarchical data from SAP ODP objects in a Unicode SAP system, you need to install the SAP ODP Extractor transport files that you get from the Secure Agent directory to the SAP system.

Prerequisites to install the transport files

Before you install the SAP ODP Extractor transports, make sure to perform the following prerequisite tasks:
  • Ensure that the transport files you install on the SAP machines are the latest. Get the latest transport files from the following directory:
    <Informatica Secure Agent installation directory>\downloads\package-SAPODP.<Latest version>\package\sapodp\sap-transport
  • Verify that the transport files are applicable for SAP version ERP 6.0 EHP7 system or later.
  • Before you install the transports on your production system, install and test the transports in a development system.
The following table lists the transports that you need to install to read data from the SAP ODP objects:
Data and Cofile Names
Transport Request
Functionality
  • K900861.N75
  • R900861.N75
N75K900861
Install the transports only when you want to read from an SAP ODP that supports hierarchy.
If the SAP ODP objects that do not contain hierarchical data, you can use SAP ODP Extractor Connector without installing the SAP ODP Extractor transport files.

Installing transport files

To install the SAP ODP Extractor transport files, perform the following steps:
  1. Find the transport files in the following directory on the Secure Agent machine:
    <Informatica Secure Agent installation directory>\downloads\package-SAPODP.<Latest version>\package\sapodp\sap-transport
  2. Copy the cofile transport file to the
    Cofile
    directory in the SAP transport management directory on each SAP machine that you want to access.
    The cofile transport file uses the following naming convention:
    <number>.<sap system>
    .
  3. Copy the data transport file to the
    Data
    directory in the SAP transport management directory on each SAP machine that you want to access.
    The data transport file uses the following naming convention:
    <number>.<sap-system>
    .
  4. To import the transports to SAP, in the STMS, click
    Extras
    Other Requests
    Add
    and add the transport request to the system queue.
  5. In the
    Add Transport Request to Import Queue
    dialog box, enter the request number for the cofile transport.
    The request number inverts the order of the renamed cofile as follows:
    <sap-system><number>
    .
  6. In the Request area of the import queue, select the transport request number that you added, and click
    Import
    .
  7. If you want to upgrade from a previous version of the Informatica Transports, select the
    Overwrite Originals
    option.

0 COMMENTS

We’d like to hear from you!