Logo

SAP ERP

Business Objects Data Services
Course Description

DW Concepts                                                                                                                        

ETL Overview                                                                                                                                   

Business Objects Overview                                                                                                          

  • History
  • Components
  • Architecture

Data Services                                                                                                                                    

  • Purpose of Data Services
  • Data Services architecture
  • Define Data Services objects
  • Data Services Designer interface

Data Services Objects                                                                             

  • Object Hierarchy
  • Jobs
  • Workflows
  • Data Flows

Source and Target Metadata                                                                 

  • Data Stores
  • File formats for flat files
  • File formats for Excel files
  • File formats for XML files
  • Lab Exercises

Environment setup                                                                                   

  • Creating repository
  • Setting Job Server
  • Setup for realtime operation (web service)
  • Setting multiple datastores
  • Starting Job servers
  • Lab Exercises

Batch Jobs                                                                                                 

  • Work with objects
  • Create a data flow
  • Use the Query transform
  • Use target tables
  • Execute the job
  • Lab Exercises

Troubleshooting Jobs                                                                                                     

  • Use descriptions and annotations
  • Validate
  • Tracing jobs
  • Use View Data and the Interactive Debugger
  • Use auditing in data flows
  • Lab Exercises

Functions,Scripts and Variables                                                                                  

  • Define built-in functions
  • Functions in expressions
  • Lookup function
  • Decode function
  • Variables and parameters
  • Data Services scripting language
  • Scripting custom functions
  • Lab Exercises

Important Transforms

  • Query Transform
  • Key Generation Transform
  • File format transform
  • Case transform
  • SQL transform
  • Target Table
  • Target Table options
  • Template tables
  • Lab Exercises

Other Transforms

  • Hierarchy Flattening transform
  • Pivot transform
  • XML Pipeline transform
  • Map, MAP CDC transform
  • Validation transform
  • Merge transform
  • Date Generation
  • Effective Date
  • History preserving
  • Lab Exercises

Error Handling                                                                                                                   

  • Error Handling
  • Recoverable work flows

Webconsole                                                                                                                       

  • Administration
  • Error Handling
  • Recoverable work flows

Change Data Capture                                                                                                      

  • Update data over time
  • Database native CDC mechanisms
  • Source-based CDC
  • Target Comparison
  • Lab Exercises

Data quality Overview                                                                                

  • Fundamentals of DQ and Data Cleansing
  • Built in DQ Transformations
  • Data Validation
  • Name & Address cleansing
  • De duplication
  • Cleansing other data
  • Lab Exercises