BusinessObjects Data Integrator

From Wikipedia, the free encyclopedia

Business Objects's Data Integrator is a data integration and ETL tool that was previously known as Acta. The Data Integrator product consists primarily of a Data Integrator Job Server and the Data Integrator Designer. It is commonly used for building data marts, ODS systems and data warehouses.

, 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. 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.

Contents

[edit] Data Integrator Job Server

The DI Job Server executes, monitors and schedules jobs that have been created by using the Designer.

[edit] 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.

[edit] Supported Database Connections (for ETL)

  • Oracle
  • Microsoft SQL Server
  • Sybase
  • DB2
  • Teradata
  • Generic ODBC Connections
  • XML
  • Flat Files including fixed width, delimited and SAP R/3
  • Informix

[edit] Supported Platforms

[edit] External links