SAP Business objects DATA SERVICES Management Console Guide
Management Console Guide
■ SAP BusinessObjects Data Services XI 4.0 (14.0.0)
2010-12-02
Copyright
© 2010 SAP AG. All rights reserved.SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP
Business ByDesign, and other SAP products and services mentioned herein as well as their respective
logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Business
Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web
Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well
as their respective logos are trademarks or registered trademarks of Business Objects S.A. in the
United States and in other countries. Business Objects is an SAP company.All other product and
service names mentioned are the trademarks of their respective companies. Data contained in this
document serves informational purposes only. National product specifications may vary.These materials
are subject to change without notice. These materials are provided by SAP AG and its affiliated
companies ("SAP Group") for informational purposes only, without representation or warranty of any
kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The
only warranties for SAP Group 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.
2010-12-02
Contents
Introduction.............................................................................................................................9Chapter 1
1.1
1.1.1
1.1.2
1.1.3
1.1.4
1.2
1.2.1
1.2.2
2.1
3.1
3.1.1
3.1.2
3.2
3.2.1
3.2.2
3.2.3
3.2.4
3.2.5
3.3
3.3.1
3.3.2
3.4
3.4.1
3.4.2
3.4.3
3.4.4
3.5
Welcome to SAP BusinessObjects Data Services...................................................................9
Welcome.................................................................................................................................9
Documentation set for SAP BusinessObjects Data Services...................................................9
Accessing documentation......................................................................................................12
SAP BusinessObjects information resources.........................................................................13
Overview of this guide............................................................................................................14
About this guide.....................................................................................................................15
Who should read this guide....................................................................................................16
Logging into the Management Console................................................................................17Chapter 2
Management Console navigation...........................................................................................17
Administrator.........................................................................................................................19Chapter 3
Administrator navigation.........................................................................................................19
Navigation tree.......................................................................................................................19
Pages.....................................................................................................................................24
Administrator Management....................................................................................................24
Managing database account changes.....................................................................................24
Configuring the report server.................................................................................................26
Adding Access Servers..........................................................................................................27
Setting the status interval.......................................................................................................28
Exporting certification logs.....................................................................................................29
Central Repository management............................................................................................32
Setting up users and groups..................................................................................................32
Viewing reports......................................................................................................................35
Server Groups.......................................................................................................................37
Server group architecture.......................................................................................................37
Editing and removing a server group.......................................................................................41
Monitoring Job Server status in a server group......................................................................42
Executing jobs using server groups........................................................................................42
Batch Jobs.............................................................................................................................43
2010-12-023
Contents
3.5.1
3.5.2
3.5.3
3.6
3.6.1
3.6.2
3.6.3
3.7
3.7.1
3.7.2
3.7.3
3.7.4
3.7.5
3.8
3.8.1
3.8.2
3.8.3
3.9
3.9.1
3.9.2
3.9.3
3.9.4
3.9.5
3.10
3.10.1
3.10.2
3.10.3
3.10.4
3.11
3.12
3.12.1
3.12.2
3.13
3.13.1
3.13.2
3.13.3
3.13.4
3.13.5
Executing batch jobs..............................................................................................................43
Scheduling jobs......................................................................................................................44
Monitoring jobs......................................................................................................................57
Real-Time Jobs......................................................................................................................62
Supporting real-time jobs.......................................................................................................62
Configuring and monitoring real-time services........................................................................65
Creating and monitoring client interfaces................................................................................74
Real-Time Performance..........................................................................................................79
Configuring Access Server output..........................................................................................80
Service configuration parameters...........................................................................................82
Service statistics....................................................................................................................85
Service provider statistics......................................................................................................86
Using statistics and service parameters.................................................................................88
Profile Server Management....................................................................................................89
To define a profiler repository.................................................................................................90
Configuring profiler task parameters......................................................................................90
Monitoring profiler tasks using the Administrator ...................................................................94
RFC Server Management.......................................................................................................96
64-bit platform prerequisites...................................................................................................96
Adding an RFC server interface..............................................................................................96
Starting or stopping an RFC server interface connection........................................................97
Monitoring RFC server interfaces...........................................................................................98
Removing one or more RFC server interfaces........................................................................99
Adapters..............................................................................................................................100
Overview of adapters...........................................................................................................100
Adding and configuring adapter instances............................................................................102
Starting and stopping adapter instances...............................................................................107
Monitoring adapter instances...............................................................................................108
Support for Web Services....................................................................................................109
Support for HTTP.................................................................................................................110
Overview..............................................................................................................................110
Adapter installation and configuration...................................................................................111
Troubleshooting the Administrator........................................................................................120
Reestablishing network connections....................................................................................121
Finding problems..................................................................................................................121
Error and trace logs..............................................................................................................122
Resolving connectivity problems..........................................................................................127
Restarting the Access Server..............................................................................................129
4.1
Metadata Reports ...............................................................................................................131Chapter 4
Requirements.......................................................................................................................131
2010-12-024
Contents
4.2
4.2.1
4.3
4.4
4.4.1
5.1
5.1.1
5.1.2
5.2
5.3
5.4
5.4.1
5.4.2
5.4.3
6.1
6.2
6.2.1
6.2.2
6.3
6.3.1
6.3.2
6.3.3
Adding Metadata Integrator..................................................................................................131
To run the Metadata Integrator ............................................................................................132
Repository reporting tables and views..................................................................................133
Logging into the Management Console................................................................................136
Management Console navigation.........................................................................................136
Impact and Lineage Analysis Reports.................................................................................139Chapter 5
Navigation............................................................................................................................139
To increase the java heap memory in Windows....................................................................140
To increase the java heap memory in UNIX..........................................................................141
Analysis options...................................................................................................................141
Table-level and column-level analysis....................................................................................145
Impact and Lineage Analysis Settings control panel.............................................................146
Settings tab.........................................................................................................................147
Refresh Usage Data tab.......................................................................................................147
About tab.............................................................................................................................148
Operational Dashboard Reports.........................................................................................149Chapter 6
Dashboards home page.......................................................................................................149
Job execution statistics........................................................................................................150
Current (snapshot) pie chart.................................................................................................150
Historical (trend) bar chart....................................................................................................151
Job Execution Duration........................................................................................................152
Configuring the Job Execution Duration dashboard..............................................................152
Current (snapshot) speedometer.........................................................................................153
Historical (trend) line chart...................................................................................................156
7.1
7.1.1
7.1.2
7.1.3
7.2
7.3
7.3.1
7.3.2
7.4
7.5
7.5.1
7.5.2
Data Validation Dashboard Reports....................................................................................159Chapter 7
Configuring Data Validation dashboards...............................................................................159
Creating functional areas......................................................................................................160
Creating business rules........................................................................................................161
Enabling data validation statistics collection..........................................................................164
Viewing Data Validation dashboards....................................................................................165
Functional area view.............................................................................................................165
Functional area pie chart......................................................................................................165
History line chart..................................................................................................................166
Business rule view...............................................................................................................167
Validation rule view..............................................................................................................168
Validation rule bar chart........................................................................................................168
History line chart..................................................................................................................169
2010-12-025
Contents
7.6
7.6.1
7.6.2
7.7
7.7.1
7.7.2
7.7.3
8.1
8.1.1
8.1.2
8.1.3
8.1.4
8.1.5
8.1.6
8.2
8.2.1
8.3
Sample data view.................................................................................................................169
Sample data table................................................................................................................170
History line chart..................................................................................................................170
Data Validation dashboards Settings control panel...............................................................170
Repository tab.....................................................................................................................171
Functional area tab...............................................................................................................171
Business rule tab.................................................................................................................171
Auto Documentation Reports..............................................................................................173Chapter 8
Navigation............................................................................................................................173
To search for a specific object..............................................................................................174
Repository...........................................................................................................................175
Project.................................................................................................................................175
Job......................................................................................................................................175
Work flow............................................................................................................................176
Data flow.............................................................................................................................176
Generating documentation for an object...............................................................................177
To print Auto Documentation for an object...........................................................................177
Auto Documentation Settings control panel.........................................................................178
9.1
9.2
9.3
9.4
9.5
9.6
9.7
9.8
9.8.1
9.9
9.9.1
9.9.2
9.9.3
9.9.4
9.9.5
9.9.6
9.9.7
9.10
9.11
Data Quality Reports...........................................................................................................179Chapter 9
Lists of available reports......................................................................................................180
List of reports by job............................................................................................................181
Data Quality Reports Settings control panel.........................................................................182
Report options.....................................................................................................................182
Troubleshooting reports.......................................................................................................183
USA CASS report: USPS Form 3553..................................................................................183
NCOALink Processing Summary Report..............................................................................184
Delivery Sequence Invoice report.........................................................................................186
Contents of report...............................................................................................................186
US Addressing Report.........................................................................................................187
To enable the report ............................................................................................................188
Percent calculation...............................................................................................................188
Information in the US Addressing report .............................................................................188
DPV sections.......................................................................................................................189
Information in the DSF2 sections.........................................................................................189
LACSLink sections..............................................................................................................190
SuiteLink sections................................................................................................................191
DSF2 Augment Statistics log file .........................................................................................191
US Regulatory Locking Report.............................................................................................192
2010-12-026
Contents
9.12
9.13
9.14
9.15
9.16
9.17
9.18
9.19
9.20
9.21
9.22
9.23
9.24
9.25
9.26
9.27
9.28
9.29
Index 211
Canadian SERP report: Statement of Address Accuracy......................................................193
Australian AMAS report: Address Matching Processing Summary.......................................194
New Zealand Statement of Accuracy (SOA) report..............................................................196
Address Information Codes Sample report...........................................................................198
Address Information Code Summary report.........................................................................198
Address Validation Summary report.....................................................................................199
Address Type Summary report.............................................................................................200
Address Standardization Sample report...............................................................................201
Address Quality Code Summary report................................................................................201
Geocoder Summary report...................................................................................................202
Overview of match reports ..................................................................................................203
Best Record Summary report...............................................................................................203
Match Contribution report....................................................................................................204
Match Criteria Summary report............................................................................................206
Match Duplicate Sample report............................................................................................207
Match Input Source Output Select report.............................................................................207
Match Multi-source Frequency report...................................................................................208
Match Source Statistics Summary report.............................................................................209
2010-12-027
Contents
2010-12-028
Introduction
Introduction
1.1 Welcome to SAP BusinessObjects Data Services
1.1.1 Welcome
SAP BusinessObjects Data Services delivers a single enterprise-class solution for data integration,
data quality, data profiling, and text data processing that allows you to integrate, transform, improve,
and deliver trusted data to critical business processes. It provides one development UI, metadata
repository, data connectivity layer, run-time environment, and management console—enabling IT
organizations to lower total cost of ownership and accelerate time to value. With SAP BusinessObjects
Data Services, IT organizations can maximize operational efficiency with a single solution to improve
data quality and gain access to heterogeneous sources and applications.
1.1.2 Documentation set for SAP BusinessObjects Data Services
You should become familiar with all the pieces of documentation that relate to your SAP BusinessObjects
Data Services product.
What this document providesDocument
Administrator's Guide
Customer Issues Fixed
Designer Guide
Information about administrative tasks such as monitoring,
lifecycle management, security, and so on.
Information about customer issues fixed in this release.
Information about how to use SAP BusinessObjects Data
Services Designer.
Documentation Map
Information about available SAP BusinessObjects Data Services books, languages, and locations.
2010-12-029
Introduction
What this document providesDocument
Installation Guide for Windows
Installation Guide for UNIX
Integrator's Guide
Management Console Guide
Performance Optimization Guide
Reference Guide
Release Notes
Technical Manuals
Information about and procedures for installing SAP BusinessObjects Data Services in a Windows environment.
Information about and procedures for installing SAP BusinessObjects Data Services in a UNIX environment.
Information for third-party developers to access SAP BusinessObjects Data Services functionality using web services and
APIs.
Information about how to use SAP BusinessObjects Data
Services Administrator and SAP BusinessObjects Data Services Metadata Reports.
Information about how to improve the performance of SAP
BusinessObjects Data Services.
Detailed reference material for SAP BusinessObjects Data
Services Designer.
Important information you need before installing and deploying
this version of SAP BusinessObjects Data Services.
A compiled “master” PDF of core SAP BusinessObjects Data
Services books containing a searchable master table of contents and index:
•
Administrator's Guide
•
Designer Guide
•
Reference Guide
•
Management Console Guide
•
Performance Optimization Guide
•
Supplement for J.D. Edwards
•
Supplement for Oracle Applications
•
Supplement for PeopleSoft
•
Supplement for Salesforce.com
•
Supplement for Siebel
•
Supplement for SAP
Text Data Processing Extraction Customization Guide
Text Data Processing Language Reference
Guide
Information about building dictionaries and extraction rules to
create your own extraction patterns to use with Text Data
Processing transforms.
Information about the linguistic analysis and extraction processing features that the Text Data Processing component provides, as well as a reference section for each language supported.
2010-12-0210
Introduction
What this document providesDocument
Tutorial
Upgrade Guide
What's New
In addition, you may need to refer to several Adapter Guides and Supplemental Guides.
Supplement for J.D. Edwards
Supplement for Oracle Applications
Supplement for PeopleSoft
A step-by-step introduction to using SAP BusinessObjects
Data Services.
Release-specific product behavior changes from earlier versions of SAP BusinessObjects Data Services to the latest release. This manual also contains information about how to
migrate from SAP BusinessObjects Data Quality Management
to SAP BusinessObjects Data Services.
Highlights of new key features in this SAP BusinessObjects
Data Services release. This document is not updated for support package or patch releases.
What this document providesDocument
Information about interfaces between SAP BusinessObjects Data Services
and J.D. Edwards World and J.D. Edwards OneWorld.
Information about the interface between SAP BusinessObjects Data Services
and Oracle Applications.
Information about interfaces between SAP BusinessObjects Data Services
and PeopleSoft.
Supplement for Salesforce.com
Supplement for SAP
Supplement for Siebel
Information about how to install, configure, and use the SAP BusinessObjects
Data Services Salesforce.com Adapter Interface.
Information about interfaces between SAP BusinessObjects Data Services,
SAP Applications, and SAP NetWeaver BW.
Information about the interface between SAP BusinessObjects Data Services
and Siebel.
We also include these manuals for information about SAP BusinessObjects Information platform services.
Information platform services Administrator's Guide
Information platform services Installation Guide for
UNIX
What this document providesDocument
Information for administrators who are responsible for
configuring, managing, and maintaining an Information
platform services installation.
Installation procedures for SAP BusinessObjects Information platform services on a UNIX environment.
2010-12-0211
Introduction
What this document providesDocument
Information platform services Installation Guide for
Windows
1.1.3 Accessing documentation
You can access the complete documentation set for SAP BusinessObjects Data Services in several
places.
1.1.3.1 Accessing documentation on Windows
After you install SAP BusinessObjects Data Services, you can access the documentation from the Start
menu.
1.
Choose Start > Programs > SAP BusinessObjects Data Services XI 4.0 > Data Services
Documentation.
Installation procedures for SAP BusinessObjects Information platform services on a Windows environment.
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.
1.1.3.2 Accessing documentation on UNIX
After you install SAP BusinessObjects 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.
1.1.3.3 Accessing documentation from the Web
2010-12-0212
Introduction
You can access the complete documentation set for SAP BusinessObjects Data Services from the SAP
BusinessObjects Business Users Support site.
1.
Go to http://help.sap.com.
2.
Click SAP BusinessObjects at the top of the page.
3.
Click All Products in the navigation pane on the left.
You can view the PDFs online or save them to your computer.
1.1.4 SAP BusinessObjects information resources
A global network of SAP BusinessObjects technology experts provides customer support, education,
and consulting to ensure maximum information management benefit to your business.
Useful addresses at a glance:
2010-12-0213
Introduction
ContentAddress
Customer Support, Consulting, and Education
services
http://service.sap.com/
SAP BusinessObjects Data Services Community
http://www.sdn.sap.com/irj/sdn/ds
Forums on SCN (SAP Community Network )
http://forums.sdn.sap.com/forum.jspa?foru
mID=305
Blueprints
http://www.sdn.sap.com/irj/boc/blueprints
Information about SAP Business User Support
programs, as well as links to technical articles,
downloads, and online forums. Consulting services
can provide you with information about how SAP
BusinessObjects can help maximize your information management investment. Education services
can provide information about training options and
modules. From traditional classroom learning to
targeted e-learning seminars, SAP BusinessObjects
can offer a training package to suit your learning
needs and preferred learning style.
Get online and timely information about SAP BusinessObjects 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 SAP BusinessObjects forums on the
SAP Community Network to learn from other SAP
BusinessObjects 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 SAP
BusinessObjects 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.
http://help.sap.com/businessobjects/
Supported Platforms (Product Availability Matrix)
https://service.sap.com/PAM
1.2 Overview of this guide
SAP BusinessObjects product documentation.Product documentation
Get information about supported platforms for SAP
BusinessObjects Data Services.
Use the search function to search for Data Services.
Click the link for the version of Data Services you
are searching for.
2010-12-0214
Introduction
1.2.1 About this guide
The guide includes information about the SAP BusinessObjects Data ServicesManagement Console,
a collection of Web-based applications for administering Data Services jobs and services, viewing object
relationships, evaluating job execution performance and data validity, and generating data quality
reports.
You can install the Management Console on a separate computer from other Data Services components.
It runs on your web application server. The Management Console is written in Java and uses a JDBC
connection to repositories.
The Management Console includes the following applications:
• Administrator
Use to manage your production environment including batch job execution, real-time services, Web
services, adapter instances, server groups, central and profiler repositories, and more.
• Impact and Lineage Analysis
Use to analyze the end-to-end impact and lineage for Data Services tables and columns and SAP
BusinessObjects Enterprise objects such as universes, business views, and reports.
• Operational Dashboard
Use to view dashboards of job execution statistics to see at a glance the status and performance
of your job executions for one or more repositories over a given time period.
• Data Validation Dashboard
Use to evaluate the reliability of your target data based on the validation rules you created in your
batch jobs to quickly review, assess, and identify potential inconsistencies or errors in source data.
• Auto Documentation
Use to view, analyze, and print graphical representations of all objects as depicted in the Designer
including their relationships, properties, and more.
• Data Quality Reports
Use to view and export reports for batch and real-time jobs such as job summaries and data quality
transform-specific reports.
Related Topics
• Administrator
• Impact and Lineage Analysis Reports
• Operational Dashboard Reports
• Data Validation Dashboard Reports
• Auto Documentation Reports
• Data Quality Reports
2010-12-0215
Introduction
1.2.2 Who should read this guide
This and other SAP BusinessObjects Data Services documentation assume the following:
• You are an application developer, consultant or database administrator working on data extraction,
data warehousing, data integration, or data quality.
• You understand your source and target data systems, DBMS, legacy systems, business intelligence,
and messaging concepts.
• You understand your organization's data needs.
• You are familiar with SQL (Structured Query Language).
• If you are interested in using this software to design real-time processing, you are familiar with:
• DTD and XML Schema formats for XML files
• Publishing Web Services (WSDL, HTTP/S and SOAP protocols, etc.)
• You are familiar with SAP BusinessObjects Data Services installation environments: Microsoft
Windows or UNIX.
2010-12-0216
Logging into the Management Console
Logging into the Management Console
When you log in to the Management Console, you must log in as a user defined in the Central
Management Server (CMS).
1.
Navigate to the Management Console address in a supported web browser:
http://hostname:28080/DataServices
where hostname is the name of the computer hosting the web application server.
Note:
If you are logged in to the Designer, you can also access the Management Console home page in
several ways:
• From the Start page, click Data Services Management Console.
• From the Tools menu, click Data Services Management Console.
• Click the Data Services Management Console tool bar icon.
2.
Enter your user credentials for the CMS.
• System
Specify the server name and optionally the port for the CMS.
• User name
Specify the user name to use to log into CMS.
• Password
Specify the password to use to log into the CMS.
• Authentication
Specify the authentication type used by the CMS.
3.
Click Log on.
The software attempts to connect to the CMS using the specified information. When you log in
successfully, the list of local repositories that are available to you is displayed.
The Management Console home page opens.
2.1 Management Console navigation
2010-12-0217
Logging into the Management Console
After logging in to the Management Console and launching one of the applications, the application
name appears under the Management Console banner.
The upper-right side of the main window includes the following links:
• Home
Click to return to the Management Console home page (for example, to select another application).
• Settings
The metadata reporting applications also include a Settings control panel for changing a variety of
options depending on the selected application.
• Logout
Click to exit the application and the Management Console and return to the login page.
• Help icon
Opens the
Management Console Guide
.
As you navigate around the applications, notice that the top of the right pane often displays a “bread
crumb” path to indicate where you are in the application. Depending on the page displayed, sometimes
you can click on the bread crumbs to navigate to a different part of the application.
The Administrator, Impact and Lineage Analysis, and Auto Documentation applications also use a
navigation tree in the left pane.
Management Console sessions time out after 120 minutes (2 hours) of inactivity.
2010-12-0218
Administrator
Administrator
This section describes the Administrator and how to navigate through its browser-based, graphical user
interface.
Use the Administrator to:
• Set up users and their roles
• Add connections to Access Servers and repositories
• Manage the retention of Job Server and Access Server logs
• Access job data published for Web Services
• Schedule and monitor batch jobs
• Configure and monitor:
• Access Server status
• Real-time services
• Client interfaces including SAP application client interfaces (to read IDocs) and message traffic
moving in and out of an Access Server
• Adapter instances (a prerequisite for creating adapter datastores)
Related Topics
• Logging into the Management Console
• Administrator navigation
3.1 Administrator navigation
The layout of the Administrator consists of a window with a navigation tree on the left and pages with
tabs on the right.
3.1.1 Navigation tree
The navigation tree is divided into several nodes, including:
• Status
• Batch
2010-12-0219
Administrator
• Real-Time
• Web Services
• SAP Connections
• Server Groups
• Profiler Repositories
• Management
Note:
The nodes displayed depend on the permissions granted to the user you use to log in to the Management
Console. For example, the Profiler Repositories node only appears if you have access to view or manage
a profiler repository, as defined in the Central Management Console (CMC).
3.1.1.1 Status node
When the Administrator opens, it displays the Status page. The Status page displays the status of the
following items (after you have connected them to the Administrator). The red, green, and yellow icons
indicate the overall status of each item based on the jobs, services, and other objects they support.
• Batch
Contains the name of the repository associated with the Job Server on which you run the batch jobs.
To see batch jobs status, connect the repository to the Administrator.
Click the repository name to display a list of batch jobs and their status.
• Real-Time
Contains the name of the Access Servers associated with a real-time service. To see real-time jobs
status, connect the Access Server to the Administrator.
Click the Access Server name to display a list of real-time services and their client interfaces.
• Adapters
Contains the name of the repository associated with the Job Server on which you run the adapter.
To see an adapter's status, enable a Job Server for adapters, and then add the repository associated
with that Job Server.
• Profiler
Contains the name of the repository associated with the Profiler Server. To see a profiler repository,
connect the profiling repository to the Administrator.
Click the repository name to display a list of profiler tasks and their status.
2010-12-0220
Administrator
3.1.1.2 Batch node
After you add at least one repository connection to the Administrator, you can expand the Batch node.
Then click a repository name to display its Batch Job Status page.
Click the All Repositories option to see jobs in all repositories connected to this Administrator (this
node only appears if more than one repository is connected).
Each repository under the Batch node includes the following tabs:
• Batch Job Status
View the status of the last execution and in-depth information about each job.
• Batch Job Configuration
Configure execution and scheduling options for individual jobs.
• Repository Schedules
View and configure schedules for all jobs in the repository.
Related Topics
• Batch Jobs
3.1.1.3 Real-Time node
After you add a connection to an Access Server in the Administrator, you can expand the Real-Time
node. Expand an Access Server name under the Real-Time node to view the options.
DescriptionAccess Server node options
View status of real-time services and client interfaces supported by
Status
Real-time Services
this Access Server. Control, restart, and set a service provider interval for this Access Server.
View status for services and service providers, start and stop services, add or remove a service, configure Job Servers for a service.
Client Interfaces
View status for client interfaces, start and stop interfaces, add or
remove an interface.
2010-12-0221
Administrator
Logs - Current
DescriptionAccess Server node options
View list of current Access Server logs, content of each log, clear
logs, configure content of logs for display, enable or disable tracing
for each Access Server.
Logs - History
View list of historical Access Server logs, view content of each log,
delete logs.
Related Topics
• Real-Time Jobs
• Real-Time Performance
3.1.1.4 Web Services node
Use this node to select real-time and batch jobs that you want to publish as Web service operations
and to monitor the status of those operations. You can also use the node to set security for jobs published
as Web service operations and view the WSDL file that SAP BusinessObjects Data Services generates.
Related Topics
• Support for Web Services
3.1.1.5 Adapter Instances node
Use this node to configure a connection between SAP BusinessObjects Data Services and an external
application by creating an adapter instance and dependent operations. This is a prerequisite requirement
for creating a datastore for adapters in the Designer.
After you create a datastore, import data through the adapter and create jobs. Then use this node to
view the status of Adapter instances. Options are listed by Job Server under the Adapter Instance node.
Related Topics
• Adapters
2010-12-0222
Administrator
3.1.1.6 Server Groups node
The Server Groups node allows you to group Job Servers that are associated with the same repository
into a server group.
Use a server group if you want SAP BusinessObjects Data Services to automatically use the Job Server
on a computer with the lightest load when a batch job is executed. This functionality improves load
balancing (throughput) in production environments and also provides a hot backup method. When a
job is launched, if a Job Server is down, another Job Server in the same group executes the job.
Related Topics
• Server Groups
3.1.1.7 Profiler Repositories node
After you connect a profiler repository to the Administrator, you can expand the Profiler Repositories
node. Click a repository name to open the Profiler Tasks Status page.
Related Topics
• Profile Server Management
3.1.1.8 Management node
The Management node contains the configuration options for the Administrator application. Before you
can use some features of the Administrator, you must add connections to other SAP BusinessObjects
Data Services components using the Management node. For example, expand the management node
and:
• Expand Datastore and click a repository to manage datastore configurations for that repository.
• Click Access Servers to add a connection to your Access Servers (for real-time jobs).
Related Topics
• Administrator Management
2010-12-0223
Administrator
3.1.2 Pages
The top of the page indicates the currently selected node. Once you select a branch on the navigation
tree to go to a page, use the tab row on the page to navigate further.
As you drill into various pages, a “bread crumb” trail often indicates where you are in the Administrator
application. Depending on the page displayed, sometimes you can click on the bread crumb links to
navigate to a different page.
A dark blue (shaded) tab signifies the active page. Click a light blue tab to go to that page. Some pages
do not include a tab row.
3.2 Administrator Management
Use the Management features to configure the Administrator.
Related Topics
• Managing database account changes
• Configuring the report server
• Adding Access Servers
• Setting the status interval
• Exporting certification logs
3.2.1 Managing database account changes
SAP BusinessObjects Data Services uses several types of user accounts and associated passwords.
For various reasons, database account parameters such as user names or passwords change. For
example, perhaps your company's compliance and regulations policies require periodically changing
account passwords for security.
Related Topics
• Updating local repository login parameters
• Updating datastore connection parameters
2010-12-0224
Administrator
3.2.1.1 Updating local repository login parameters
If the login information, particularly the password, for a repository has changed, SAP BusinessObjects
Data Services provides an optional password file that all schedules or exported execution commands
use. In other words, the software uses this password file to store and update connection information in
one location that multiple schedules or exported execution commands share for that repository.
Note:
This description does not apply to central repositories.
The password file:
• Specifies the connection information for the repository.
• Can be stored in a central location for access by others who run jobs in that repository.
• Is created when you create or update a job schedule to minimize associated maintenance.
Related Topics
• Using a third-party scheduler
3.2.1.1.1 To update the CMS connection information and use a password file
1.
Expand the Management node.
2.
Click CMS Connection.
3.
Edit the connection information as necessary.
4.
Click Apply.
5.
Click Generate password file to create or update the password file.
The default name and location of the file are <LINK_DIR>\conf\repositoryname.txt.
3.2.1.1.2 Updating job schedules
When database account information for your repository changes, the SAP BusinessObjects Data
Services job schedules associated with that account must also be updated. When you use a password
file, the job schedules access it at runtime to automatically retrieve the updated account information.
Related Topics
• Scheduling jobs
3.2.1.2 Updating datastore connection parameters
2010-12-0225
Administrator
If the information associated with a datastore connection changes, particularly passwords, you can
update the changes using the Administrator.
Note:
Only users with Administrator role privileges can edit datastore parameters.
3.2.1.2.1 To edit the connection information for an individual configuration in a datastore
1.
Select Management > Datastore, and select the repository that contains the datastore configuration
that you want to edit.
2.
Click the configuration name to configure.
3.
Edit the enabled fields as necessary.
4.
Click Apply. To return all fields to the last set of values applied, click Reset.
3.2.1.2.2 To edit the connection information for multiple configurations in a datastore
1.
Select Management > Datastore, and select the repository that contains the datastore configurations
that you want to edit.
2.
Click the datastore name to configure.
All configurations for that datastore display.
3.
Edit the enabled fields as necessary.
Click More to display the page for that individual configuration, which includes more options specific
to it.
4.
Click Apply. To return all fields to the last set of values applied, click Reset.
3.2.2 Configuring the report server
For each repository registered in the Central Management Console (CMC), a report server configuration
is automatically created with default parameters. The Report Server Configuration node in the
Management Console Administrator lets you edit the default parameters, including the location where
job reports are written upon execution.
1.
Select Management > Report Server Configuration > repository.
The Report Server Configuration page opens and displays the report export configuration parameters.
If the configuration has not yet been saved for the selected repository, the page displays default
parameters.
2.
Enter the appropriate configuration information.
DescriptionOption
Host name
The name of the machine that the report server is running on. By default,
the current web application server name is used. Localhost is not a valid
name.
2010-12-0226
Administrator
Export location
Overwrite
DescriptionOption
The port number of the machine that the report server is running on.Communication port
The path where the reports will be exported to. The default path is
<LINK_DIR>\DataQuality\reports\. Upon execution, the repository name and job name folders are appended to the path. If the Overwrite
option is not selected, a run ID folder is also appended to the path.
Note:
If you export reports to a location other than a local drive, such as a
network drive, before you execute the job you must start the web application server with an account that has access rights to that location.
The format in which the reports can be exported (PDF or RTF).Export type
Specifies whether existing reports will be overwritten when the reports
are exported. If this option is not selected, the reports are exported to a
subfolder with the run ID, which specifies a unique identification of an
instance of the executed job.
The supported language that the reports are generated in. Note that
Language
some reports, such as country-specific certification reports, are designed
only to support English, so changing the option for those reports has no
effect.
3.
Click Apply to save the configuration. To return all fields to the last set of values applied, clicking
Reset.
4.
Verify that the security setting for this operation is disabled. Select Administrator > Web Services
and click the Web Services Configuration tab. If the Select the Export_DQReport operation is
enabled (displays a check in the Session Security column), select the checkbox next to it, select
Disable Session Security from the pull-down menu, and click the Apply button.
To generate and export all of the job reports to the specified location at runtime, select the Export Data
Quality Reports option when you execute the job.
Related Topics
• To add a job schedule
• Reference Guide: Data Services Objects, Batch Job, Parameters
• Integrator's Guide: To configure web service information using the Administrator
3.2.3 Adding Access Servers
The Administrator acts as a front end for Access Servers connected to it. Use the Administrator to:
2010-12-0227
Administrator
• Configure real-time jobs as real-time services.
• Configure real-time services with service providers.
• Monitor Access Servers, real-time services, and service providers.
You first must connect an Access Server to the Administrator so that you can use the Administrator to
create a real-time service from a real-time job. After a service starts, the Access Server brokers messages
between external applications and SAP BusinessObjects Data Services.
When a message request comes in, the Access Server communicates with the Job Server to get the
repository data needed to run a real-time service and process the message. A reply comes back through
the Access Server to the message originator and the Access Server log records the event, which you
can monitor from the Administrator.
Use the Access Servers page to connect an Administrator to a repository.
1.
Select Management > Access Servers.
2.
Click Add.
3.
Enter the following information.
DescriptionOption
Machine Name
Communication Port
4.
(Optional) Before attempting to register the Access Server with the Administrator, click Ping to see
if the Access Server is available and exists on the computer and port you specified.
5.
Click Apply.
The Administrator registers the Access Server, validates the Access Server connection information,
and displays the information on the Access Servers page.
To view a list of Access Servers connected to the Administrator, select Management > Access Servers.
The Access Servers page lists the Access Servers that are connected to the Administrator. You can
also remove a connection to an Access Server from this page.
3.2.4 Setting the status interval
Host name of the computer on which the Access Server is installed.
Port assigned to the Access Server in the Server Manager
utility.
Use the Status Interval page to specify the time period for which the Administrator displays the status
(using the red, yellow, and green status icons) on the Batch Job Status page.
1.
Select Management > Status Interval.
2.
On the Status Interval page, specify the time period.
You can filter the information on this page in three ways:
2010-12-0228
Administrator
• By the last execution of each job
• By number of days
• By range of dates
3.
Click Apply.
The Administrator updates the list of job executions and the status interval displays in the table title
on the Batch Job Status page. The following example lists the last execution of all jobs.
3.2.5 Exporting certification logs
When you run address cleanse jobs with the appropriate options set, you can generate reports to qualify
for mailing discounts with certain countries' postal authorities. In the Management Console, you can
generate the certification log files required for those certifications.
The Certification Logs page is available to users who are assigned either the Administrator or Operator
role.
Related Topics
• Exporting NCOALink certification logs
• Exporting New Zealand SOA certification logs
• Exporting DSF2 certification log
3.2.5.1 Exporting NCOALink certification logs
Before you export the certification log, you must have run a job containing a USA Regulatory Address
Cleanse transform with the NCOA certification options set appropriately. You must also configure your
repository in the Central Management Console (CMC).
You can export the certification log for the data in one repository or in all repositories.
Caution:
If you select all repositories and have more than one connection to the same repository, your results
may contain duplicate records.
1.
Select Management > Certification Logs, and select the repository that contains the certification
log that you want to export.
2.
Click the NCOALink tab.
3.
Select the date range that contains the data that you want to export.
4.
Select the NCOALink licensee ID for the logs that you want to export, or select All NCOA Licensee
IDs.
2010-12-0229
Administrator
5.
Specify the location where the certification logs will be exported.
Note:
The location that you specify is relative to the web application server.
To reset the export location to the default, click the Reset button. The default location is
<LINK_DIR>\DataQuality\certifications\CertificationLogs\repository\.
6.
If you want to overwrite an existing log file, click the Overwrite option.
7.
Click the Search button. The page displays the available log files with the specified criteria. You
can sort the log files using the column headers.
The "Data Available" column has a Yes status when there is data for at least one of the log types
(PAF, Bala, or CSL). A No status indicates that no data is available and will result in an empty log
file for each type.
8.
Select the log file(s) that you want to export or select the checkbox next to "Select All".
9.
Click the Export button.
After the log file is exported, a confirmation message is displayed at the top of the page.
Related Topics
• Administrator Guide: Repository management, To register a repository in the CMC
• NCOALink Processing Summary Report
• Designer Guide: Data Quality, Address Cleanse, NCOALink (USA Regulatory Address Cleanse)
• Reference Guide: Transforms, NCOALink options
3.2.5.2 Exporting New Zealand SOA certification logs
Before you export the certification log, you must have run a job containing a Global Address Cleanse
transform with the New Zealand SOA certification options set appropriately. You must also configure
your repository in the CMC.
You can export the certification log for the data in one repository or in all repositories.
Caution:
If you select all repositories and have more than one connection to the same repository, your results
may contain duplicate records.
1.
Select Management > Certification Logs, and select the repository that contains the certification
log that you want to export.
2.
Click the New Zealand SOA tab.
3.
Select whether you want to export all certification log data that is in the selected repository or just
the data within a specified date range.
The Year list contains the current year and the two previous years, because certification logs are
required to be retained for two years.
2010-12-0230
Loading...