SAP Business Warehouse (BW) is a data warehouse product of SAP that is based on the SAP NetWeaver ABAP environment. SAP BW can transform and consolidate business information from any source system for reporting, analysis, and interpretation of business data. This data is accessible through built-in reporting, business intelligence and analytics tools as well as third-party software.
Objects extracted
The SAP BW catalog source extracts metadata from the following assets in an SAP BW source system:
•Info Area
•Data Source
•Info Objects
•Info Object Catalog
•Source System
•Info Source
•Characteristics
•Key Figures
•Dimension
•Navigational Attributes
•InfoSet
•DataStore Object (DSO)
•InfoCube
•Multi Provider
•Transformation
•Transformation Rule
•Query
•Query Element or Field
•Workbook
•Advanced DSO
•Composite Provider
•DTP
•InfoObject as InfoProvider
•CDS View
The catalog source job extracts only CDS views that have queries.
•Open Hub Destination
Prerequisites
To extract metadata from SAP BW source systems, complete the following prerequisite tasks:
Create a connection in Administrator
Use the SAP BW connector to connect to SAP BW. For information about configuring a connection in Administrator, see Connections in the Cloud Common Services help.
Install the SAP BW Reader transport files
Install the SAP BW Reader transport files on the SAP machines that you want to connect to. If you don't install the latest version of the SAP BW Reader transport files, the following message appears on the Registration page when you configure the catalog source: The test connection for <Connection name> failed. Unable to fetch Function Module, please validate for transport installation
For more information, see Installing SAP BW Reader transport files in the SAP Connector module in the Data Integration Connectors help.
Import SAP transports
Import SAP transports to the SAP BW 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 the scanner 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 BW 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. To do so, 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
Before you configure an SAP BW catalog source in Metadata Command Center, configure the following permissions:
Configure user-authorization profiles
The SAP Business Warehouse administrator creates the following product and development user authorization profiles:
Authorization Object
Description
Class
Field Values
S_RFC
Authorization check for RFC access
Cross Application Authorization Objects
ACTVT: 16 (Execute)
RFC_NAME:
DDIF_FIELDINFO_GET
RFCPING
RFC_GET_FUNCTION_INTERFACE
RFC_METADATA_GET
RFC_TYPE : FUGR, FUNC
If you imported scanner transports from the custom namespace, use the following value:
ZINFA_BW_FG
If you imported scanner transports from the Informatica namespace, use the following value:
/INFASCAN/BW_FG
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/
S_RS_COMP
Business explorer components
Business Warehouse
ACTVT : 03,16 RSINFOAREA: * (Full Authorization)
RSINFOCUBE: * (Full Authorization)
RSZCOMPID: * (Full Authorization)
RSZCOMPTP: Full Authorization
S_RS_COMP1
Business explorer components: Enhancements to the owner
Business Warehouse
ACTVT : 03,16
RSZCOMPID: * (Full Authorization)
RSZOWNER: * (Full Authorization)
RSZCOMPTP: * (Full Authorization)
S_RS_ISET
Data warehouse workbench InfoSet
Business Warehouse
ACTVT : 03
RSINFOAREA - * (Full Authorization)
RSINFOSET - * (Full Authorization)
RSISETOBJ - * (Full Authorization)
S_RS_ADMWB
Data warehouse workbench objects
Business Warehouse
ACTVT : 03
RSADMWBOBJ - * (Full Authorization)
Connection properties
After you configure a connection to SAP BW in Informatica Intelligent Cloud Services Administrator, you can view the connection properties for that connection on the Registration page in Metadata Command Center.
The following table describes the SAP BW connection properties:
Property
Description
Connection Name
Name of the connection.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
Maximum length is 255 characters.
Description
Description of the connection. Maximum length is 4000 characters.
Type
SAP BW Connector
Runtime Environment
The name of the runtime environment where you want to run tasks.
Select a Secure Agent.
Host Name
The host name or IP address of the SAP BW server to which you want to connect.
Note: If you select the Load balancing option, enter a value to continue.
System Number
The system number of the SAP BW server.
Get the required system number from the SAP system to which you want to connect.
Note: If you select the Load balancing option, enter a value to continue.
The following table describes the advanced connection properties:
Property
Description
Keystore location
The path and file name of the keystore file to connect to SAP.
Enter both the path and file name in the following format:
<Directory>/<Keystore file name>.jks
Keystore password
The password to access the keystore file.
Private Key password
The export password to access the .P12 file.
SAP Additional Parameters
Additional SAP parameters that the Secure Agent uses to connect to the SAP system as an RFC client.
Specify the required RFC-specific parameters and connection information to enable communication between Data Integration and SAP.
You can specify the Secure Network Communication (SNC) parameters as additional arguments to securely connect to SAP as shown in the following format:
SNC_MODE=1 SNC_QOP=3 SNC_MYNAME=p:CN=<Common name>, OU=<Organizational unit>, O=<Organization>, C=<Country> This is the SNC name of the Secure Agent machine. SNC_PARTNERNAME=p:CN=<Common name>, OU=<Organizational unit>, OU=SAP Web AS, O=<Organization>, C=<Country>. This is the SNC name of the SAP system. SNC_LIB =<Secure Agent installation directory>/apps/Data_Integration_Server/ext/deploy_to_main/bin/<libsapcrypto.so for Linux/sapcrypto.dll for Windows> X509CERT=<X509 certificate>
Note: The values of any required connection parameters override SAP additional parameter values that you have entered.
Note: The SAP BW catalog source in Metadata Command Center supports only Secure Network Communication (SNC) with X.509 certificate. You can also use SNC with username and password.
Configuration parameters for metadata extraction
Specify additional configuration parameters from the Configuration Parameters area in the Metadata Extraction tab of the Configuration page.
Source Extraction. Filters the metadata that you extract from an SAP BW source system.
You can choose one of the following values:
•Full. Extracts the full metadata from the source.
•Based on Query Execution Date. Extracts metadata based on the query execution date that you specify for the Scan date parameter in the YYYYMMDD format. The corresponding dependent metadata objects are also extracted.
•Based on Object Modified Date. Extracts metadata that is modified or created after the date that you specify for the Scan date parameter in the YYYYMMDD format. Perform at least one full extraction before extracting metadata based on object modified date.
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.
Referenced source systems
When you run the catalog source job, if the catalog source references another source system, a reference catalog source and connection get created that point to the reference source system. To view the complete lineage for your catalog source, you can perform connection assignment from the reference catalog source connection to the objects in the reference source system. A reference source system might be a database, such as SAP HANA Database. You must first create and run an endpoint catalog source that connects to the reference source system.
Note: You can view the lineage with reference objects without performing a connection assignment. After connection assignment, you can view the actual objects.
You can assign the following source systems as endpoint catalog sources:
Source system
Endpoint
SAP HANA Database
Database
SAP ERP
SapSchema
You can perform a connection assignment from the following assets and catalog sources to SAP BW:
•From Calculation View assets of SAP HANA Database to Composite Provider assets of SAP BW
•From Table assets of SAP HANA Database to DataSource assets of SAP BW
•From View assets of SAP HANA Database to DataSource assets of SAP BW
•From CDS View assets of SAP ERP to DataSource assets of SAP BW
•From DataSource assets of SAP ERP to DataSource assets of SAP BW
Data profiling for SAP BW objects
Configure data profiling to run profiles on the metadata extracted from an SAP BW source system. You can view the profiling statistics in Data Governance and Catalog.
You can run data profiles on the following SAP BW objects:
•InfoCube
•MultiProvider
•DataStore Object (DSO)
Sampling type
You can run data profiles on all rows in the metadata extracted from SAP BW source systems.
Data classification for SAP BW objects
Configure data classification for SAP BW 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 BW 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.
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 BW 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.