Azure Data Factory vs BusinessObjects Data Integrator

Likelihood to Recommend

If you are just getting started and all your data is resident in the Azure cloud, then Azure Data Factory is likely to work fine without having to jump through too many hoops. However, in a hybrid environment (which is most of them these days), ADF will likely need a leg up. It works well for scheduling and basic scheduling/orchestration tasks, but the feature set is not at a level with SSIS (which has been around for 15 years so...). As ADF now supports deploying SSIS, it is also a good candidate if large amounts of your data are resident in the Azure cloud and you have an existing SSIS investment in code and licensing. We are using it in a hybrid fashion for the data warehouse and will slowly transition over to ADF as the feature set improves. We are also using it for cloud-native applications that only require supplemental data from on-prem resources

Read full review

Verified User

Professional in Information Technology

Architecture & Planning Company, 1001-5000 employees

View all 2 answers on this topic

Great tool for ETL with the ability to integrate with SAP products seamlessly. Supports Big data integration.

Read full review

Verified User

Consultant in Information Technology

Computer Software Company, 1001-5000 employees

View all 1 answers on this topic

Feature Rating Comparison

Azure Data Factory

BusinessObjects Data Integrator

Connect to traditional data sources

Connecto to Big Data and NoSQL

Azure Data Factory

BusinessObjects Data Integrator

Simple transformations

Complex transformations

Azure Data Factory

BusinessObjects Data Integrator

Data model creation

Metadata management

Business rules and workflow

Collaboration

Testing and debugging

Azure Data Factory

BusinessObjects Data Integrator

Integration with data quality tools

Integration with MDM tools

Pros

Cloud-based
Fast
Reliable

Read full review

Marco Urrea

DevOps Engineer

DigitalOnUsComputer Software, 201-500 employees

View all 2 answers on this topic

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.

Read full review

Verified User

Consultant in Information Technology

Computer Software Company, 1001-5000 employees

View all 1 answers on this topic

Cons

Limited source/sink (target) connectors depending on which area of Azure Data Factory you are using.
Does not yet have parity with SSIS as far as the transforms available.

Read full review

Verified User

Professional in Information Technology

Architecture & Planning Company, 1001-5000 employees

View all 2 answers on this topic

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.

Read full review

Verified User

Consultant in Information Technology

Computer Software Company, 1001-5000 employees

View all 1 answers on this topic

Usability

No score

No answers yet

No answers on this topic

BusinessObjects Data Integrator 8.0

Based on 1 answer

It is a good ETL tool to use if you are SAP shop and looking for a simple and elegant solution for automation.

Read full review

Verified User

Consultant in Information Technology

Computer Software Company, 1001-5000 employees

View all 1 answers on this topic

Support Rating

Azure Data Factory 7.0

Based on 2 answers

We have not had need to engage with Microsoft much on Azure Data Factory, but they have been responsive and helpful when needed. This being said, we have not had a major emergency or outage requiring their intervention. The score of seven is a representation that they have done well for now, but have not proved out their support for a significant issue

Read full review

Verified User

Professional in Information Technology

Architecture & Planning Company, 1001-5000 employees

View all 2 answers on this topic

No score

No answers yet

No answers on this topic

Alternatives Considered

I'd chose data factory because its very easy to use, its UI is beautiful, it's library for .net is very useful and it lives within the microsoft ecosystem.

Read full review

Marco Urrea

DevOps Engineer

DigitalOnUsComputer Software, 201-500 employees

View all 2 answers on this topic

It is a good package tool with SAP BO set of product line

Read full review

Verified User

Consultant in Information Technology

Computer Software Company, 1001-5000 employees

View all 1 answers on this topic

Return on Investment

It is very useful and make things easier
Debugging can improve
Its better suited than other products with the same objective

Read full review

Marco Urrea

DevOps Engineer

DigitalOnUsComputer Software, 201-500 employees

View all 2 answers on this topic

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.

Read full review

Verified User

Consultant in Information Technology

Computer Software Company, 1001-5000 employees

View all 1 answers on this topic

Pricing Details

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Rating Summary

Azure Data Factory

BusinessObjects Data Integrator

Azure Data Factory

BusinessObjects Data Integrator

Azure Data Factory

BusinessObjects Data Integrator

Likelihood to Recommend