SAP BW powered by SAP HANA- Data Acquisition

Course Details
Code: BW350H-v015
Tuition (USD): $4,090.00 • Classroom (5 days)

Skills Gained

  • Learn how to extract data from SAP source systems with the SAP API (Application Programming Interface) and how to manage delta data
  • Acquire data from using different interfaces such as : SDI - Smart Data Integration, SDA - Smart Data Access, ODP -Operational Data Provisioning, Flat File, DB Connect, XML, and Data Services
  • Design and maintain process chains and perform transports
  • Distribute data via Data Marts and Open Hub

Who Can Benefit

  • Developer
  • Solution Architect
  • System Administrator
  • Technology Consultant
  • Trainer

Prerequisites

  • Essential:
       -Sound knowledge of the content that is covered in BW310H - Data Warehousing course, especially working with the Data Warehousing Workbench
  • Recommended:
       -Knowledge of the Data Dictionary and at least one SAP Component

Course Details

Course Content

  • SAP BW and HANA Data Acquisition
       -Introducing BW and HANA
       -Explaining Data Acquisition in SAP BW
       -Explaining SAP HANA Optimized Data Staging
       -Comparing & Migrating 3.x to 7.x Data Flow Components
       -Introducing Data Replication to HANA using SLT, SDI, and SDA
  • Data Acquisition with the SAP BW Service API
       -Connecting SAP Source Systems to SAP BW
       -Displaying the Configuration of the SAP BW Service API
       -Modeling Generic DataSources
       -Explaining Business Intelligence(BI) Off The Shelf Content
       -Loading hierarchies from ECC
       -Examining the Transfer of GL Data
       -Adapting BI Content DataSources
       -Implementing Process Chains
  • Delta Data Flow Management
       -Describing Delta Management
       -Explaining Terms and Basic Processes of Delta Enabled DataSources
       -Configuring the Logistics Data Extraction (LO Cockpit)
       -Configuring Generic Delta DataSources
       -Learning Data Transfer Process(DTP) Settings
  • Data Acquisition with ODP and SLT
       -Describing Data Acquisition with Operational Data Provisioning (ODP)
       -Analyzing Operational Delta Queue (ODQ)
       -Replicating Data with SAP Landscape Transformation (SLT)
       -Learning the Details of Real Time Data Acquisition (RDA)
       -Extracting to BW via ODP-SLT
  • Flat File Data Transfer
       -Accessing Data from a Flat File
       -Loading Flat File Hierarchies
       -Using Workspaces for Local Flat File load
  • Additional Data Acquisition Techniques
       -Positioning DB Connect
       -Positioning Universal Data (UD) Integration
       -Explaining XML-Based Extraction
       -Acquiring Data Using an XML Based Web Service
       -Integrating SAP Data Services and SAP BW
       -Positioning HANA SDI capabilities for BW
  • Data Mart Interface and OpenHub
       -Positioning the Data Mart Interface
       -Implementing OpenHub Destinations
       -Exporting a Hierarchy with OpenHub
       -Exporting from a BW InfoProvider to a Native HANA Table
  • Overview of BW Transports
       -Describing the BW Transport System Landscape
       -Determining Object Versions and Metadata
       -Managing BW Transports
       -Troubleshooting Transport Strategies

Course based on software release

  • SAP BW 7.5 powered by SAP HANA