SAP Business objects DATA SERVICES Getting Started Guide

Data Services Getting Started Guide

BusinessObjects Data Services XI 3.0 (12.0.0)

Copyright

© 2008 Business Objects. All rights reserved. Business Objects owns the following
U.S. patents, which may cover products that are offered and licensed by Business
Objects: 5,555,403; 5,857,205; 6,289,352; 6,247,008; 6,490,593; 6,578,027;
6,831,668; 6,768,986; 6,772,409; 6,882,998; 7,139,766; 7,299,419; 7,194,465;
7,222,130; 7,181,440 and 7,181,435. Business Objects and the Business Objects
logo, BusinessObjects, Business Objects Crystal Vision, Business Process On
Demand, BusinessQuery, Crystal Analysis, Crystal Applications, Crystal Decisions,
Crystal Enterprise, Crystal Insider, Crystal Reports, Desktop Intelligence, Inxight,
the Inxight Logo, LinguistX, Star Tree, Table Lens, ThingFinder, Timewall, Let
there be light, Metify, NSite, Rapid Marts, RapidMarts, the Spectrum Design, Web
Intelligence, Workmail and Xcelsius are trademarks or registered trademarks in
the United States and/or other countries of Business Objects and/or affiliated
companies. All other names mentioned herein may be trademarks of their respective
owners.

Third-party
Contributors

Business Objects products in this release may contain redistributions of software
licensed from third-party contributors. Some of these individual components may
also be available under alternative licenses. A partial listing of third-party
contributors that have requested or permitted acknowledgments, as well as required
notices, can be found at: http://www.businessobjects.com/thirdparty

2008-03-12

Contents

Overview of Data Services 5Chapter 1

Data Services and the Business Objects Product Suite..............................6

Data Services product benefits....................................................................7

Data Services associated products.............................................................8

Data Services interfaces............................................................................10

Data Services Architecture 11Chapter 2

Standard Data Services components........................................................12

Optional Data Services components.........................................................21

Unification with the platform...................................................................7

Ease of use and high productivity..........................................................8

High availability and performance..........................................................8

BusinessObjects Composer...................................................................9

BusinessObjects Metadata Manager.....................................................9

Data Services Designer........................................................................14

Data Services repository......................................................................14

Data Services Job Server.....................................................................15

Data Services engine...........................................................................15

Data Services Access Server...............................................................16

Data Services Address Server.............................................................16

Data Services Administrator.................................................................16

Data Services Metadata Reports applications.....................................17

Data Services Metadata Integrator......................................................19

Data Services Service..........................................................................20

Data Services SNMP Agent.................................................................21

Data Services Adapter SDK.................................................................21

Data Services Getting Started Guide 3

Contents

Data Services Multi-user......................................................................21

Data Services management tools..............................................................22

License Manager..................................................................................22

Repository Manager.............................................................................22

Server Manager....................................................................................22

Data Services operating system platforms................................................23

Data Services distributed architecture.......................................................23

Host names and port numbers.............................................................25

Index 27

4 Data Services Getting Started Guide

Overview of Data Services

1

Overview of Data Services

1

Data Services and the Business Objects Product Suite

About this section

This section introduces Data Services and explains its place in the Business
Objects product suite.

Related Topics

• Data Services and the Business Objects Product Suite on page 6

• Data Services product benefits on page 7

• Data Services interfaces on page 10

Data Services and the Business Objects
Product Suite

The Business Objects product suite delivers extreme insight through
specialized end-user tools on a single, trusted business intelligence platform.
This entire platform is supported by BusinessObjects™ Data Services. On
top of Data Services, Business Objects layers the most reliable, scalable,
flexible, and manageable BI platform which supports the industry's best
integrated end-user interfaces: reporting, query and analysis, and
performance management dashboards, scorecards, and applications.

True data integration blends batch extraction, transformation, and loading
(ETL) technology with real-time bi-directional data flow across multiple
applications for the extended enterprise.

By building a relational datastore and intelligently blending direct real-time
and batch data-access methods to access data from enterprise resource
planning (ERP) systems and other sources, Business Objects has created
a powerful, high-performance data integration product that allows you to fully
leverage your ERP and enterprise application infrastructure for multiple uses.

Business Objects provides a batch and real-time data integration system to
drive today's new generation of analytic and supply-chain management
applications. Using the highly scalable data integration solution provided by
Business Objects, your enterprise can maintain a real-time, on-line dialogue
with customers, suppliers, employees, and partners, providing them with the
critical information they need for transactions and business analysis.

6 Data Services Getting Started Guide

Data Services product benefits

Use Data Services to develop enterprise data integration for batch and
real-time uses. With Data Services:

• You can create a single infrastructure for batch and real-time data

movement to enable faster and lower cost implementation.

• Your enterprise can manage data as a corporate asset independent of

any single system. Integrate data across many systems and reuse that
data for many purposes.

• You have the option of using pre-packaged data solutions for fast

deployment and quick ROI. These solutions extract historical and daily
data from operational systems and cache this data in open relational
databases.

Data Services customizes and manages data access and uniquely combines
industry-leading, patent-pending technologies for delivering data to analytic,
supply-chain management, customer relationship management, and Web
applications.

Overview of Data Services

Data Services product benefits

1

Unification with the platform

Data Services provides several points of platform unification:

• Get end-to-end data lineage and impact analysis

• Create the semantic layer (universe) and manage change within the ETL

design environment

Business Objects deeply integrates the entire ETL process with the business
intelligence platform so you benefit from:

• Easy metadata management

• Simplified and unified administration

• Life cycle management

• Trusted information

Data Services Getting Started Guide 7

Overview of Data Services

1

Data Services associated products

Ease of use and high productivity

Data Services combines both batch and real-time data movement and
management to provide a single data integration platform for information
management from any information source, for any information use.

Using Data Services, you can:

• Stage data in an operational datastore, data warehouse, or data mart.

• Update staged data in batch or real-time modes.

• Create a single graphical development environment for developing, testing,

and deploying the entire data integration platform.

• Manage a single metadata repository to capture the relationships between

different extraction and access methods and provide integrated lineage
and impact analysis.

High availability and performance

Data Services' high-performance engine and proven data movement and
management capabilities include:

• Scalable, multi-instance data-movement for fast execution

• Load balancing

• Changed-data capture

• Parallel processing

Data Services associated products

Choose from several Business Objects product options to further support
and enhance the power of your Data Services product.

8 Data Services Getting Started Guide

BusinessObjects Composer

Even before you start a data warehouse implementation, Business Objects
knows that you need to collect and organize critical data from information
users to "compose" a blueprint from which you can start to build your Data
Services jobs.

The BusinessObjects Composer is a stand-alone, web-based application for
designing extraction, transformation, and loading (ETL) projects.

Developing higher-level designs for your ETL jobs can make the
implementation process more efficient and improve the quality of resulting
jobs. Composer complements other ETL tools, providing a platform for
creating your design even before you start to build your data warehouse.
Use Composer to identify sources of data, implement transformations, and
document your designs.

For more information on BusinessObjects Composer, contact your Business
Objects sales representative.

Overview of Data Services

Data Services associated products

1

BusinessObjects Metadata Manager

Business Objects™ Metadata Manager provides an integrated view of
metadata and its multiple relationships for an complete Business Intelligence
project spanning some or all of the Business Objects stack of products. Use
Metadata Manager to:

• View metadata about Business Objects Reports, Documents, and data

sources from a single repository.

• Analyze lineage to determine data sources of Business Objects

Documents and Reports.

• Analyze the impact of changing a source table, column, element, or field

on existing Business Objects Documents and Reports.

• Track different versions (changes) to each object over time.

• View operational metadata (such as the number of rows processed and

CPU utilization) as historical data with a datetime.

• View metadata in different languages.

Data Services Getting Started Guide 9