Data Integrator Supplement for Siebel
Data Integrator Supplement for Siebel
Data Integrator 11.7.2
for Windows and UNIX
1
Patents
Trademarks
Copyright
Third-party
contributors
Date
Business Objects owns the following U.S. patents, which may cover products that are offered
and sold by Business Objects: 5,555,403, 6,247,008 B1, 6,578,027 B2, 6,490,593 and
6,289,352.
Business Objects owns the following U.S. patents, which may cover products that are offered
and licensed by Business Objects: 5,555,403; 6,247.008 B1; 6,578,027 B2; 6,490,593; and
6,289,352. Business Objects and the Business Objects logo, BusinessObjects, Crystal
Reports, Crystal Xcelsius, Crystal Decisions, Intelligent Question, Desktop Intelligence,
Crystal Enterprise, Crystal Analysis, WebIntelligence, RapidMarts, and BusinessQuery are
trademarks or registered trademarks of Business Objects in the United States and/or other
countries. All other names mentioned herein may be trademarks of their respective owners.
© 2007 Business Objects. All rights reserved.
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
March 23, 2007
2 Data Integrator Supplement for Siebel
Contents
Chapter 1 Siebel Interface 5
More Data Integrator product documentation . . . . . . . . . . . . . . . . . . . . . . . 6
System requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
Datastores . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
Defining a Siebel datastore . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
Browsing and importing metadata . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
Extracting data from Siebel applications . . . . . . . . . . . . . . . . . . . . . . . 13
Index 15
Data Integrator Supplement for Siebel 3
Contents
4 Data Integrator Supplement for Siebel
Data Integrator Supplement for Siebel
Siebel Interface
chapter
Siebel Interface
1
Overview of the Data Integrator Siebel interface
Overview of the Data Integrator Siebel
interface
The Data Integrator Siebel interface allows you to create Siebel datastores
and import tables for use as sources in Data Integrator jobs. With this
interface, you can use the Data Integrator Designer to:
• Browse and import Siebel tables grouped by type, business component,
and Siebel repository
• Browse to tables in a Siebel repository using the following path through
higher level data: applications > screens > views > business objects >
business components > tables.
• Import function metadata
This guide contains the following topics:
• More Data Integrator product documentation
• System requirements
• Datastores
More Data Integrator product documentation
Consult the Data Integrator Getting Started Guide for:
• An overview of Data Integrator products and architecture
• Data Integrator installation and configuration information
• A list of product documentation and a suggested reading path
After you install Data Integrator (with associated documentation), you can
view the technical documentation from several locations. To view
documentation in PDF format:
• If you accepted the default installation, select Start > Programs >
Business Objects
and select:
• Release Notes—Opens this document, which includes known and
fixed bugs, migration considerations, and last-minute documentation
corrections
• Release Summary—Opens the Release Summary PDF, which
describes the latest Data Integrator features
6 Data Integrator Supplement for Siebel
> Dat a Integrator > Data Integrator Document ation
Siebel Interface
System requirements
• Technical Manuals—Opens a “master” PDF document that has
been compiled so you can search across the Data Integrator
documentation suite
• Tutorial—Opens the Data Integrator Tutorial PDF, which you can
use for basic stand-alone training purposes
• Select one of the following from the Designer’s Help menu:
• Release Notes
• Release Summary
• Technical Manuals
• Tutorial
Other links from the Designer’s Help menu include:
• DIZone—Opens a browser window to the DI Zone, an online resource for
the Data Integrator user community)
• Knowledge Base—Opens a browser window to Business Objects’
Technical Support Knowledge Exchange forum (access requires
registration)
You can also view and downloa d PDF docu me ntation, including Data
Integrator documentation for previous releases (in cluding Release Summa ries
and Release Notes), by visiti ng the Busine ss Object s document ation W eb sit e
at http://support.businessobjects.com/documentation/.
1
System requirements
The Siebel interface allows you to connect Data Integrator with a third-party
database under the Siebel application layer. You can import tables (including
table and column descriptions) and function metadata. Data Integrator also
displays information from both the logical business objects and user interface
layers of Siebel applications. This makes it easier to find and import tables.
Data Integrator Supplement for Siebel 7
Siebel Interface
1
Datastores
Figure 1-1 :Siebel Architecture
Physical User Interface Layer
User Interface Objects Layer
Siebel Application
Business Objects Layer
Data Objects Layer
Security
DBMS
Third-party
database vendor
MS SQL Server is the only database that the Siebel interface supports.
Install the drivers you need to connect MS SQL Server with Data Integrator on
the same computers on which you install the Data Integrator Designer and
Job Server components. See “System requirements” on page 39 of the Data
Integrator Getting Started Guide for general information about Windows
software and hardware requirements.
The Siebel interface supports Siebel version 7.5.2 and higher compatible
versions. It can be installed using the Data Integrator installer. The interface is
license-controlled. For more information about licence-controlled interfaces
for Data Integrator, see “Optional license-controlled features” on page 53 of
the Data Integrator Getting Started Guide.
Because Data Integrator connects to Siebel applications through a database
connection, Data Integrator can see all Siebel application objects that the
provided MS SQL Server database user can access without requiring the
application’s user login security information.
Datastores
Data Integrator uses datastore connections to link with other applications or
databases.
8 Data Integrator Supplement for Siebel
• In a design environment, use a datastore to browse or import metadata
that represents external tables and other database objects.
• In a production environment, Data Integrator uses datastore information
to move data between source and target databases and applications.
After defining a Siebel datastore in Data Integrator, you can browse tables by
type, or drill down on business components or Siebel repositories to find the
tables you want to import. Y ou can also import t ables, functions, and business
components by name.
This section discusses:
• Defining a Siebel datastore
• Browsing and importing metadata
• Extracting data from Siebel applications
Defining a Siebel datastore
With a Siebel datastore connection, you can browse Siebel application
metadata.
To define a Siebel datastore
1. In the object library of the Dat a Integrator Designer, go to the Datastores
tab
2. Right-click inside the object library window and select New.
3. In the Datastore Editor window, enter a name for this datastore
(
DS_SiebelApps, for example).
4. In the Application type list, select Siebel.
5. Enter the connection information.
See “Database datastores” on page 63 of the Data Integrator Reference
Guide for MS SQL Server connection options and descriptions.
6. Click OK.
The Siebel datastore appears in the object library.
Siebel Interface
Datastores
1
Browsing and importing metadata
After creating a Siebel datastore, you can browse and import the metadata
from the connected application.
Note: While you cannot browse functions, you can import them by name.
Data Integrator Supplement for Siebel 9
Siebel Interface
1
Datastores
T o browse and import the metadata
1. View the three ways data is grouped and displayed in Siebel. You can:
• Right-click the Siebel datastore name and select Open, or
• Double-click the datastore name
The workspace displays the list of directories.
2. To find the tables you want to import, expand a table type, business
component, or repository folder.
• Table type
Siebel applications use many table types. You can browse tables by
looking at tables grouped by type.
• Business component
Business components are sets of tables used to create a logical Siebel
application object called a business object. Business components are
grouped in alphabetical folders.
10 Data Integrator Supplement for Siebel
Siebel Interface
Datastores
You can select and import one or more business components or tables.
1
Data Integrator Supplement for Siebel 11
Siebel Interface
1
Datastores
• Repository
Siebel repositories hold a variety of Siebel application objects. You
can drill through them to find the tables you want to import.
Repository
Application
Screen
View
Business Object
Business Component
3. To import table data, right-click one or more tables or business
components and select Import.
Note: When you import a table into Data Integrator via the Siebel
interface, the source folder (table hierarchy) is not preserved. All tables
are listed at the same level. For example, import all the tables in a
business component then add select statements, joins, and mappings
using the Designer to create the same associations used in your Siebel
application.
Y ou can also import Siebel metadat a by right-clicking a Siebel datastore in the
object library and selecting Import by name.
12 Data Integrator Supplement for Siebel
Siebel Interface
Datastores
Once tables are imported, you can view column names, data types, and
business names for use in creating jobs.
1
Extracting data from Siebel applications
When extracting data from Siebel applications, Data Integrator processes and
converts data types appropriately. For data type conversion details, see “Data
type processing” on page 251 of the Data Integrator Reference Guide.
Data Integrator Supplement for Siebel 13
Siebel Interface
1
Datastores
14 Data Integrator Supplement for Siebel
Index
A
application user login security 8
D
datastore
Siebel 8–9
H
hardware and software requirements 8
I
importing metadata 7
S
security
login information 8
Siebel architecture 7
Siebel datastore 9
V
version support 8
Data Integrator Supplement for Siebel 15
Index
16 Data Integrator Supplement for Siebel
Loading...