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
Data Services XI Release 3 provides data integration and data quality
processes in one runtime environment, delivering enterprise performance
and scalability.
The data integration processes of Data Services allow organizations to easily
explore, extract, transform, and deliver any type of data anywhere across
the enterprise.
The data quality processes of Data Services allow organizations to easily
standardize, cleanse, and consolidate data anywhere, ensuring that end-users
are always working with information that's readily available, accurate, and
trusted.
Documentation set for Data Services
You should become familiar with all the pieces of documentation that relate
to your Data Services product.
Documentation Map
Release Summary
Release Notes
Getting Started Guide
Installation Guide for Windows
Installation Guide for UNIX
8Data Services Integrator's Guide
What this document providesDocument
Information about available Data Services books,
languages, and locations
Highlights of key features in this Data Services release
Important information you need before installing and
deploying this version of Data Services
An introduction to Data Services
Information about and procedures for installing Data
Services in a Windows environment.
Information about and procedures for installing Data
Services in a UNIX environment.
Advanced Development Guide
Welcome to Data Services
Documentation set for Data Services
What this document providesDocument
Guidelines and options for migrating applications including information on multi-user functionality and
the use of the central repository for version control
1
Designer Guide
Integrator's Guide
Management Console: Administrator
Guide
Management Console: Metadata Reports Guide
Migration Considerations Guide
Performance Optimization Guide
Reference Guide
Information about how to use Data Services Designer
Information for third-party developers to access Data
Services functionality. Also provides information about
how to install, configure, and use the Data Services
Adapter for JMS.
Information about how to use Data Services Administrator
Information about how to use Data Services Metadata
Reports
Information about:
•Release-specific product behavior changes from
earlier versions of Data Services to the latest release
•How to migrate from Data Quality to Data Services
Information about how to improve the performance
of Data Services
Detailed reference material for Data Services Designer
Data Services Integrator's Guide9
Welcome to Data Services
1
Documentation set for Data Services
Technical Manuals
What this document providesDocument
A compiled “master” PDF of core Data Services books
containing a searchable master table of contents and
index:
•
Getting Started Guide
•
Installation Guide for Windows
•
Installation Guide for UNIX
•
Designer Guide
•
Reference Guide
•
Management Console: Metadata Reports Guide
•
Management Console: Administrator Guide
•
Performance Optimization Guide
•
Advanced Development Guide
•
Supplement for J.D. Edwards
•
Supplement for Oracle Applications
•
Supplement for PeopleSoft
•
Supplement for Siebel
•
Supplement for SAP
Tutorial
In addition, you may need to refer to several Adapter Guides and
Supplemental Guides.
What this document providesDocument
Salesforce.com Adapter
Interface
Supplement for J.D. Edwards
Supplement for Oracle Applications
Supplement for PeopleSoft
10Data Services Integrator's Guide
Information about how to install, configure, and use the Data
Services Salesforce.com Adapter Interface
Information about license-controlled interfaces between Data
Services and J.D. Edwards World and J.D. Edwards OneWorld
Information about the license-controlled interface between Data
Services and Oracle Applications
Information about license-controlled interfaces between Data
Services and PeopleSoft
A step-by-step introduction to using Data Services
Welcome to Data Services
Accessing documentation
What this document providesDocument
1
Supplement for SAP
Supplement for Siebel
Information about license-controlled interfaces between Data
Services, SAP ERP, and SAP BI/BW
Information about the license-controlled interface between Data
Services and Siebel
Accessing documentation
You can access the complete documentation set for Data Services in several
places.
Accessing documentation on Windows
After you install Data Services, you can access the documentation from the
Start menu.
1. Choose Start > Programs > BusinessObjects XI 3.1 >
BusinessObjects Data Services > Data Services Documentation.
Note:
Only a subset of the documentation is available from the Start menu. The
documentation set for this release is available in LINK_DIR\Doc\Books\en.
2. Click the appropriate shortcut for the document that you want to view.
Accessing documentation on UNIX
After you install Data Services, you can access the online documentation by
going to the directory where the printable PDF files were installed.
1. Go to LINK_DIR/doc/book/en/.
2. Using Adobe Reader, open the PDF file of the document that you want
to view.
Data Services Integrator's Guide11
Welcome to Data Services
1
Business Objects information resources
Accessing documentation from the Web
You can access the complete documentation set for Data Services from the
Business Objects Customer Support site.
1.
Go to http://help.sap.com.
2. Cick Business Objects at the top of the page.
You can view the PDFs online or save them to your computer.
Business Objects information resources
A global network of Business Objects technology experts provides customer
support, education, and consulting to ensure maximum business intelligence
benefit to your business.
Useful addresses at a glance:
ContentAddress
12Data Services Integrator's Guide
Welcome to Data Services
Business Objects information resources
ContentAddress
1
Customer Support, Consulting, and Education
services
Information about Customer Support programs,
as well as links to technical articles, downloads,
and online forums. Consulting services can
provide you with information about how Business Objects can help maximize your business
intelligence investment. Education services can
provide information about training options and
modules. From traditional classroom learning
to targeted e-learning seminars, Business Objects can offer a training package to suit your
learning needs and preferred learning style.
Get online and timely information about Data
Services, including tips and tricks, additional
downloads, samples, and much more. All content is to and from the community, so feel free
to join in and contact us if you have a submission.
Search the Business Objects forums on the
SAP Community Network to learn from other
Data Services users and start posting questions
or share your knowledge with the community.
Blueprints for you to download and modify to fit
your needs. Each blueprint contains the necessary Data Services project, jobs, data flows, file
formats, sample data, template tables, and
custom functions to run the data flows in your
environment with only a few modifications.
Data Services Integrator's Guide13
Welcome to Data Services
1
Business Objects information resources
http://help.sap.com/
ContentAddress
Business Objects product documentation.Product documentation
Documentation mailbox
documentation@businessobjects.com
Supported platforms documentation
https://service.sap.com/bosap-support
Send us feedback or questions about your
Business Objects documentation. Do you have
a suggestion on how we can improve our documentation? Is there something that you particularly like or have found useful? Let us know,
and we will do our best to ensure that your
suggestion is considered for the next release
of our documentation.
Note:
If your issue concerns a Business Objects
product and not the documentation, please
contact our Customer Support experts.
Get information about supported platforms for
Data Services.
In the left panel of the window, navigate to
Documentation > Supported Platforms >
BusinessObjects XI 3.1. Click the BusinessObjects Data Services link in the main window.
14Data Services Integrator's Guide
Web service support
2
Web service support
2
Overview
Overview
This section discusses both how an administrator can configure Data Services
through the Administrator to publish Data Services jobs as callable web
services, and how an application developer can access those web services.
Data Services publishes web services from the Data Services Management
Console Administrator. To use Data Services as a web service, select the
Web Services node in the Administrator's navigation tree. For general
information on using the Administrator, see the Data Services ManagementConsole: Administrator Guide.
Web services are modular business applications based on open standards
(WSDL, SOAP, and XML Schema primarily) that allow integration among
different applications and environments through the Internet. Web services
allow parts of existing applications to be used by other applications.
For business intelligence (BI), you can use Web services to accomplish the
following:
•Access legacy systems
•Conduct computer-to-computer interaction over an internal or external
Web
•Allow applications constructed in different languages on different platforms
to communicate with each other in an enterprise environment
BusinessObjects Data Services can:
•Publish any job as a callable web service (server functionality)
•Call published web services from within its jobs using the built-in Web
Services Adapter (client functionality)
If you have an application that also supports web services, you can use that
application to run Data Services batch and real-time jobs or to publish your
application's functionality to be called by Data Services data flows.
After you install Data Services, you can immediately start working with its
client functionality because the built-in Web Services Adapter is a web
services client that provides access to a web services server from a Data
Services data flow.
Related Topics
•Using Data Services as a web service provider on page 21
16Data Services Integrator's Guide
•Consuming external web services in Data Services on page 61
Web services technologies
Data Services web services are fully compliant with Web Services
Interoperabilty (WS-I) Basic Profile 1.0, and support three Java Web Services
technologies.
DescriptionWeb service tech-
nology
Connection protocol (envelope for XML messages)SOAP
Web service support
Web services technologies
2
SOAP
WSDL
Data Services supports SOAP 1.1, WSDL version 1.1 or 2.0, and Apache
Axis 1.1 (an industry-standard SOAP message handler and WSDL parser).
Data Services is also compliant with the Microsoft .NET environment for Web
services. You can import the WSDL that Data Services generates into Visual
Studio .NET and the Data Services Web Services Adapter can call the WSDL
that Visual Studio .Net generates.
Note:
Data Services does not support the Representational State Transfer (REST)
web services architecture or the JSON message format.
Data Services allows you to invoke real-time services using the following:
•Message Client API (which supports C++ and Java connections)
•TCP/IP
•proprietary XML using HTTP
Language used to request a service and return replies
(subset of XML)
Format used for the WSDL fileXML Schema
In addition, Data Services supports the Simple Object Access Protocol
(SOAP). SOAP is the industry standard from the World Wide Web Consortium
(WC3.org) used to invoke network resources using XML over HTTP, HTTPS,
and other standard protocols.
Data Services Integrator's Guide17
Web service support
2
Web services technologies
WSDL
A SOAP gateway is built in to the Data Services Administrator. Data Services
supports SOAP over HTTP and HTTPS protocols.
Web Services Description Language (WSDL) is a subset of XML. It is used
as a transport mechanism for XML messages. Data Services publishes its
jobs in WSDL based on configuration settings applied in the Administrator,
and then developers can create a web services client based on the Data
Services WSDL.
Data Services also publishes all comments entered into the Designer's JobDescriptions box with each job that is added to the WSDL file.
The WSDL file generated by Data Services includes tags (such as services,
bindings, ports, and operations) that support the use of the SOAP protocol.
Each tag uses a name that Data Services provides. For example:
•You select which Data Services jobs to publish in the web service named
DataServices_server. In WSDL, a service is a set of business operations
with connection endpoints.
•Binding names include Connection_Operations, Batch_Jobs, Real-
time_Services, and Batch_Job_Admin. WSDL uses bindings to associate
operations with ports.
•Operation names have a one-to-one relationship with the names of Data
Services batch jobs or real-time services.
XML Schema
WSDL uses XML Schemas to define input and output message formats.
•For server functionality, if a real-time service was defined with DTDs, you
will need to translate the DTD format into the XML Schema format.
•For client functionality, the Web Services Adapter imports metadata into
Data Services using the XML Schema format only.
XML Schema formats are defined in the types element of the WSDL file.
18Data Services Integrator's Guide
UDDI
Web service support
Web services technologies
UDDI is a method of publishing comments and other reference information
about jobs to an external web site. Data Services does not publish information
to a UDDI web site because most Data Services web services users work
behind enterprise firewalls.
2
Data Services Integrator's Guide19
Web service support
Web services technologies
2
20Data Services Integrator's Guide
Using Data Services as a
web service provider
3
Using Data Services as a web service provider
3
WSDL basics
After the Administrator publishes batch or real-time jobs as web services,
the web application hosts those web services. When an external application
calls into Data Services through web services, the application acts as a web
services client accessing a web services server.
Web service clients call the published web services, pass in the appropriate
parameters, and receive the results. Data Services routes calls to the
appropriate Data Services Job Server and job for processing.
Web services might be used in the following example scenarios:
•Dynamically update an internal web site
Suppose you have an internal web site that manages foreign exchange
rate status worldwide for the Finance department. When foreign exchange
rates change more than a certain percentage, a batch Data Services job
updates exchange rates in your financial data mart. The rate change
initiates a call to a Data Services-hosted Web service that starts the
appropriate batch ETL job.
•Solve a processing issue
Suppose you have an existing Enterprise Application Integration (EAI)
bus infrastructure and want to manage batch processes and EAI
transactional processes from within the same infrastructure. The
transactional processes are complex. Their staging is laid out in the order
process. However, EAI work flows do not have the ability to run batch
processes.
22Data Services Integrator's Guide
Data Services can publish Web services that allow you to leverage EAI
process management category tools (for example, webMethods Business
Process Manager) to control and stage batch processes alongside its
transactional processes.
The work flows might call Data Services to:
•Perform an initial load of a data mart for real-time reporting
•Refresh the data cache depending on specified business criteria
•Perform complex transforms on hierarchical objects for mapping data
between ERP systems
WSDL basics
WSDL is a subset of XML that you can use to describe network services as
a collection of endpoints capable of exchanging messages.
This table shows the elements in a WSDL file, and describes how those
elements are used in the Data Services-generated WSDL file.
Using Data Services as a web service provider
WSDL basics
3
service
DescriptionElement Name
Root elementdefinition
Used to group a set of related ports or endpoints
to which a client application will connect. Data
Services publishes a single service in the WSDL
file it generates.
Data Services Integrator's Guide23
Using Data Services as a web service provider
3
WSDL basics
port
portType
DescriptionElement Name
Defines a specific Web service endpoint that a
client can access. Each port has a unique name
and a specific address used for binding. Data Services defines ports for Web services as:
•Connection_Operations: used for authentication
and ping
•Real-time_Services: used for real-time jobs
exposed as Web services
•Batch_Jobs: used for batch jobs exposed as Web
services (each batch jobs has its own operation)
•Batch_Job_Admin: used for administrative oper-
ations for batch jobs
Defines a set of operations that a Web service
publishes.
A portType is bound to a particular port. The binding
specifies the protocol and data formation for the
operations defined by a portType.
operation
message
type
24Data Services Integrator's Guide
Defines a specific function call. Data Services
publishes each batch job and real-time service as
an operation. Data Services also publishes connection operations.
Defines the data to transmit. There is an input (request) message, which the Web service receives
from the client, and there is an output (response)
message, which the Web service sends back to
the client.
Defines the data types used in messages sent
to/from a Web service.
Using Data Services as a web service provider
WSDL basics
Related Topics
•SoapAction element on page 48
Building a WSDL file
Use the information in the WSDL file produced by Data Services to create
an application that can access Data Services batch jobs and real-time
services. Access the WSDL file by making web service client calls to it using
a reference URL.
To view the WSDL file so that you can create your application, use the WebServices node of the Data Services Management Console Administrator,
or open a browser window and search for:
To configure web service information using the Administrator
1. Open Data Services Administrator.
2. Log in with Administrator-level privileges. Users with Monitor-level
privileges cannot configure web services.
3
Note:
If you enable security for the WSDL file, Data Services requires that web
services clients use the user name and password of any user with
Administrator-level privileges to access all published web services.
3. Add connections from Access Servers and repositories to view jobs in
the Administrator.
4. If you plan to publish real-time jobs as web services, configure real-time
jobs as real-time services.
Data Services publishes the following as web services:
•Real-time services enabled as web service operations in the
Administrator
•Batch jobs enabled as web service operations in the Administrator
•Connection Operations
•Ping - Used to ping Web services
•Logon and Logout - Security operations that provide controlled
access to Web service operations (if enabled).
Data Services Integrator's Guide25
Using Data Services as a web service provider
3
WSDL basics
5. In the Administrator's navigation tree, select Web Services.
The "Web Services Status" page opens. This page lists Web service
operations that are published in the WSDL. By default, only the Ping
operation is automatically published.
6. Click the Web Services Configuration tab.
Use the Configuration tab to open the "Web Services Configuration"
page. Use this page to select jobs and real-time services to be published,
enable/disable security for the WSDL file, and to enable/disable access
to full batch job attributes.
7. From the pull-down menu, use Add Real-time Service or Add Batch
Job to add jobs or services to the WSDL, and click Apply.
On the "Add Real-time Service" page, real-time services are grouped by
the Access Server for which the service is configured. To add a real-time
service to the WSDL, select an Access Server or select All, select the
check box in front of a real-time service name, and click Add.
On the "Add Batch Job" page, jobs are grouped by the repository on
which the job is stored. To add a job to the WSDL, select a repository or
select All, select the check box in front of a job name, and click Add.
8. (Optional) On the "Web Services Configuration" page, select Enable
Session Securty and click Apply to enable security for the WSDL.
Security for published operations is disabled by default.
With security enabled, instead of making a single call to the Administrator
to start a batch job or trigger a real-time service from an external
application, clients must make at least three calls:
•The first call logs in to the Administrator and gets a session ID.
•The second call accesses a job or service using the session ID as an
input parameter. Create a call for each job or service you want to
access.
•The final call logs out of the session.
9. (Optional) On the "Web Services Configuration" page, from the drop-down
menu, select Enable Job Attributes to allow the input message for all
the batch jobs you publish to include all options supported for submitting
batch jobs from the Administrator. The following table lists elements added
to the message:
26Data Services Integrator's Guide
Using Data Services as a web service provider
WSDL basics
DescriptionElement
System profile used to run the job.job_system_profile
Monitor sample rate (# of rows).sampling_rate
Enable auditing (true or false).auditing
Enable recovery (true or false).recovery
Job Server or Server Group.job_server
3
Data Services Integrator's Guide27
Using Data Services as a web service provider
3
WSDL basics
trace
DescriptionElement
Trace option to be enabled. You must specify an option to
enable tracing. This element can be repeated for as many
trace options as you require.
The WSDL defines values for the trace option and includes the following (all options on the batch job submit
page of the administrator):
•job_trace_all
•job_trace_row
•job_trace_session
•job_trace_workflow
•job_trace_dataflow
•job_trace_transform
•job_trace_usertransform
•job_trace_userfunction
•job_trace_abapquery
•job_trace_sqlfunctions
•job_trace_sqlreaders
•job_trace_sqlloaders
•job_trace_optimized_dataflow
•job_trace_table
•job_trace_script
•job_trace_ascomm
•job_trace_rfc_function
•job_trace_table_reader
•job_trace_idoc_file
•job_trace_adapter
•job_trace_communication
•job_trace_parallel_execution
•job_trace_audit
28Data Services Integrator's Guide
distribution_level
10. Navigate back to the "Web Services Status" page, choose the WSDL
Using Data Services as a web service provider
WSDL basics
DescriptionElement
You can distribute the execution of a job or a part of a job
across multiple Job Servers within a Server Group to better
balance resource-intensive operations.
You can specify the following values on the distribution
level option when you execute a job:
•Job: A job can execute on an available Job Server.
•Data flow: Each data flow within a job can execute on
an available Job Server.
•Sub data flow: An resource-intensive operation (such
as a sort, table comparison, or table lookup) within a
data flow can execute on an available Job Server.
Note:
Casing and spacing are important for these values.
version you want to create, and click View WSDL.
A new browser window opens with the WSDL displayed. Use the
information in this file to perform the following:
•Confirm that Data Services updated the WSDL file with all jobs and
services without error.
•Create calls to Data Services
3
Use the information in the WSDL file to configure your application to
access Data Services batch jobs and real-time services.
To ensure that your application calls the latest version of the job,
update the WSDL when the metadata imported into Data Services
changes for a job or real-time service by removing then re-adding a
job or service from the "Web Services Configuration" page.
11. After your web service clients are accessing Data Services jobs, you can
monitor the status of web service operations on the server by viewing the
data on the "Web Services Status" page.
Data Services Integrator's Guide29
Using Data Services as a web service provider
3
WSDL basics
Web Services Port
Repository/ Access Server
DescriptionColumn name
Same as job or real-time service name.Operation Name
For jobs, the port name is Batch_jobs.
For services, the port name is RealTime_Service.
For built-in operations, the port name is
Connection_Operations.
For administrative operations for batch
jobs, the port name is Batch_Job_Admin.
For jobs, the repository name.
For services, the Access Server name.
Job Information
Requests Processed
Requests Failed
Requests Pending
30Data Services Integrator's Guide
For jobs, a link to the Batch Job History
page.
For services, a link to the Real-time Services History page.
Number of client requests successfully
processed.
Number of client requests that failed
somewhere between the time that the
Web Server receives the request and the
Job Server receives it.
Number of requests in a queue for Job
Server.
Loading...
+ 102 hidden pages
You need points to download manuals.
1 point = 1 manual.
You can buy points or you can get point for every manual you upload.