BusinessObjects Data Integrator

BusinessObjects Data Integrator

Business Objects's Data Integrator is a data integration and ETL tool that was previously known as ActaWorks. 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.

Data Integrator Job Server

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.

Supported Database Connections (for ETL)

* Oracle
* Microsoft SQL Server
* Sybase
* DB2
* Teradata
* Generic ODBC Connections
* XML
* Flat Files including fixed width, delimited, Excel and SAP R/3
* Informix
* Attunity Connector, providing Multi-Platform, Multi-Database abilitieshttp://www.businessobjects.com/products/dataintegration/dataintegrator/default.asp

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 CommonWarehouse Metamodel, may be based on Oracle, DB2 or SQL Server.

External links

* [http://www.businessobjects.com/products/dataintegration/ BusinessObjects Data Integrator]

* [http://www.forumtopics.com/busobj/viewforum.php?f=83 BusinessObjects Board]


Wikimedia Foundation. 2010.

Игры ⚽ Нужно сделать НИР?

Look at other dictionaries:

  • Data Integrator (disambiguation) — Data Integrator can refer to software used to integrate data, or to a person or company who integrates data: Pervasive Data Integrator, software SAP BusinessObjects Data Integrator, software Oracle Data Integrator, software Systems integrator,… …   Wikipedia

  • Extract, transform, load — Extract, transform and load (ETL) is a process in database usage and especially in data warehousing that involves: Extracting data from outside sources Transforming it to fit operational needs (which can include quality levels) Loading it into… …   Wikipedia

  • ETL — (от англ. Extract, Transform, Load  дословно «извлечение, преобразование, загрузка»)  один из основных процессов в управлении хранилищами данных, который включает в себя: извлечение данных из внешних источников; их трансформация и… …   Википедия

  • ETL-Prozess — ETL: Datenfluss und unterstützende Programme Extract, Transform, Load (ETL) ist ein Prozess, bei dem Daten aus mehreren ggf. unterschiedlich strukturierten Datenquellen in einer Zieldatenbank vereinigt werden. Extraktion der relevanten Daten aus… …   Deutsch Wikipedia

  • Business Objects (company) — Infobox Company company name = Business Objects SA company company slogan = foundation = 1990 location = San Jose, California and Paris, France key people = John Schwarz, CEO Bernard Liautaud, Chairman and Founder num employees = 4,977 (as of Q2… …   Wikipedia

Share the article and excerpts

Direct link
… Do a right-click on the link above
and select “Copy Link”