SAP BusinessObjects Data Services delivers a single enterprise-class solution for Data Integration, Data Quality, Data Profiling, and Text Data Processing that allows us to integrate, transform, improve, and deliver trusted data to critical business processes. Read on to know more.

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.

Where Data Services can be used

Data Services can be used as an ETL application tool in Data Integration, Data Migration, Data Warehouse, Data Quality Management or Master Data Management projects. Data Services is an All-In-One solution for Data Integration, Data Quality, Information Stewardship, and Text Analytics. Data Services helps to Move, Improve, Govern, and Unlock Enterprise Data.

  • Move - Extract, Transform and Load data from almost any data source.
  • Improve - Cleanse, Enrich, Match and Consolidate data from any domain.
  • Govern - Understand and Measure the Quality of data in support of Information Stewardship.
  • Unlock - Unlock insights from Structured and Unstructured Text Data.

Most Organizations Face Data Challenges due to Siloed Application System data & Inaccessible, Incomplete, Inconsistent and Inaccurate source data. Data Services can help to discover & understand enterprise data using source data Profiling. It can access and integrate disparate data from virtually any data source both structured and unstructured. It also helps to cleanse data to improve data quality for more accurate decision-making. High quality data is a prerequisite for accurate analysis and informed decision making. Data Services a Single tool to define all extraction, validation and cleansing rules helps Business Run Better by Delivering Timely and Trusted Information.

Batch and Real-time Job

SAP BusinessObjects Data Services supports Real-time data processing as well as scheduled Batch jobs.

  • Batch Jobs - The software helps to extract data from virtually any data source, apply complex transformation and data cleansing techniques and load the data to target system as schedule batches.
  • Real-time Jobs - The software supports real-time data transformation thereby helps to address typical real-time scenarios. The software can receive XML message requests from Web applications, allows us to define the processing of real-time messages and send replies immediately using a real-time job.

SAP Data Services 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.

Structured and Unstructured Data

SAP BusinessObjects Data Services supports Structured data as well as Unstructured text-based files such as text, binary documents, HTML, or XML.

  • Structured Data - Data Services can process Structured Data from almost every Database as well as from majority of Legacy Applications.
  • Unstructured Data - Data Services can read and process files that contain Unstructured content. In order to process a directory of text-based files such as text, HTML, or XML or to move a directory of graphic files on disk into a database table, Data Services provides Unstructured Text and Unstructured Binary file format. Text Data Processing is the new feature provided by Data Services to analyze text and automatically identifies and extracts entities using Base Entity Extraction transformation.

Datastores and Formats

SAP BusinessObjects Data Services supports data extraction from a wide variety of Sources.

  1. Datastore - Datastores represent connection configurations between the Data Services and databases or applications. We define Datastores so that Data Services can access metadata from a database or application and read from or write to that database or application while the software executes a job. Following are the wide range of Databases and Applications supported by Data Services.
    • Databases - ODBC, Oracle, Microsoft SQL Server, DB2, MySQL, HP Neoview, Informix, Sybase ASE, Sybase IQ, SAP HANA, Netezza, Teredata, Attunity Connector, Data Federator.
    • JD Edwards - JD Edwards ERP applications JDE One World, JDE World
    • Oracle Applications
    • PeopleSoft
    • SAP Applications
    • SAP BW - SAP BW Source, SAP BW Target
    • Siebel -Siebel CRM application system
    • Adapters - Java based custom Adapters to access application metadata and data in any application.
    • Web Service - The web services datastore works by sending a request and waiting until it receives a reply from a web services server.
  2. Format - Format is used to connect to source or target data when the data is stored in a file rather than a database table. A file format is a set of properties describing the metadata structure of a flatfile (ASCII). A file format defines a connection to a specific file. File format objects can describe files of the following types:
    • Flat Files - Data Services supports Delimited, Fixed width, SAP transport, Unstructured text & Unstructured binary files.
    • DTD -A Document Type Definition describes the data schema of an XML message or file.
    • XML Schema - Describes the data schema of an XML message or XML file.
    • COBOL Copybook -A COBOL copybook file format describes the structure defined in a COBOL copybook file usually denoted with a .cpy extension.
    • Excel Workbook - An Excel workbook format describes the structure defined in an Excel workbook usually denoted with a .xls extension.

Also the Nested Relational Data Model (NRDM) interface allows us to apply the full power of SQL transforms to manipulate, process, and enrich hierarchical business documents.

High Availability and Performance

The high-performance engine and proven data movement and management capabilities of SAP BusinessObjects Data Services include:

  • Scalable, multi-instance data movement for fast execution.
  • Load balancing.
  • Changed Data Capture.
  • Parallel processing.

To provide flexibility, reliability, and scalability, SAP Data Services components can be installed on one or across many machines. Server processes can be Vertically Scaled (where one computer runs several, or all, server-side processes) to reduce cost, or Horizontally Scaled (where server processes are distributed between two or more networked machines) to improve performance. It is also possible to run multiple, redundant versions of the same server process on more than one machine, so that processing can continue if the primary process encounters a problem.

Metadata Management

  • Impact and Lineage Analysis - 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. Helps to understand information context i.e data lineage to make more confident decisions
  • Auto Documentation - View, analyze, and print graphical representations of all objects as depicted in the Data Services Designer including their relationships, properties, and more.
  • Data Validation - Evaluate the reliability of the target data based on the validation rules created in the Data Services batch jobs to quickly review, assess, and identify potential inconsistencies or errors in source data.
  • Operational Dashboard - View dashboards of Data Services job execution statistics to see at a glance the status and performance of job executions for one or more repositories over a given time period.
  • Data Quality Reports - View and export reports for batch and real-time jobs such as job summaries and data quality transform-specific reports.

Central Repository- Version Control

The central repository is used to support multi-user development. The central repository provides a shared object library allowing developers to check objects in and out of their local repositories. While each user works on applications in a unique local repository, the team uses a central repository to store the master copy of the entire project. The central repository preserves all versions of an application's objects, so it is possible to revert to a previous version if needed. Multi-user development includes other advanced features such as labeling and filtering to provide with more flexibility and control in managing application objects.

SAP BusinessObjects Data Services (Data Services) is One-stop for end-to-end information governance and management.

Have a question on this subject?

Ask questions to our expert community members and clear your doubts. Asking question or engaging in technical discussion is both easy and rewarding.

Are you on Twitter?

Start following us. This way we will always keep you updated with what's happening in Data Analytics community. We won't spam you. Promise.

  • SCD implementation from Source based CDC table

    Consider a scenario where we want to capture all or any changes in the source table to be maintained as history in our data warehouse dimension table. So if we consider day end batch load we will miss out any intermediate changes to the master data as...

  • Handling XML source files in SAP Data Services

    This article will demonstrate how to read data from XML based source files using SAP Data Services. Here our objective is to load employee and department information respectively from the source XML based file.

  • RANK in Data Services

    In this article, we will learn how to implement RANK operation in SAP Data Services.

  • One Stop to SAP BODI/BODS

    BODI Business Objects Data Integrator or BODS Business Objects Data Services is a GUI workspace that allows to create jobs that extracts data from heterogeneous sources, transforms that data using built-in transforms and functions to meet business...

  • Working with Data Services Flatfiles

    In this article we will try to cover all the possible scenarios related to flatfiles in SAP Data Services.

  • GROUP RANK in Data Services

    In this article, we will learn how to implement RANK and DENSE RANK operations on GROUP in SAP Data Services.

  • SAP Data Services Custom Function

    We can create our own functions by writing script functions in SAP Data Services scripting language using the smart editor. User-script functions return a value.

  • Data Services Scenario Questions Part 7

    In this tutorial we will discuss some scenario based questions and their solutions using SAP Data Services. This article is meant mainly for Data Services beginners.

  • Table Comparison Transform to Implement Slowly Change Dimension (SCD) in Data Service

    In this tutorial we will learn a new SAP Data services transform, known as Table Comparison Transform and we will see how we may use this transform to implement "slowly changing dimension" (SCD) Type - I. Like before, we have added a video tutorial at the...

  • Map_CDC_Operation in Data Services

    Map CDC Operation is used to support relational or mainframe changed-data capture (CDC). This transform reads the source DML changes i.e. INSERT/UPDATE/DELETE and reflects the same in the target system. So the transform maps all the source rows...