TrustRadius: an HG Insights company

BusinessObjects Data Integrator (discontinued)

Score9.7 out of 10

12 Reviews and Ratings

What is BusinessObjects Data Integrator (discontinued)?

BusinessObjects Data Integrator was an ETL tool, acquired by BusinessObjects from the company Acta, where the tool was known as ActaWorks. After SAP's acquisition of BusinessObjects, the tool was discontinued.

Categories & Use Cases

Top Performing Features

  • Connect to traditional data sources

    Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications

    Category average: 8.9

  • Connecto to Big Data and NoSQL

    Ability to connect to non-traditional data sources like Hadoop and other big data technologies, and NoSQL databases

    Category average: 7.6

  • Simple transformations

    Simple data transformations are calculations, data type conversions, aggregations and search and replace operations

    Category average: 8.9

Areas for Improvement

  • Integration with MDM tools

    Integration with master data management tools to ensure data consistency across the organization

    Category average: 7.2

  • Data model creation

    Ability to create and maintain data models using a graphical tool to define relationships between data

    Category average: 8.4

  • Metadata management

    Automated discovery of metadata with ability to synchronize and share metadata with other tools like Master Data Management

    Category average: 7.5

Automate, Integrate, validate using SAP BODI

Pros

  • Processing business validations on the input data set.
  • Scheduling and notification using the Admin console tool.
  • Code management across group of developers.
  • Simple deployment process across environment.
  • Ability to deploy stand alone jobs to automate task. Integration with OS and support for variety of data bases.

Cons

  • Writing custom components is a complex process.
  • Along with ETL BODI should have some data quality integration.
  • Ready documentation of the code and inbuilt commenting on components.

Return on Investment

  • It was a packaged purchase of BO toolset including BOXI and BODI.
  • Optimized performance for integrating different data sources.
  • Simple and easy setup and maintenance cost.

Other Software Used

Talend Integration Suite, Informatica Enterprise Data Integration, Oracle Data Integrator

Usability