Goals

  • Learn how to extract data from SAP source systems with Service API and how to manage delta data
  • Acquire data from other source systems using different interfaces such as: DB Connect, Universal Data Integration, XML, and Data Services

Audience

  • Application Consultant
  • Business Analyst
  • Business Process Architect
  • Business Process Owner / Team Lead / Power User
  • Enterprise Architect
  • Program / Project Manager
  • Technology Consultant

Prerequisites

Essential

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

Recommended

  • Knowledge of the Data Dictionary as well as at least one SAP Component.

Course based on software release

  • SAP NetWeaver BW 7.4

Content

  • SAP BW Data Acquisition Process
    • Explaining Data Acquisition in SAP BW
    • Creating SAP BW 3.x Data Flow
    • Comparing and Migrating 3.x / 7.x SAP BW Data Flows
    • Directly Accessing Source System Data
    • Loading Directly Without Persistent Staging Area (PSA)
    • Reviewing Details of Real-Time Data Acquisition (RDA)
  • Data Acquisition with the SAP BW Service API
    • Connecting SAP Source Systems to SAP BW
    • Displaying the Configuration of SAP BW Service API
    • Explaining BI Content
    • Examining the Transfer of GL Data
    • Examining Generic DataSources
    • Enhancing BI Content DataSources
    • Configuring Logistics Data Extraction
  • Delta Data Flow Management
    • Describing Delta Management
    • Explaining Terms and Basic Processes of Delta Enabled DataSources
    • Analyzing Delta Management
  • Data Acquisition with Operational Data Provisioning (ODP) and SAP Landsape Transformation (SLT)
    • Describing Data Acquisition with ODP
    • Analyzing Operational Delta Queue (ODQ)
    • Replicating Data with SLT
    • Acquiring Data in Real Time with SLT
  • Flat File Data Transfer
    • Loading Data from a Flat File
    • Loading Hierarchies in SAP BW Using the Hierarchy Framework
    • Exporting a hierarchy using OpenHub
  • Data Acquisition with DB Connect
    • Creating a DB Connect DataSource
  • Data Acquisition with Universal Data (UD) Integration
    • Creating UD Connect DataSources
  • XML-Based Data Acquisition
    • Explaining XML-Based Extraction
    • Acquiring Data Using an XML-Based Web Service
    • Creating HybridProviders
  • Data Acquisition with SAP Business Objects Data Services
    • Integrating SAP Business Objects and SAP BW
  • Data Mart Interface and Open Hub
    • Examining the Data Mart Interface for Data Transfers
    • Implementing OpenHub Destinations

CPE Credits

40 CPE Credits

Please note CPE credits are available only for publicly scheduled courses delivered at SAP locations. CPE credits are not available for virtual classroom deliveries or customer specific deliveries.

This course is also available as a test system within SAP Live Access

Learn more

Register your interest for taking this course

Let us know when and where you'd like to attend and we'll notify you when sessions become available.

Note: Location can be for a public classroom or a virtual that meets your prefered timezone.

Register Interest