Tag Archives: Data services SAP SAP Training

Business Objects data services online training

Business Objects data services online training course content

Introduction to BODS
  • Place of BODS among modern DI software package
  • Competitive advantage of BODS
  • ETL and ELT approach
  • How both approaches can be combined in one tool
  • Data Services components and architecture
Basics of BODS
  • Concepts of Job, Workflow and Data Flow
  • Concepts of Datastore
  • Creating basic Batch Job
  • Transforms overview
Data profiling and Query Transform
  • Analyzing data sources
  • Joining data from multiple sources
  • Basic transformations and build-in functions
  • Aggregating data in BODS
  • Lookup
Working with Files
  • Defining file formats for file data source
  • Working with XML files(XSD,DTD)
  • COBAL COPY BOOKS
  • File Formats as Source and as Targets
Platform Transforms Overview
  • Case and Merge transforms
  • SQL transform
  • Validation transform
  • Row Generation
  • Map Operation
  • Combining Validation and Auditing – best practices
Data Integrator Transforms
  • Working with hierarchical data
  • Hierarchy Flattening transform
  • Merging data
  • Table Comparison transform
  • Other ways of merging data for RDBMS datastores
  • Slowly changing dimension support in BODS
  • History preserving transform
  • Using built-in functions
  • Use date and time functions and the date generation transform to build a dimension table
  • Use the lookup functions to look up status in a table
  • Use match pattern functions to compare input strings to patterns
  • Use database type functions to return information on data sources
Metadata Management
  • Local and Central repositories
  • Working in a group
  • Propagating Job from development to staging and production environment – best practices
  • Backing up metadata
  • ATL file. Export\Import operations
  • Validating, tracing, and debugging jobs
  • Use description and annotations
  • Validate and trace jobs
  • Use view data and the Interactive Debugger
Management Console
  • Administrating BODS
  • Overview of all major tools
  • Execution of a Job from server
  • Scheduling a job
  • Auto Documentation reports
  • Designing ETLs with auto documentation in mind
BODS Scripting Language
  • Variables in BODS – Scope of variable
  • Scripting language – Advantages and limitations
  • Custom functions in BODS
  • Creating simple function
  • Database procedures
  • Custom functions vs. database functions
SAP BW 7.3 AND SAP ECC,SAP CRM BODS INTEGRATION
  • Connecting to SAP Applications
  • ABAP data Flow processing Using Dataservices
  • IDoc interface connectivity Using Dataservices
  • SAP Application table source in real jobs using Dataservices
  • Executing Batch jobs that contain ABAP Dataflows
  • Connecting to SAP Net weaver Business warehouse
  • Using Dataservices in SAP NW BW environments,Openhub tables
  • Defining SAP Net Weaver BW Datastores Using Data services
  • Loading into SAP NW BW using Dataservices
SAP HANA 1.0 SPS8 BODS INTEGRATION
  • BODS 4.2 With SAP HANA to builg Agile Datamarts using Diffrennt Transforms and File systems
Error Handling in BODS
  • Validating Data Flow, Workflow, Job
  • Error handling on Workflow level – Try and Catch objects
  • Analyzing execution of Batch Job – Log files
  • Debugging in BODS
  • Handing execution errors – best practices
Performance optimization in BODS - Part 1
  • Push-down concept
  • Cases when push-down doesnít work
  • Data Transfer transform
  • Cashing in BODS
  • Defining cashing for lookups and Table Comparison
Performance optimization in BODS - Part 2
  • Degree of parallelism
  • Designing custom function for parallel execution
  • Bulk loading operation
  • Using MultiLoad for Teradata targets
  • Execution parameters
  • Rows per commit
  • Number of loaders
Using BODS Metadata
  • Access to BODS metadata
  • Operational metadata
  • Auditing metadata
  • Creating your own metadata by using BODS metadata
Possible Alternative Topics
  • Data Quality in BODS
  • SAP and SAP BODS
  • Real-time job
  • Integration with other applications
  • Automatic job creation from template
Top ↑