Database

ATC-SBO : SAP Business Objects

Course Duration

5 Days

Delivery

ILT VILT

Overview

Overview Course Curriculum Training Schedule Exam & Certification FAQs

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.

What You'll Learn

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

Who Should Attend

Project team members with basic knowledge of Data Integration and Data Warehousing concepts
Project Managers and Data Warehousing Consultants who work with data integration

Prerequisites

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

Learning Journey

Coming Soon...

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

Unit 9: Data assessment
1. Using the data profiler
2. Using the validation transform

Unit 10: Setting up Error Handling
1. Set up recoverable workflows

Unit 11: Setting up Exception Handling
1. Try/Catch Techniques

Unit 12: IF Conditional

Unit 13: While-Loop Implementation

Unit 14: Capturing Changes in Data

Unit 15: Data assessment
1. Update data over time
2. Use source-based CDC
3. Use target-based CDC

SCD Type 2

Unit 16: Multi-User Environment (Local Repo Vs Central Repo)

Unit 17: SAP Integration
1. Data extraction from ECC system to File, Table and SAP BI
2. Data extraction from ECC Extractors
3. Data Extraction from SAP BW
4. ABAP Workflows

Unit 18: SAP HANA and SAP BODS Integration
1. Introduction to SAP HANA
2. Introduction to SAP HANA Studio
3. Create Data Store for SAP HANA
4. Perform the load into SAP HANA
5. Store the data in Column Store
6. Preview the data in SQL console of SAP HANA Studio

Unit 19: Information Steward
1. Data Insight
2. Metadata management
3. Metapedia

Trainocate Certificate of Attendance

Frequently Asked Questions (FAQs)

Why should I pick up this course and get certified?

Career Advancement: Boost your earning potential and unlock new job opportunities.
Stay Relevant: Keep your skills current in the ever-changing tech landscape.
Problem-Solving Prowess: Hone your critical thinking and problem-solving abilities.
Hands-On Experience: Apply your knowledge through practical labs and projects.
Expand Your Network: Connect with industry experts and like-minded professionals.
Why take this course with Trainocate?

Here’s what sets us apart:
- Global Reach, Localized Accessibility: Benefit from our geographically diverse training hubs in 16 countries (and counting!).
- Top-Rated Instructors: Our team of subject matter experts (with high average CSAT and MTM scores) are passionate to help you accelerate your digital transformation.
- Customized Training Solutions: Choose from on-site, virtual classrooms, or self-paced learning to fit your organization and individual needs.
- Experiential Learning: Dive into interactive training with our curated lesson plans. Participate in hands-on labs, solve real-world challenges, and take on comprehensive assessments.
- Learn From The Best: With 30+ authorized training partnerships and countless awards from Microsoft, AWS, Google – you're guaranteed learning from the industry's elite.
- Your Bridge To Success: We provide up-to-date course materials, helpful exam guides, and dedicated support to validate your expertise and elevate your career.

Keep Exploring

Course Curriculum

Training Schedule

Exam & Certification

FAQs

Frequently Asked Questions

Improve yourself and your career by taking this course.

Enroll Now

More Courses By Advanced Technology Courses

Browse All Courses

Blockchain

Ready to Take Your Business from Great to Awesome?

Level-up by partnering with Trainocate. Get in touch today.

Name

Phone

I'm inquiring for

Myself
Company

Inquiry Details

By providing your contact details, you agree to our Privacy Policy.