What is Business Objects Data Services?

byAlooma Team
Updated Jan 10, 2018

BusinessObjects Data Services offers a number of pre-defined transformations and functional objects that allow modeling of ETL flows.

Among others, these objects are:

  • data merging (MERGE)
  • column mapping (QUERY)
  • performance of SQL queries (SQL)
  • validation of records (VALIDATION)
  • comparison of table contents (TABLE COMPARISON)
  • parent-child relationship management
  • surrogate and natural keys generation
  • conditional expressions which model the data flow

Via those functions, it is possible to manage data operations, refer them directly to the data sources, and communicate with controls and objects. You can also program specialized functions via a scripting language.

Any data flow that is already defined and loaded into the repository can be used repeatedly and constantly. Using Data Designer gives the opportunity to design and monitor the executions of the data flows.

Managment Console

This application is browser-based and consists of the following functional modules:

Administrator

This module is designed for the ETL platform, the application repository management, and for scheduling and monitoring ETL jobs. Each of the tasks processed by the ETL server generates a log file that is available for a given period of time.

Auto Documentation

This module generates the ETL projects documentation (rft/pdf) with the required level of specifications.

Data Validation

This module allows you to preview data validation on the basis of the defined rules and estimation, and to identify potential errors or inconsistencies in the data source.

Impact Analysis and Data Lineage Analysis

This module integrates SAP Business Objects platforms' metadata from the source to the report. It allows tracing a given report element or value back to the source system to help determine which transformations have been used to calculate this value.

Operational Dashboard

This module presents statistics and history for the ETL server tasks in a functional dashboard. The user can view the execution status of the tasks, along with detailed information for the specified time range.

Data Quality Reports

Data Quality monitoring for data quality trends. Perform trend analysis on stored results.

Central Repository

BusinessObjects Data Services solutions are built based on a central repository which is independent from the local repositories of the ETL developers. Versioning is also fully supported.

Like what you read? Share on
Extract, Transform, Load (ETL)

Further reading

How can I learn ETL testing?
Or Cohen • Updated Mar 5, 2018
Take control of your data for free!
Sign up and get $500 worth of free credits to try Alooma.
Get started