SAP BODS Online Training

2517 Ratings

 30 Hours

 24/7 Digital Lab Access
 2760 Total Learners
 30% Off

Instructor-led Online Training

Interactive Live training
Real Time, Certified, Expert Trainers
Job oriented & Industry ready curriculum
Free Course Access for 365 Days
Fast-track / Regular / Weekend

Recorded Video Training

Learn at your own convenience
Certified & Industry Experts Trainers
Email & Forum support for 365 days
Priority Certification support
Multi Instructor sessions

About Course

Learn SAP BODSSAP BODS (Data Services) course information

  • SAP BODS is a prominent ETL tool used to build Enterprise data warehouses and data mart.
  • It is used in massive Data intensive applications and It is used both batch and real time mode.
  • It is heavily used in SAP data migration application and used as a prominent ETL tool for ETL replication in SAP HANA.

SAP Data Services is an ETL Tool, Data Integration and Transformation Software application for Monitoring, Designing, Running, Scheduling and Administrating the ETL Jobs. Data Integrator/Data Services allows users to develop and execute workflows called data stores (Web Services, Databases, Applications and Flat files etc.) and then allows the user to transform, combine, and refine the data and outputs in same or different data stores.

Data Services integrates with vast number of products includes SAP Business Warehouse, SAP Data Quality Management, SAP Information Steward, SAP Master Data Management and others for different usage and different process.

Who can learn?

  • Basic Knowledge on Data Warehousing and Business Intelligence.
  • Knowledge on any RDBMS.

SAP BODS Course Curriculum

Duration: 30 Hours

  • 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
  • Concepts of Job, Workflow and Data Flow
  • Concepts of Datastore
  • Creating basic Batch Job
  • Transforms overview
  • Analyzing data sources
  • Joining data from multiple sources
  • Basic transformations and build-in functions
  • Aggregating data in BODS
  • Lookup
  • Defining file formats for file data source
  • Working with XML files(XSD,DTD)
  • COBAL COPY BOOKS
  • File Formats as Source and as Targets
  • Case and Merge transforms
  • SQL transform
  • Validation transform
  • Row Generation
  • Map Operation
  • Combining Validation and Auditing – best practices
  • 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
  • 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
  • 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
  • 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
  • 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.
  • 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
  • Push-down concept
  • Cases when push-down doesnít work
  • Data Transfer transform
  • Cashing in BODS
  • Defining cashing for lookups and Table Comparison
  • Degree of parallelism
  • Designing custom function for parallel execution
  • Bulk loading operation
  • Using MultiLoad for Teradata targets
  • Execution parameters
  • Rows per commit
  • Access to BODS metadata
  • Operational metadata
  • Auditing metadata
  • Creating your own metadata by using BODS metadata

Trainer Information

  • DWH enterprise archiect with 15 Years of experience working with fortune 500 companies with strong expertise on SAP BO BODS & HANA.
  • 10 years of Classroom and Online Training experience.
  • Domain expertise on Banking, Insurance, Healthcare and retail.


Related Courses

Attend Live Demo
Suggest me a course for a better career
Donor Details
Donee Details
(Your Details)
(To whom you want to gift a course)
Request a Demo
Register For Free Digital Library
Quick Enquiry
We respond as soon as possible.
Register For Course Demo
Course Highlights:
Free Course Access for 365 Days.
Real Time, Certified, Expert Trainers.
Email & Forum support for 365 days.
Fast-track / Regular / Weekend.
Job oriented & Industry ready curriculum.
Register For Free Live Demo
Thanks for your interest.
Our Senior Course Adviser will get back to you soon.
Follow us