SAP Enterprise Resource Planning (ERP) is a platform that incorporates the key business functions of an organization. Use this catalog source to extract metadata from SAP ERP Central Component (ECC) or SAP S/4HANA source systems.
Objects extracted
The SAP ERP catalog source extracts metadata from the following assets in SAP S/4HANA and SAP ECC source systems:
•Packages
Includes subpackages and assets in subpackages.
•Classes in active state
•Data Elements in active state
•Data Sources built on tables, views and function modules
•Domains in active state
•RFC function modules and function modules used in a data source
•Executable programs in active state
•RFC Connections in active state
•Tables in active state such as transparent tables, cluster tables, and pool tables
•Fields
•Transaction codes in active state
•Views such as database views, CDS views, append views, and external views
Prerequisites
To extract metadata from SAP S/4HANA and SAP ECC source systems, complete the following prerequisite tasks:
Create a connection in the Administrator
Use the SAP BAPI connector to configure a connection to SAP ERP in Informatica Intelligent Cloud Services Administrator. For information about configuring a connection in Administrator, see Connections in the Cloud Common Services help.
Import SAP transports
Import SAP transports to the SAP ERP source. You can choose the transport from the dedicated Informatica namespace or the custom namespace.
Transports are available in the SAP_Scanner_Binaries.zip file located in the Informatica Cloud Secure Agent installation directory. The ZIP file is available in the following location:
It is recommended that you import the latest version of the transports. If you use transports from the version preceding the current version, you see the following message in the logs: SAP Transport version is on previous Version.!!Please import latest transport!!
Important: Metadata extraction from SAP ERP sources can fail if the transports are not valid or unavailable. For more information, see Knowledge Base article 000202750.
Download the latest version of the 64-bit SAP JCo libraries from the SAP Service Marketplace based on the operating system on which the Secure Agent runs. Copy the files to <Informatica Secure Agent installation directory>\apps\Data_Integration_Server\ext\deploy_to_main\bin\rdtm-extra\tpl\sap.
The following table shows the libraries you need to download depending on your operating system:
Secure Agent System
SAP File Name
Windows
sapjco3.jar
sapjco3.dll
Linux
sapjco3.jar
libsapjco3.so
Note: Create the deploy_to_main\bin\rdtm-extra\tpl\sap directory if it does not already exist.
Configure the JAVA_LIBS property
Configure the JAVA_LIBS property in Informatica Intelligent Cloud Services Administrator. Perform the following steps:
1Log in to Informatica Intelligent Cloud Services Administrator.
2Click Runtime Environments to access the Runtime Environments page.
3From the menu to the left of the agent name, select Edit Secure Agent.
4From the Service list, select Data Integration Server.
5From the Type list, select Tomcat JRE.
6Enter the JAVA_LIBS value based on the operating system on which the Secure Agent runs.
8Repeat the steps on every machine where you installed the Secure Agent.
9Restart the Secure Agent.
Configure permissions
To extract metadata, you need account access and permissions on the SAP S/4HANA and SAP ECC source systems.
Configure user-authorization profiles
To access metadata from SAP ERP, the SAP ERP administrator creates the following user authorization profiles:
Authorization Object
Description
Field Values
S_RFC
Authorization check for RFC access
ACTVT: 16 (Execute)
RFC_NAME:
DDIF_FIELDINFO_GET
RFCPING
RFC_GET_FUNCTION_INTERFACE
RFC_METADATA_GET
SEU_COMPONENT
RFC_TYPE: FUGR, FUNC
If you imported scanner transports from the custom namespace, use the following value:
ZINFA_ERP
If you imported scanner transports from the Informatica namespace, use the following value:
/INFASCAN/ERP_META
If you enabled UCON (Unified Connectivity), perform one of the following tasks:
- Disable UCON. Set the ucon/rfc/active profiling parameter value to 0.
- If you can't disable UCON, whitelist the Informatica RFC function modules that start with:
ZINFA or /INFASCAN/
Permissions to run data profiles
You do not need additional permissions to run data profiles.
Configuration parameters for metadata extraction
Specify additional configuration parameters from the Configuration Parameters area in the Metadata Extraction tab of the Configuration page.
Namespace. Specifies the namespace from which you imported the scanner transport. Select the dedicated Informatica namespace or the custom namespace based on the scanner transport that you imported.
Data profiling for SAP ERP objects
Prerequisites
- Use the SAP Table connector to run data profiles and data quality tasks on SAP ERP objects. Create an SAP Table connection in Informatica Intelligent Cloud Services Administrator.
- To read data from SAP tables, install the SAP Table connection transport files from the Secure Agent directory to the SAP system.
For information about configuring SAP Table connection in Administrator and installing transport files to read from SAP tables, see SAP Connector in the Data Integration Connectors help.
Configure data profiling to run profiles on metadata extracted from SAP S/4HANA and SAP ECC source systems. You can run data profiles on the following SAP ERP objects:
•Table
•View
After running the catalog source job, you can view the profiling statistics in Data Governance and Catalog. The data profiling task runs profiles on the following data types for SAP ERP objects:
•ACCP
•CHAR
•CLNT
•CUKY
•CURR
•DATS
•DEC
•D16D
•D16R
•D34D
•D34R
•FLTP
•INT2
•INT4
•LANG
•LCHR
•LRAW
•NUMC
•QUAN
•SSTRING
•STRING
•STRU
•TIMS
•UNIT
•RAW
•RAWSTRING
For information about rules and guidelines for SSTRING, STRING, and RAWSTRING data types, see SAP Connector in the Data Integration-Free and PayGo help.
Sampling type
You can run data profiling on all rows in the metadata extracted from SAP S/4HANA and SAP ECC source systems.
Data classification for SAP ERP objects
Configure data classification for SAP ERP catalog sources to classify and organize data in your organization.
You can choose one of the following options:
•Data Classification Rules. Choose from predefined or custom data classifications.
•Generated Data Classifications. CLAIRE automatically generates data classifications for the data elements.
Note: SAP ERP source systems can contain ambiguous data with technical field names. To ensure that CLAIRE generates accurate data classifications, it uses the extracted Business Name attribute to generate data classifications.
You can view the data classification results in Data Governance and Catalog.
For more information about data classifications, see Data classification in the Administration help.
Referenced source systems
If the source system references another source system, create a connection assignment in Metadata Command Center to view data lineage with endpoints. To create a connection assignment, create a connection based on the referenced source system, and then assign the connection to the catalog source.
Note: You can view the lineage with reference objects without creating a connection assignment. After connection assignment, you can view the actual objects.
You can perform connection assignment on the following source systems:
•SAP ERP Central Component (ECC) data source to SAP BW data source
•SAP table to Informatica Intelligent Cloud Services Data Integration mappings
•SAP S4/HANA CDS view to SAP BW data source
•SAP S4/HANA CDS view to SAP BW/4HANA data source
•SAP S/4HANA data source to SAP BW data source
Glossary association
Enable glossary association and configure settings for the catalog source to automatically associate or recommend glossary terms as business names for data elements in technical assets.
The following table describes the settings:
Property
Description
Enable auto-acceptance
When enabled, this option automatically associates glossary terms with data elements based on the threshold limit that you specify. The automatically accepted glossary terms appear as business names of data elements in Data Governance and Catalog.
Confidence Score Threshold for Auto-Acceptance
Specify a percentage from 80 to 100 inclusive to set a threshold limit. If a glossary term matches a data asset within the threshold specified, Metadata Command Center automatically assigns the matching glossary term to the data element. The name and description of the glossary term with the highest confidence score appears as the name and description of the data element asset in Data Governance and Catalog.
Ignore Keywords
Choose to ignore specific parts of data elements when making recommendations. You can enter multiple unique prefix and suffix keywords. Keyword values are case insensitive.
Glossary Association Scope
Choose specific top-level business glossary assets to associate with technical assets. Selecting a top-level asset selects its child assets as well.
Note: SAP ERP source systems can contain ambiguous data with technical field names. To generate accurate glossary associations, CLAIRE uses the extracted Business Name attribute for such technical field names.
For more information about the glossary association settings, see the Administrator help.