SAP Business Objects

SAP BODS is a data processing platform, it is used in extracting data from all types of dissimilar systems, transform it into meaningful information and load it into diverse types of systems.

With full visibility into data quality, business users of an organization can observe that how their data measures up against information governance rules and standards.

Understand the working and importance of SAP BODS to deliver better solutions during crisis. Our training comprises of Basic data profiling and Query Transform, Platform Transforms Overview, Data Integrator Transforms and many more.

Objectives:

• Gain the knowledge to participate in implementing, administering, and managing data integration projects  
• Acquire the basis for more advanced training in Data Quality Services 
• Gain the ability to troubleshoot batch jobs and set up error handlings 
• Attain potential to create batch jobs for the data integration

Content:

• Unit 1: BODS overview
• 1. Overview of the Data services
• 2. Data services benefits, associated products, interfaces
• 3. Data services Architecture on single and distributed environment
• Unit 2: BODS Designer concepts
• 1. Creating the repository (Local, Central repository
• 2. Exploring the menu options in the designer
• 3. Creating the project, Job flow, Data flow, Work flows etc., defining different types of Data stores (Source and destination data stores)
• 4. Use data store and system configurations
• 5. Defining file formats for flat, Excel, XML files
• Unit 3: Batch Jobs
• 1. Creating Batch Jobs
• 2. Work with objects
• 3. Create a data flow
• 4. Adding the Query transform to the data flow
• 5. Use target tables
• 6. Execute the job
• Unit 4: Defining Data Integrator Transforms
• 1. Date Generation Transform
• 2. Pivot Transform
• 3. Reverse Pivot Transform
• 4. XML_Pipeline Transform
• Unit 5: Defining Data Platform Transforms
• 1. Query Transform
• 2. Case Transform
• 3. Merge Transform
• 4. Validation Transform
• 5. Row Generation Transform
• 6. SQL Transform
• Unit 6: Defining Data Quality Transform
• 1. Address Cleanse
• 2. Geocoder
• Unit 7: Implementation of SCD
• 1. SCD Type0
• Query Transform
• 2. SCD Type1 o
• Table Comparison Transform
• Map_Operation Transform
• 3. SCD Type2
• Table Comparison Transform
• History Preserving Transform
• Key Generation Transform
• Unit 8: Using Functions, Scripts, and Variables
• 1. Define built-in functions
• 2. Use functions in expressions
• 3. Use variables and parameters
• 4. Create Custom functions
• 5. Use Data Services scripting language
• And more.

Prerequisites:

• Good knowledge in SQL and Data Warehousing concepts  
• Proficient in basic Unix Commands