SAP BODS - Overview

SAP BO Data Services is an ETL tool used for Data integration, data quality, data profiling and data processing. It allows you to integrate, transform trusted data-to-data warehouse system for analytical reporting.

BO Data Services consists of a UI development interface, metadata repository, data connectivity to source and target system and management console for scheduling of jobs.

Data Integration & Data Management

SAP BO Data Services is a data integration and management tool and consists of Data Integrator Job Server and Data Integrator Designer.

Key Features

  • You can apply various data transformations using Data Integrator language to apply complex data transformations and building customized functions.

  • Data Integrator Designer is used to store real time and batch jobs and new projects in repository.

  • DI Designer also provides an option for team based ETL development by providing a central repository with all basics functionality.

  • Data Integrator job server is responsible to process jobs that are created using DI Designer.

Web Administrator

Data Integrator web administrator is used by system administrators and database administrator to maintain repositories in Data services. Data Services includes Metadata Repository, Central Repository for team-based development, Job Server and Web Services.

Key functions of DI Web Administrator

  • It is used to schedule, monitor and execute batch jobs.
  • It is used for the configuration and start and stop real-time servers.
  • It is used for configuring Job Server, Access Server, and repository usage.
  • It is used for configuring adapters.
  • It is used for configuring and controlling all the tools in BO Data Services.

Data Management function emphasizes on data quality. It involves data cleansing, enhancing and consolidating the data to get correct data in the DW system.