SAP HANA Training’s Providing SAP BODS Online Training in Hyderabad & Bangalore India. SAP Data Services is a data integration & transformation software application. It allows users to develop & execute workflows that take data from predefined sources called Data Stores (applications, flat-files, Web services, databases…) and then allows the user to combine, transform, refine that data & then output the results back to the same or different data stores.

In addition to standard data transformation functions like joins, filters, lookups, aggregations, & calculations, SAP Data Services offers functionality for text analysis, data profiling & auditing, data quality operations such as matching, geocoding & address standardization. also supports Changed- Data Capture, which is an important capability for providing input data to both data-warehousing & stream-processing systems. Lastly, SAP Data Services supports both batch processing, it is the traditional approach to data transformation, & real-time services that allow applications to query Data Services & get an immediate response based on a predefined workflow.

In the SAP landscape, SAP Data Services integrates with a large number of other products including SAP Data Quality Management, SAP Information Steward, SAP Business Warehouse, & SAP Master Data Management, & others, all for different purposes & using different methods.

Please reach me :+91-9848686581

BODS Course Content



Lesson 1.Dataware housing concepts

  • Describe dimensional modeling

Lesson 2. Understanding Data Services

  • Describe components, management tools, and the development process
  • Explain object relationship

 Lesson 3. Defining source and target metadata

  • Create a database data storeand import metadata
  • Create a new file format and handle errors in file formats 

Lesson 4. Validating, tracing, and debugging jobs

  • Use description and annotations
  • Validate and trace jobs
  • Use view data and the Interactive Debugger 

Lesson 5. Creating a batch job

  • Create a project, job, work flow, and data flow
  • Use the query transform in a data flow
  • Use template tables

Lesson 6. Using built-in transforms and nested data

  • Use the case, merge, and validation transforms
  • Use the Pivot, reverse Pivot
  • Hierarchy flattening

Lesson 7. 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

Lesson 8. Using Data Services Scripting Language and Variables

  • Explain differences between global and local variables
  • Create global variables and custom functions
  • Use strings and variables in Data Integrator scripting language 

Lesson 9. Capturing Changes in Data

  • Use Change Data Capture (CDC) with time-stamped sources
  • Source CDC concept and working
  • Target CDC concept and working
  • Working with Slowly  changing Dimentions(type1,2,3)
  • Create an initial and delta load job
  • Use history preserving transform 

Lesson 10.Handling errors and auditing

  • Recover a failed job
  • Create a manual, recoverable work flow
  • Define audit points, rules and actions on failures 

Lesson 11. Supporting a multi-user environment

  • Describe terminology and respository types in a multi-user environment
  • Create and activate the central repository

Lesson 12. Migrating Projects

  • Work with projects in the central repository
  • Creation of Profile Repository
  • Understand Profiling 

Lesson 13. Using the Administrator

  • Execute, schedule, and monitor batch jobs
  • Understand architecture, load balance index, and job execution in server groups 

Lesson 14 Profiling Data

  • Set up the Data Profiler and users
  • Submit a profiling task
  • Monitor profiling tasks in the Administrator 

Lesson 15. Managing Metadata

  • Import and export metadata
  • Use Metadata Reports 

Lesson 16.Data Quality Management 

Lesson17.SAP Integration

  • Data extraction from ECC system to File, DatabaseTables
  • SAP Extraction and loading into SAP BI
  • ABAP WorkFlows
  • Extracting data from SAP BI using Openhub Services and Data services as 3rd party system.
  • Working with SAP Function Modules
  • Extractions through BW DataSources.
  • Configuration and RFC Maintainance

Lesson18.SAP Integration

  • Integration of SAP HANA with BODS
  • Configuring the SAP HANA Datastore
  • Loading into  SAP HANA(ECC,Flatfiles,Db tables)
  • Working with the  SAP Dataservices Workbench

Leave a Comment

Your email address will not be published. Required fields are marked *