Goals

  • 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

Audience

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

Prerequisites

Essential

  • Sound knowledge of the content that is covered inBW310H– Data Warehousing course, especially working with the Data Warehousing Workbench

Recommended

  • Knowledge of the Data Dictionary and at least one SAP Component

Course based on software release

  • SAP BW 7.5 powered by SAP HANA

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