{{Short description, Data integration software

Business Objects A business object is an entity within a multi-tiered software application that works in conjunction with the data access and business logic layers to transport data. For example, a "Manager" would be a ''business object'' where its attributes c ...

's Data Integrator is a

data integration Data integration involves combining data residing in different sources and providing users with a unified view of them. This process becomes significant in a variety of situations, which include both commercial (such as when two similar companies ...

and ETL tool that was previously known as ActaWorks. Newer versions of the software include data quality features and are named SAP BODS (BusinessObjects Data Services). The Data Integrator product consists primarily of a Data Integrator Job Server and the Data Integrator Designer. It is commonly used for building

data mart A data mart is a structure/access pattern specific to ''data warehouse'' environments, used to retrieve client-facing data. The data mart is a subset of the data warehouse and is usually oriented to a specific business line or team. Whereas data w ...

s, ODS systems and

data warehouse In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for Business reporting, reporting and data analysis and is considered a core component of business intelligence. DWs are central Repos ...

s, etc. Additional transformations can be performed by using the DI scripting language to use any of the already-provided data-handling functions to define inline complex transforms or building custom functions. Data Integrator Designer stores the created jobs and projects in a Repository. However, Data Integrator Designer also facilitates team-based ETL development by including a Central Repository

version control system In software engineering, version control (also known as revision control, source control, or source code management) is a class of systems responsible for managing changes to computer programs, documents, large web sites, or other collections o ...

. Although this version control system is not as robust as standalone VCSs, it does provide the basic check-in/check-out, get latest, version labeling and undo checkout functionality. The DI Job Server executes, monitors and schedules jobs that have been created by using the Designer.

Web Administrator

The DI web administrator is a web interface that allows system administrators and database administrator to manage the different repositories, the Central Repository, Metadata, the Job Server and Web Services. * Scheduling, monitoring, and executing batch jobs * Configuring, starting, and stopping real-time servers * Configuring Job Server, Access Server, and repository usage * Configuring and managing adapters * Configuring and managing tools.

Supported Platforms

Data Integrator runs on Windows platforms and under HP-UX (including 64-bit), Sun Solaris, AIX and Linux, while the repository, which supports the Common Warehouse Meta model, may be based on Oracle, DB 2 or SQL Server.

External links

SAP Data Services

BusinessObjects Board
Extract, transform, load tools