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:

Permissions to Configure the Resource

To configure SAP R/3, complete the following tasks:
  1. 1. Install Scanner transports.
    2. For information about installing the transports that Enterprise Data Catalog uses, see "Informatica Developer Transports" in the PowerExchange for SAP NetWeaver Transport Versions Installation Notice.
  2. 2. Configure a user-authorization profile using the following values:
    3. 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
    The SAP R/3 administrator needs to create the product and development user authorization profile. For more information about user authorization profile, see Create Profiles in the PowerExchange for SAP NetWeaver User Guide.
  3. 3. Install SAP SDK libraries.

Prerequisites

  1. 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. 2. Disable the Catalog Service.
  3. 3. Download the sapjco3.jar file and copy the file to the following location: <Informatica installation directory>/services/CatalogService/access/WEB-INF/lib.
  4. 4. If you want to enable profiling, copy the sapjco3.jar file to the following location: <Informatica installation directory>/services/shared/jars/thirdparty.
  5. 5. Download the libsapjco3.so file and copy the file to the following location: <Informatica installation directory>/services/shared/bin.
  6. 6. Include the libsapjco3.so and sapjco3.jar files in the SAPJCO.zip file.
  7. 7. Copy the SAPJCO.zip file to the following location: <Informatica installation directory>/services/CatalogService/ScannerBinaries.
  8. 8. Enable the Catalog Service.
  9. 9. Restart the Informatica domain.

Basic Information

The General tab includes the following basic information about the resource:
Information
Description
Name
The name of the resource.
Description
The description of the resource.
Resource type
The type of the resource.
Execute On
You can choose to execute on the default catalog server or offline.

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 the How To-Library Articles tab in the Informatica Doc Portal
Custom 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.