Course Description

Audience: This course is designed for individuals responsible for implementing, administering, and managing data integration projects with the help of Data Integrator/Data Services.
Prerequisites
 1. Knowledge of data warehousing and ETL concept
 2. Experience with SQL language
 3. Data Warehouse Fundamentals
 4. Data Warehouse Architecture and Modeling
Show more

Share

About Trainer

Venkat G
Sr. BODS Consultant/Trainer
Venkat is seasoned SAP BIBO platform, SAP BODS and SAP HANA consultant. He has plenty of experience in conducting trainings in SAP BODS, BIBO and SAP HANA. He is certified in SAP BO administration, SAP BO upgrade, SAP HANA
Show more

Duration

27+ hrs | 30 Videos

Business Objects Data Services (BODS)

Duration
27+ hrs
$69.65 $199.00    
Expand all
Collapse all
  • BODS Overview
    • Overview of the Data Services
    • Data services benefits, associated products, interfaces
    • Data services Architecture on single and distributed environment
    • Overview of the Data Services
    • Data services benefits, associated products, interfaces
    • Data services Architecture on single and distributed environment
  • BODS Designer concepts
    • Creating the repository (Local, Central repository)
    • Exploring the menu options in the designer
    • Creating the project, Job flow, Data flow, Work flows etc.,
    • Defining different types of Data stores (Source and destination data stores)
    • Use data store and system configurations
    • Defining file formats for flat, Excel, XML files
    • Creating the repository (Local, Central repository)
    • Exploring the menu options in the designer
    • Creating the project, Job flow, Data flow, Work flows etc.,
    • Defining different types of Data stores (Source and destination data stores)
    • Use data store and system configurations
    • Defining file formats for flat, Excel, XML files
  • Batch Jobs
    • Creating Batch Jobs
    • Work with objects
    • Create a data flow
    • Adding the Query transform to the data flow
    • Use target tables
    • Execute the job
    • Creating Batch Jobs
    • Work with objects
    • Create a data flow
    • Adding the Query transform to the data flow
    • Use target tables
    • Execute the job
  • Defining Data Integrator Transforms
    • Date Generation Transform
    • Pivot Transform
    • Reverse Pivot Transform
    • XML_Pipeline Transform
    • Date Generation Transform
    • Pivot Transform
    • Reverse Pivot Transform
    • XML_Pipeline Transform
  • Defining Data Platform Transforms
    • Query Transform
    • Case Transform
    • Merge Transform
    • Validation Transform
    • Row Generation Transform
    • SQL Transform
    • Query Transform
    • Case Transform
    • Merge Transform
    • Validation Transform
    • Row Generation Transform
    • SQL Transform
  • Defining Data Quality Transform
    • Address Cleanse
    • Geocoder
    • Address Cleanse
    • Geocoder
  • Implementation of SCD
    • SCD Type0
    • ......Query Transform
    • SCD Type1
    • ......Table Comparison Transform
    • ......Map Operation Transform
    • SCD Type2
    • ......History Preserving Transform
    • ......Key Generation Transform
    • SCD Type0
    • ......Query Transform
    • SCD Type1
    • ......Table Comparison Transform
    • ......Map Operation Transform
    • SCD Type2
    • ......History Preserving Transform
    • ......Key Generation Transform
  • Using Functions, Scripts, and Variables
    • Define built-in functions
    • Use functions in expressions
    • Use variables and parameters
    • Create Custom functions
    • Use Data Services scripting language
    • Define built-in functions
    • Use functions in expressions
    • Use variables and parameters
    • Create Custom functions
    • Use Data Services scripting language
  • Data assessment
    • Using the data profiler
    • Using the validation transform
    • Using the data profiler
    • Using the validation transform
  • Setting up Error Handling
    • Set up recoverable work flows
    • Set up recoverable work flows
  • Setting up Exception Handling
    • Try/Catch Techniques
    • Try/Catch Techniques
  • IF Conditional
  • While-Loop Implementation
  • Capturing Changes in Data
    • Update data over time
    • Use source-based CDC
    • Use target-based CDC
    • ......SCD Type 2
    • Update data over time
    • Use source-based CDC
    • Use target-based CDC
    • ......SCD Type 2
  • SAP Integration
    • Data extraction from ECC system to File, Table and SAP BI
    • Data extraction from ECC Extractors
    • Data Extraction from SAP BW
    • ABAP Workflows
    • Data extraction from ECC system to File, Table and SAP BI
    • Data extraction from ECC Extractors
    • Data Extraction from SAP BW
    • ABAP Workflows
  • SAP HANA and SAP BODS Integration
    • Introduction to SAP HANA
    • Introduction to SAP HANA Studio
    • Create Data Store for SAP HANA
    • Perform the load into SAP HANA
    • Store the data in Column Store
    • Preview the data in SQL console of SAP HANA Studio
    • Introduction to SAP HANA
    • Introduction to SAP HANA Studio
    • Create Data Store for SAP HANA
    • Perform the load into SAP HANA
    • Store the data in Column Store
    • Preview the data in SQL console of SAP HANA Studio

Last Viewed Video

No Video Viewed.