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