Introduction
Introduction to Integration Approaches
What is ETL?
What is Data Warehouse?
Introduction to Data warehouse implementations
SAP Business Objects Data Services Overview
History of SAP BODS [evolution, acquisitions etc.]
· Data Services Architecture
· Data Services Tools & its functions
· Data Services Objects & Object Hierarchy
Various implementations using BODS
Data Services Basic Level
Understanding Data Integrator
Describe components, management tools, and the development process
Explain object relationship
Defining source and target metadata
Create a database datastore and import metadata
Create a new file format and handle errors in file formats
Validating, tracing, and debugging jobs
Using descriptions and annotations
Validate and trace jobs
Using View Data and the Interactive Debugger
Creating a batch job
Create a project, job, work flow, and data flow
Using the Query transform in a data flow
Using template tables
Data Services Advance Level
Using built-in transforms and nested data
Using the case, merge, and validation transforms
Data Services Advance Level cont.…
Import metadata from XML documents
Using the XML_Pipeline in a data flow
Using built-in functions
Using date and time functions and the date generation transform to build a dimension table
Using the lookup functions to look up status in a table
Using match pattern functions to compare input strings to patterns
Using database type functions to return information on data sources
Using Data Integrator Scripting Language and variables
Explain differences between global and local variables
Create global variables and custom functions
Using strings and variables in Data Integrator scripting language
Capturing Changes in Data
Using Changed Data Capture (CDC) with time-stamped sources
Create an initial and delta load job
Using history preserving transforms
Implementing SCD Type 0,1,2,3
Handling errors and auditing
Recover a failed job
Create a manual, recoverable work flow
Define audit points, rules and actions on failures
Supporting a multi-user environment
Describe terminology and repository types in a multi-user environment
Create and activate the central repository
Work with objects in the central repository
Migrating Projects
Create multiple configurations in a datastore
Work with projects in the central repository
Create a secure central repository
Implement and modify group permissions
Data Services Advance Level cont.… Profiling Data
Set up the Data Profiler and users
Submit a profiling task
Monitor profiling tasks in the Administrator
Managing Metadata
Import and export metadata
Using Metadata Reports
Performance Tuning
Datastore & Formats
Datastore – Overview & Types
Datastore creation- DB, SAP, Adaptor, Webservice
Formats-Flat file, Excel, DTD, XSD
Data Services Transforms
Overview of Transforms & Category (DI, DQ and PF)
All Transforms of Data Integrator and PF will be covered with examples
Data Services Administration
Management Console operations
Server Manager Operations
Repository Manager Operation
License Manager – adding and upgrading license keys
Execute, schedule, and monitor batch jobs
Dataservices SAP System Handling
SAP Systems-Introduction
SAP BODS and SAP ERP/BW integration
Creation of SAP ERP Datastore and overview of properties
Creation of SAP BW source & target Datastores and overview of properties
SAP ERP creating and getting RFC enabled Function Modules
SAP ERP Tables data extraction
SAP BW Dataflow, Interfaces, objects allowed to BODS
SAP BW Extracting data from SAP BW Infoproviders
Introduction to RAPID MARTS
Introduction to SAP HANA
Configurations in HANA and BODS
Loading data to SAP HANA using BODS
SAP DATA SERVICES 4.0 Introduction
Introduction
About SAP Business Objects Suite (BI & EIM)
SAP Data Services 4.0 Introduction & Overview
SAP Data Services4.0 Administration & Configuration (Server Manager, DSM Console)
New Functionalities & Features
Graphical User Interface
Server Manager, Designer
Management Console, CMC/Information Platform Services (IPS)
New Security Features
User Management in CMC/IPS
Data Services Standard Users & User Groups
User Security-Local Repository & Central Repository & DSM Console
Transforms- Data Integrator, Data Quality & Platform
Password Encryption
Text Data Processing
About SAP Data Services Text Analysis
Text Analysis in Data Services 4.0
Introduction to Text Services Platform and Administrator
Maintaining Text Services Platform
Extracting Text Data- Email, Text, Portal Data, Internet Data
New Flat File Format Types – Unstructured Text, Unstructured Binary
Architecture & New Services
64 Bit Server Components
Adaptive Processing Server (EIM Service)
Performance & Memory Utilization Performance features
Transforms & Functions
New Validation Transform Features
New Joins in Query Transform
New Hierarchy Flattening Transform Features
New Functions- Cryptographic, gen_UUID, BLOB, Copy Query
SAP Extraction
SAP Business Content Extractors i.e. Data Sources extraction from ERP
SAP SLD & SMD Integration
Other Features
New Operational Features-Designer GUI Keyboard accessibility, Multi-Language support
Source & Target additional properties
Migration Techniques
Introduction to Integration Approaches
What is ETL?
What is Data Warehouse?
Introduction to Data warehouse implementations
SAP Business Objects Data Services Overview
History of SAP BODS [evolution, acquisitions etc.]
· Data Services Architecture
· Data Services Tools & its functions
· Data Services Objects & Object Hierarchy
Various implementations using BODS
Data Services Basic Level
Understanding Data Integrator
Describe components, management tools, and the development process
Explain object relationship
Defining source and target metadata
Create a database datastore and import metadata
Create a new file format and handle errors in file formats
Validating, tracing, and debugging jobs
Using descriptions and annotations
Validate and trace jobs
Using View Data and the Interactive Debugger
Creating a batch job
Create a project, job, work flow, and data flow
Using the Query transform in a data flow
Using template tables
Data Services Advance Level
Using built-in transforms and nested data
Using the case, merge, and validation transforms
Data Services Advance Level cont.…
Import metadata from XML documents
Using the XML_Pipeline in a data flow
Using built-in functions
Using date and time functions and the date generation transform to build a dimension table
Using the lookup functions to look up status in a table
Using match pattern functions to compare input strings to patterns
Using database type functions to return information on data sources
Using Data Integrator Scripting Language and variables
Explain differences between global and local variables
Create global variables and custom functions
Using strings and variables in Data Integrator scripting language
Capturing Changes in Data
Using Changed Data Capture (CDC) with time-stamped sources
Create an initial and delta load job
Using history preserving transforms
Implementing SCD Type 0,1,2,3
Handling errors and auditing
Recover a failed job
Create a manual, recoverable work flow
Define audit points, rules and actions on failures
Supporting a multi-user environment
Describe terminology and repository types in a multi-user environment
Create and activate the central repository
Work with objects in the central repository
Migrating Projects
Create multiple configurations in a datastore
Work with projects in the central repository
Create a secure central repository
Implement and modify group permissions
Data Services Advance Level cont.… Profiling Data
Set up the Data Profiler and users
Submit a profiling task
Monitor profiling tasks in the Administrator
Managing Metadata
Import and export metadata
Using Metadata Reports
Performance Tuning
Datastore & Formats
Datastore – Overview & Types
Datastore creation- DB, SAP, Adaptor, Webservice
Formats-Flat file, Excel, DTD, XSD
Data Services Transforms
Overview of Transforms & Category (DI, DQ and PF)
All Transforms of Data Integrator and PF will be covered with examples
Data Services Administration
Management Console operations
Server Manager Operations
Repository Manager Operation
License Manager – adding and upgrading license keys
Execute, schedule, and monitor batch jobs
Dataservices SAP System Handling
SAP Systems-Introduction
SAP BODS and SAP ERP/BW integration
Creation of SAP ERP Datastore and overview of properties
Creation of SAP BW source & target Datastores and overview of properties
SAP ERP creating and getting RFC enabled Function Modules
SAP ERP Tables data extraction
SAP BW Dataflow, Interfaces, objects allowed to BODS
SAP BW Extracting data from SAP BW Infoproviders
Introduction to RAPID MARTS
Introduction to SAP HANA
Configurations in HANA and BODS
Loading data to SAP HANA using BODS
SAP DATA SERVICES 4.0 Introduction
Introduction
About SAP Business Objects Suite (BI & EIM)
SAP Data Services 4.0 Introduction & Overview
SAP Data Services4.0 Administration & Configuration (Server Manager, DSM Console)
New Functionalities & Features
Graphical User Interface
Server Manager, Designer
Management Console, CMC/Information Platform Services (IPS)
New Security Features
User Management in CMC/IPS
Data Services Standard Users & User Groups
User Security-Local Repository & Central Repository & DSM Console
Transforms- Data Integrator, Data Quality & Platform
Password Encryption
Text Data Processing
About SAP Data Services Text Analysis
Text Analysis in Data Services 4.0
Introduction to Text Services Platform and Administrator
Maintaining Text Services Platform
Extracting Text Data- Email, Text, Portal Data, Internet Data
New Flat File Format Types – Unstructured Text, Unstructured Binary
Architecture & New Services
64 Bit Server Components
Adaptive Processing Server (EIM Service)
Performance & Memory Utilization Performance features
Transforms & Functions
New Validation Transform Features
New Joins in Query Transform
New Hierarchy Flattening Transform Features
New Functions- Cryptographic, gen_UUID, BLOB, Copy Query
SAP Extraction
SAP Business Content Extractors i.e. Data Sources extraction from ERP
SAP SLD & SMD Integration
Other Features
New Operational Features-Designer GUI Keyboard accessibility, Multi-Language support
Source & Target additional properties
Migration Techniques
