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:

1Find 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

2Copy 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>.

3Copy 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>.

4To import the transports to SAP, in the STMS, click Extras > Other Requests > Add and add the transport request to the system queue.

5In 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>.

6In the Request area of the import queue, select the transport request number that you added, and click Import.

7If you want to upgrade from a previous version of the Informatica Transports, select the Overwrite Originals option.