Sap Business Objects Training - Online Classes by SAP BO Experts

1
SAP Data Services

• The Future Of Enterprise ETL ?

2

• Why and What is an ETL tool?

3
(No Transcript)
4
(No Transcript)
5

• Why SAP BODS?
• In the present market there are many ETL tools
  which dose Extraction, Transformation and Loading
  tasks like SAP BODS, Informatica, IBM InfoSphere
  Data Stage, Abinitio, Oracle Warehouse Builder
  (OWB) etc.
• Lets look over why SAP BODS has got much
  importance in the present market
• Firstly, it is a SAP product, as SAP is serving
  70 of present worlds market and it is tightly
  integrated with any database.
• SAP BODS is a single product which delivers Data
  Integration, Data Quality, Data profiling and
  Text data processing solutions.
• SAP Data Services can Move, Unlock and govern
  enterprise data effectively.
• SAP Data Services Cost-effectively delivers its
  solutions and is single window application with
  complete easy to use GUI (Graphical User
  Interface).

6

• Evolution of BODS
• SAP BusinessObjects Data Services was not
  directly developed by SAP Company. It was
  acquired from BusinessObjects Company and
  BusinessObjects acquired it from Acta Technology
  Inc.
• Acta Technology Inc., headquartered in Mountain
  View, CA was provider of first real time data
  integration platform. The two software products
  provided by Acta were an ETL tool, named as Data
  Integration (DI) tool also known as Actaworks
  and a Data Management or Data Quality (DQ) tool.
• BusinessObjects, a French company, worlds
  leading provider of Business Intelligence (BI)
  solutions acquired Acta Technology Inc. in the
  year 2002. BusinessObjects rebranded the two
  products of Acta as BusinessObjects Data
  Integration (BODI) tool and BusinessObjects Data
  Quality (BODQ) tool.
• In the year 2007, SAP, legend in ERP solutions,
  acquired BusinessObjects and renamed the products
  as SAP BODI and SAP BODQ.  Later in the year 2008
  SAP integrated both software products into a
  single end to end software product and named it
  as SAP BusinessObjects Data Services (BODS) which
  provides both data integration and data
  management solutions.

7

• BODS capabilities
• Data Integration
• Data Migration.(Prebuilt SAP RDS Packages.)
• Data Profiler.
• Data Quality Analysis

8

• Landscape

9

• BODS Architecture

10
Key Elements

• Repository / Repositories
• Data Services Designer
• Job Server /Server Group
• Management Console

11
Repositories (1)

• Somewhere to store your objects
• Projects
• Jobs
• DataSources
• DataFlows
• WorkFlows
• Transforms
• More on these later

12
Repositories (2)

• 4 types
• Local - Held on a local DBMS
• Central - Items to be used / shared
• Secure - Only Admin access (this can be a
  problem)

13
Data Services Designer

• Local installation of Development Environment for
  creating the objects to store in the Repository
• but can be delivered over Citrix or
  Softgrid/AppV
• Fairly simple in look and feel, but actually
  quite complex
• Would anyone like to take a look ?

14
Jobs (1)

• Executable Object
• Jobs usually contain WorkFlows and DataFlows
• 2 types
• Batch Job
• Real-Time Job

15
Jobs (2)

• Batch Job
• Commonly single unit-of-work
• Overnight / Off-peak ETL processing
• Real-Time Job
• Creates a Web service
• Typically 3Flow/2Transform data movement
• Simple operations ONLY please

16
Job Servers

• Actually runs your job (even if youre moving
  data about locally)
• Multiple Job Servers can function as a Server
  Group
• Server Groups share the submitted jobs between
  them, but once a job starts it cant move servers
  (ask me about this)

17
Management Console

• Single point of administration for
• Users
• Job Servers (reporting)
• Repositories
• Browser-based, so requires Apache Tomcat (later
  versions support other web servers like IIS)
• Typically youll have one DSMC per landscape unit

18
(No Transcript)