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