SAP BODS Online Training 4.2

 50 Hours

 24/7 Digital Library 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 BODS Online Training

  • 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: 50 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.

Frequently asked questions

The SAP Business Objects Data Services (BODS)application can help by delivering a single enterprise-class solution for data integration, data quality, data profiling, and text analysis that allows you to integrate, transform, improve, and deliver trusted data that supports critical business processes and enables sound decisions.

Bigclasses offers 365 days access to videos, course materials, 24/7 Support, and course material upgrading to latest version. Bigclasses involves working with real time projects,test cases and assignments.The entire course content is in line with clearing SAP BODS Certification exam.

We offer four types of Modes:

  • Instructor-led Online Training
  • Recorded Video Training
  • Corporate Training
  • Project Support
Apart from technical training & hands-on project work bigclasses will guide the students to get placed in there dream roles and we would be happy to assist students with the process of preparing yourself for the interview and the job.
We provides you email support to your queries. If the query is not resolved by email we can arrange for a one-on-one session with our trainers. The best part is that you can contact BigClasses even after completion of training to get support and assistance.

Request a Demo


Related Courses

Let us know your convenient schedule
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 for sample video
Register For Free Digital Library
Quick Enquiry
We respond as soon as possible.
Register For Course Demo
Thanks for your interest.
Our Senior Course Adviser will get back to you soon.
Follow us
Submit your details
PGlmcmFtZSB3aWR0aD0iMTAwJSIgaGVpZ2h0PSIxMDAlIiBzcmM9Imh0dHBzOi8vd3d3LnlvdXR1YmUuY29tL2VtYmVkL0Qyc2h6dFc4WWhFIiBmcmFtZWJvcmRlcj0iMCIgYWxsb3dmdWxsc2NyZWVuPjwvaWZyYW1lPg==
Attend Live Demo