PUBLIC
SAP Data Services
Document Version: 4.3 (14.3.00.00)–2024-03-08
Supplement for Siebel
© 2024 SAP SE or an SAP aliate company. All rights reserved.
THE BEST RUN 
Content
1 Overview of the SAP Data Services Siebel interface..................................3
2 System requirements.........................................................4
2.1 Security....................................................................4
3 Datastores.................................................................5
3.1 Dening a Siebel datastore......................................................5
3.2 Browsing and importing metadata.................................................5
Table - by type.............................................................6
3.3 Extracting data from Siebel applications.............................................7
2
PUBLIC
Supplement for Siebel
Content
1 Overview of the SAP Data Services Siebel
interface
The Data Services Siebel interface allows you to create Siebel datastores and import tables for use as sources
in Data Services jobs. With this interface, you can use the 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
Related Information
Browsing and importing metadata [page 5]
Supplement for Siebel
Overview of the SAP Data Services Siebel interface
PUBLIC 3
2 System requirements
The Siebel interface allows you to connect SAP Data Services with a third-party database under the Siebel
application layer. You can import tables (including table and column descriptions) and function metadata. Data
Services also displays information from both the logical business objects and user interface layers of Siebel
applications. This makes it easier to nd and import tables.
Siebel Architecture
Install the drivers you need to connect your database with Data Services on the same computers on which you
install the Designer and Job Server components.
The Siebel interface supports Siebel version 7.5.2 and higher compatible versions. It can be installed using the
Data Services installer.
2.1 Security
Because SAP Data Services connects to Siebel applications through a database connection, Data Services can
see all Siebel application objects that a database user can access without requiring the application's user login
security information.
4
PUBLIC
Supplement for Siebel
System requirements
3 Datastores
SAP Data Services uses datastore connections to link with other applications or databases.
• 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 Services uses datastore information to move data between source and
target databases and applications.
After dening a Siebel datastore in Data Services, you can browse tables by type, or drill down on business
components or Siebel repositories to nd the tables you want to import. You can also import tables, functions,
and business components by name.
3.1 Dening a Siebel datastore
With a Siebel datastore connection, you can browse Siebel application metadata.
1. In the object library of the 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 Datastore type list, select Siebel.
5. Enter the connection information.
6. Click OK.
The Siebel datastore appears in the object library.
3.2 Browsing and importing metadata
After you create 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.
1. Right-click the Siebel datastore name and select Open, or double-click the datastore name.
The workspace displays a list of folders.
2. To nd the tables you want to import, expand the Table by type, Business Component, or Repository folder.
See the remainder of this section for a description of these folders.
3. To import table data, right-click one or more tables or business components and select Import.
Supplement for Siebel
Datastores
PUBLIC 5
Note
When you import a table into SAP Data Services via the Siebel interface, the software does not
preserve the source folder (table hierarchy). All tables display 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.
You can also import Siebel metadata by right-clicking a Siebel datastore in the object library and selecting
Import by name.
Once tables are imported, you can view column names, data types, and business names for use in creating
jobs.
3.2.1Table - by type
Siebel applications use many table types. You can browse tables by looking at tables grouped by type.
3.2.1.1 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.
You can select and import one or more business components or tables.
3.2.1.2 Repository
Siebel repositories hold a variety of Siebel application objects. You can drill through them to nd the tables you
want to import.
These associations apply:
• Seibel Repository: Repository
• Seibel Dynamic Commerce: Application
• Auctions: Screen
• Auction Items: View
• Auction Services: Business Object
• Auction Item Detail: Business Component
6
PUBLIC
Supplement for Siebel
Datastores
3.3 Extracting data from Siebel applications
When extracting data from Siebel applications, SAP Data Services processes and converts data types
appropriately.
Supplement for Siebel
Datastores
PUBLIC 7
Important Disclaimers and Legal Information
Hyperlinks
Some links are classied by an icon and/or a mouseover text. These links provide additional information.
About the icons:
• Links with the icon
: You are entering a Web site that is not hosted by SAP. By using such links, you agree (unless expressly stated otherwise in your
agreements with SAP) to this:
• The content of the linked-to site is not SAP documentation. You may not infer any product claims against SAP based on this information.
• SAP does not agree or disagree with the content on the linked-to site, nor does SAP warrant the availability and correctness. SAP shall not be liable for any
damages caused by the use of such content unless damages have been caused by SAP's gross negligence or willful misconduct.
• Links with the icon : You are leaving the documentation for that particular SAP product or service and are entering an SAP-hosted Web site. By using
such links, you agree that (unless expressly stated otherwise in your agreements with SAP) you may not infer any product claims against SAP based on this
information.
Videos Hosted on External Platforms
Some videos may point to third-party video hosting platforms. SAP cannot guarantee the future availability of videos stored on these platforms. Furthermore, any
advertisements or other content hosted on these platforms (for example, suggested videos or by navigating to other videos hosted on the same site), are not within
the control or responsibility of SAP.
Beta and Other Experimental Features
Experimental features are not part of the ocially delivered scope that SAP guarantees for future releases. This means that experimental features may be changed by
SAP at any time for any reason without notice. Experimental features are not for productive use. You may not demonstrate, test, examine, evaluate or otherwise use
the experimental features in a live operating environment or with data that has not been suciently backed up.
The purpose of experimental features is to get feedback early on, allowing customers and partners to inuence the future product accordingly. By providing your
feedback (e.g. in the SAP Community), you accept that intellectual property rights of the contributions or derivative works shall remain the exclusive property of SAP.
Example Code
Any software coding and/or code snippets are examples. They are not for productive use. The example code is only intended to better explain and visualize the syntax
and phrasing rules. SAP does not warrant the correctness and completeness of the example code. SAP shall not be liable for errors or damages caused by the use of
example code unless damages have been caused by SAP's gross negligence or willful misconduct.
Bias-Free Language
SAP supports a culture of diversity and inclusion. Whenever possible, we use unbiased language in our documentation to refer to people of all cultures, ethnicities,
genders, and abilities.
8
PUBLIC
Supplement for Siebel
Important Disclaimers and Legal Information
Supplement for Siebel
Important Disclaimers and Legal Information
PUBLIC 9
www.sap.com/contactsap
© 2024 SAP SE or an SAP aliate company. All rights reserved.
No part of this publication may be reproduced or transmitted in any form
or for any purpose without the express permission of SAP SE or an SAP
aliate company. The information contained herein may be changed
without prior notice.
Some software products marketed by SAP SE and its distributors
contain proprietary software components of other software vendors.
National product specications may vary.
These materials are provided by SAP SE or an SAP aliate company for
informational purposes only, without representation or warranty of any
kind, and SAP or its aliated companies shall not be liable for errors or
omissions with respect to the materials. The only warranties for SAP or
SAP aliate company products and services are those that are set forth
in the express warranty statements accompanying such products and
services, if any. Nothing herein should be construed as constituting an
additional warranty.
SAP and other SAP products and services mentioned herein as well as
their respective logos are trademarks or registered trademarks of SAP
SE (or an SAP aliate company) in Germany and other countries. All
other product and service names mentioned are the trademarks of their
respective companies.
Please see https://www.sap.com/about/legal/trademark.html for
additional trademark information and notices.
THE BEST RUN 