SAP Business Warehouse (SAP BW)
SAP Business Warehouse is a model driven data warehouse that is based on the SAP NetWeaver ABAP environment. The SAP Business Warehouse collects, transforms and stores data generated by SAP and non-SAP applications. This data is accessible through built-in reporting, business intelligence and analytic tools as well as third-party software. The SAP Business Warehouse resource is also called as the Classic SAP Business Warehouse.
Objects Extracted
The SAP Business Warehouse resource extracts metadata from the following assets in a SAP Business Warehouse data source:
- •Info Area
- •Data Source
- •Info Objects
- •Info Object Catalog
- •Source System
- •Characteristics
- •Key Figures
- •Dimension
- •Navigational Attributes
- •InfoSet
- •DSO
- •Info Cube
- •Multi Provider
- •Transformation
- •Transformation Rule
- •Query
- •Query Element or Field
- •Workbook
- •Advanced DSO
- •Composite Provider
- •DTP
- •InfoObject as InfoProvider
Note: If the asset type does not include lineage, hierarchy, categories, and relationship information, you cannot view the following tabs in the Catalog:
- •Lineage and Impact
- •Relationship
- •Contains
Permissions to Configure the Resource
To configure SAP Business Warehouse, complete the following tasks:
- 1. Install Scanner transports.
- 2. Configure a user-authorization profile.
- Installing Scanner Transports
- To extract metadata from SAP Business Warehouse, you must import the Scanner transports that Enterprise Data Catalog uses to extract metadata from SAP Business Warehouse. The transports are located in the SAP_Scanner_Binaries.zip file that is downloaded from the Informatica installer location.
- Configuring User-Authorization Profiles
- The SAP Business Warehouse administrator needs to create the product and development user authorization profiles. The following table describes the 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 ZINFA_BW_FG RFC_TYPE : FUGR, FUNC |
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) |
S_RFC_ADM | Administration for RFC destination | Business Warehouse | ACTVT :03 ICF_VALUE: * RFCDEST : * RFCTYPE : * ( Full Authorization) |
Prerequisites
- 1. Disable the Catalog Service.
- 2. Download the sapjco3.jar file and copy the file to the following location: <Install_directory>/services/CatalogService/access/WEB-INF/lib.
Note: The SAP Java Connector version supported is 3.0.19.
- 3. Download the libsapjco3.so file and copy the file to the following location: <Install_directory>/services/shared/bin.
- 4. Include the libsapjco3.so file in the SAPJCO.zip file and copy the SAPJCO.zip file to the following location: <Install_directory>/services/CatalogService/ScannerBinaries.
- 5. Enable the Catalog Service.
Resource Connection Properties
The General tab includes the following properties:
Property | Description |
|---|
SAP Server Type | The type of SAP server installation: - - SAP Central Instance
- - SAP Load Balancer (Message Server)
|
Server Host | Host name or IP address of the system that hosts the SAP Business Warehouse. |
Login Group | Login group is a group of servers that belong to an SAP system. Login groups distribute user logins to individual instances or groups of SAP instances or application servers. Login groups are maintained in the transaction SAP Logon Groups (SMLG). The option appears when you select SAP Load Balancer (Message Server) as the SAP Server Type. |
Message Server Port | Default port of the Message server. The option appears when you select SAP Load Balancer (Message Server) as the SAP Server Type. |
System Number | System number of the SAP Business Warehouse. The option appears when you select SAP Central Instance as the SAP Server Type. |
SAP SID | The SAP System Identifier of the SAP instance. |
Client | The SAP Business Warehouse client to access data from the SAP Business Warehouse. |
Username | SAP Business Warehouse system user name. |
Password | SAP Business Warehouse system password. |
Language | The language for metadata import from the resource. The selected login language is used to extract the SAP descriptions. |
Auto Assign Connections | Indicates whether the connections must be assigned automatically. |
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 | Enables metadata extraction |
Source Extraction | The type of source metadata extraction: - - Full. Extracts the full metadata from the source.
- - Based on Object Modified Date. Extracts metadata that is modified or created after the specified date. You must perform at least one full extraction before extracting metadata based on object modified date.
- - Based on Query Execution Date. Extracts metadata based on the query execution date. The corresponding dependant metadata objects are also extracted.
|
Memory | The memory value required to run a scanner job. Specify one of the following memory values: 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, INFO, or ERROR. Default value is INFO.
- - -Dscanner.container.core=<No. of core>. Increases the core for the scanner container. The value must 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 multiple key value pairs.
- - -Dscanner.pmem.enabled.container.memory.jvm.memory.ratio=<1.0/2.0>. Increases the scanner container memory when pmem is enabled. The default value is 1.
|
Track Data Source Changes | View metadata source change notifications in Enterprise Data Catalog. |