What is Data Services Job Server and Access Server?

Job Server

The SAP BusinessObjects Data Services Job Server retrieves the job information from its respected repository and starts the data engine to process the job.

The Job Server can move data in either batch or real-time mode and uses distributed query optimization, multi-threading, in-memory caching, in-memory data transformations, and parallel processing to deliver high data throughput and scalability.

Access Server

The SAP BusinessObjects Data Services Access Server is a real-time, request-reply message broker that collects message requests, routes them to a real-time service, and delivers a message reply within a user-specified time frame.

 

What is Data Services Repository?

Repository is the space in a database server which stores the metadata of the objects used in SAP BusinessObjects Data Services. Each repository must be registered in the Central Management Console (CMC) and associated with one or more Job Servers which run the jobs you create.

There are 3 types of repositories:

  1. Local repository: A local repository stores the metadata of all the objects (like projects, jobs, work flows, and data flows) and source/target metadata defined by developers in SAP BODS Desinger.
  2. Central repository: A central repository is used for multi-user development and version management of objects. Developers can check objects in and out of their local repositories to a shared object library provided by central repository. The central repository preserves all versions of an application’s objects, so you can revert to a previous version if needed.
  3. Profiler repository: A profiler repository is used to store all the metadata of profiling tasks performed in SAP BODS designer. Where, CMS repository is used to store the metadata of all the tasks done in CMC of SAP BO BI platform or IPS.

Information Steward Repository is used to store the metadata of profiling tasks and objects defined in SAP Information Steward.

 

What is the architecture of BODS?

The following figure outlines the architecture of standard components of SAP BusinessObjects Data Services.

architecture of sap bods

 

On top of SAP BODS, a full SAP BusinessObjects BI Platform or SAP BusinessObjects Information Platform Services (IPS) should be installed for User and Rights security management from 4.x versions. Data Services relies on CMC (Central Management Console) for Authentication and Security features. In earlier versions it was done is Management console of SAP BODS.

What is The maximum number of concurrent scheduling jobs limit in BO 4 ?

The maximum number of concurrent scheduling jobs limit is 30 and never reached the value “Maximum Concurrent Jobs” set in Adaptive Job Server.

To increase the limit we need to perform following task.

  1. Log on to Central Management Console (CMC).
  2. Go toServers Page and modify the properties of Adaptive Job Server, change the valueMaximum Concurrent Jobs of Web Intelligence Scheduling Service to 100.
  3. Create a lot of parallel web intelligence scheduling jobs and run them, for example (1000 jobs).
  4. Go to themetrics of Adaptive Job Server, and find the peak value reached. Based on that you can decide the value.

What is Monitoring in BO?

Monitoring allows you to capture the runtime and historical metrics of SAP BusinessObjects Business Intelligence platform servers, for reporting and notification. The monitoring application helps system administrators to identify if an application is functioning normally and if the response times are as expected.

Monitoring allows you to:

  1. Check the performance of each server
  2. Check system availability and response time
  3. View the entire BI platform deployment based on Sever Groups, Service Categories and Enterprise nodes in graphical and tabular format.
  4. Check health of server

What is Auditing in BO?

Auditing allows you to keep a record of significant events on servers and applications, which helps give you a picture of what information is being accessed, how it’s being accessed and changed, and who is performing these operations. This information is recorded in a database called the Auditing Data Store (ADS). Once the data is in the ADS, you can design custom reports to suit your needs. You can look for sample universes and reports on the SAP Developer Network.