Enterprise Data Catalog Scanner Configuration Guide > Configuring Application Resources > SAP R/3

SAP R/3

You must complete the prerequisites listed before configuring the properties for an SAP R/3 resource.

Objects Extracted

The SAP R/3 resource extracts metadata from the following assets in a SAP R/3 data source:

•Application components
•Packages
•Tables
•Columns
•Primary and foreign keys

Permissions to Configure the Resource

To configure SAP R/3, complete the following tasks:

1. Install Scanner transports.
2. Configure a user-authorization profile.
3. Install SAP SDK libraries.

Installing Scanner Transports

You must install the following Scanner transports that Enterprise Data Catalog uses to extract metadata from SAP R/3:

•ZINFABC_RUN
•TBL_READ_RUN
•TRANS_VER_RUN
•TBL_READ_RUN_CMP
•TBL_DESIGN_PROGINFO
•TBL_DESIGN
•TBL_READ_RUN_V2

The transports are located in the following folder in the location where you downloaded PowerCenter: <download location>\saptrans\mySAP.

For more information about installing the transports, see the PowerExchange for SAP NetWeaver Transport Versions Installation Notice .

Configuring a User-authorization Profile

The SAP R/3 administrator needs to create the product and development user authorization profile. The following table describes the user authorization profile:

Authorization Object	Description	Class	Field Values
S_RFC	Authorization check for RFC access.	Cross Application Authorization objects	Activity: 16 (Execute) Name of RFC to be protected: *. Type of RFC object to be protected: FUGR

Prerequisites

1. Create an Event Details Record (EDR) connection for SAP R/3 using Informatica Administrator. For more information about creating connections, see the Informatica Administrator Guide.
2. Disable the Catalog Service.
3. Remove all the resource binary files in HDFS from the /Informatica/LDM/<service cluster name>/scanner/* directory. You can use the command hdfs dfs -rm -R /Informatica/LDM/<service cluster name>/scanner/* to remove all the resource binary files.
4. Download the sapjco3.jar file and copy the file to the following location: <Install_directory>/services/CatalogService/access/WEB-INF/lib.
5. If you want to enable profiling, copy the following files to the locations listed:

- For Windows, copy the sapjco3.jar file to the following location:<Install_directory>/services/shared/jars/thirdparty.
- For Linux, copy the libsapjco3.so file to the following location: <Install_directory>/server/bin.

6. For Linux, download the libsapjco3.so file and copy the file to the following location: <Install_directory>/services/shared/bin.
7. For Windows, download the sapjco3.dll file and copy the file to the following location: <Install_directory>/services/shared/bin directory.
8. Download the JDBC driver for SAP R/3 from the SAP web site and copy the driver to the following directory: <Install_directory>/services/CatalogService/ScannerBinaries.
9. Include the libsapjco3.so and sapjco3.jar files in the SAPJCO.zip file and copy the SAPJCO.zip file to the following location: <Install_directory>/services/CatalogService/ScannerBinaries.
10. Enable the Catalog Service.
11. Restart the Informatica domain.

Resource Connection Properties

The General tab includes the following properties:

Property	Description
Username	The user name to access SAP R/3 system.
Password	The password associated with the user name.
Application server host	Host name or IP address of the system that hosts SAP R/3.
System number	System number of the SAP R/3 system to which you want to connect.
Client	The SAP R/3 client to access data from the SAP R/3 system.
Language	Specify the language to be used while importing metadata using the resource.
Enable Streaming for Data Access	Choose this option to extract data by using the HTTP protocol. If you do not choose this option, the scanner extracts the SAP data to a staging file.
Encoding	Default is UTF-8 character encoding for metadata imported from the resource. You cannot change the default setting for this property.

The following table describes the properties that you can configure in the Source Metadata section of the Metadata Load Settings tab:

Property	Description
Enable Source Metadata	Extracts metadata from the data source.
Repository Objects	Imports the repository objects such as resources, information, and activities from the SAP R/3 system.
Memory	Specifies the memory required to run the scanner job. Select one of the following values based on the data set size imported: - Low - Medium - High Note: For more information about the memory values, see the Tuning Enterprise Data Catalog Performance article on How To-Library Articles tab in the Informatica Doc Portal
JVM Options	JVM parameters that you can set to configure scanner container. Use the following arguments to configure the parameters: - -Dscannerloglevel=<DEBUG/INFO/ERROR>. Changes the log level of scanner to values, such as DEBUG, ERROR, or INFO. Default value is INFO. - -Dscanner.container.core=<No. of core>. Increases the core for the scanner container. The value should be a number. - -Dscanner.yarn.app.environment=<key=value>. Key pair value that you need to set in the Yarn environment. Use a comma to separate the key pair value. - -Dscanner.pmem.enabled.container.memory.jvm.memory.ratio=<1.0/2.0>. Increases the scanner container memory when pmem is enabled. Default value is 1.

You can enable data discovery for an SAP R/3 resource. For more information about enabling data discovery, see the Enable Data Discovery topic.

You can enable composite data domain discovery for an SAP R/3 resource. For more information about enabling composite data discovery, see the Composite Data Domain Discovery topic.