To read data from SAP tables from a Unicode SAP system, install the SAP Table Reader transport files from the Secure Agent directory to the SAP system. The transport files are applicable for SAP version ECC 6.0 or later.

Before you install the SAP Table Reader 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-SAPConnector.<Latest version>\package\rdtm\sap-transport\SAPTableReader
Verify that the RSODPABAPCDSVIEW table is available in SAP before you install the TABLE_READER_Addon transport files. If the RSODPABAPCDSVIEW table is not available, the TABLE_READER_Addon transport installation fails.
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 based on the SAP source type that you want to access:

Data and Cofile Names	Transport Request	Functionality
TABLE_READER_R900176.ER6 TABLE_READER_K900176.ER6	ER6K900176	To read data from SAP transparent tables, cluster tables, and pool tables, install only the TABLE_READER transport.
TABLE_READER_Addon_R900085.S4N TABLE_READER_Addon_K900085.S4N	S4NK900085	To read data from ABAP CDS views, install both the TABLE_READER and TABLE_READER_Addon transports. Use the TABLE_READER_Addon transports for SAP NetWeaver 7.50 SP4 version and later. Whenever you install the TABLE_READER transport, you need to reinstall the TABLE_READER_Addon transport even though there is no change in the TABLE_READER_Addon transport version. Ensure that you first install the TABLE_READER transport and only then install the TABLE_READER_Addon transport.

To install the SAP Table Reader transport files, perform the following steps:

Find the transport files in the following directory on the Secure Agent machine:
<Informatica Secure Agent installation directory>\downloads\package-SAPConnector.<Latest version>\package\rdtm\sap-transport\SAPTableReader
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:
TABLE_READER_K<number>.ER6
.
Remove "TABLE_READER_" from the file name to rename the cofile.
For example, for a cofile transport file named
TABLE_READER_K900176.ER6
, rename the file to
K900176.ER6
.
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:
TABLE_READER_R<number>.ER6
.
Remove "TABLE_READER_" from the file name to rename the file.
To import the transports to SAP, in the STMS, click
Extras
Other Requests
Add
and add the transport request to the system queue.
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: ER6K<number>.
For example, for a cofile transport file renamed as
K900176.ER6
, enter the request number as ER6K900176.
In the Request area of the import queue, select the transport request number that you added, and click
Import
.
If you want to upgrade from a previous version of the Informatica Transports, select the
Overwrite Originals
option.