What is Business Objects Data Services?
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.
This application is browser-based and consists of the following functional modules:
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.
This module generates the ETL projects documentation (rft/pdf) with the required level of specifications.
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.
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.
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.