Home > Vendors > advanced-technology-courses > atc-sbo

Share

ATC-SBO - 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.

Duration: 5.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training

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

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

Audience

  • 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

Certification

product-certification
Trainocate Certificate of Attendance

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Advanced Technology Courses Popular Courses

atc-python-programming

The course is all about to learn the Python programming language. Its emphasis the core libraries and most useful libraries developed by the Python.

atc-aif

The Artificial Intelligence Fundamentals course provides a comprehensive introduction to the basic principles and concepts of artificial intelligence (AI). This

atc-isc

Our Trainer the Trainer course is designed to equip aspiring trainers with the skills and knowledge they need to deliver effective and engaging training session

atc-fht200

This course teaches individuals how to become proficient in the administration and management of the Falcon Platform, a cyber-security platform by CrowdStrike.
Enquire Now
1zXmzb
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy
➤