Azure Data Factory vs Oracle Data Service 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

Once Oracle Data Service Integrator is set up properly, it is quite simple to snatch data from a myriad of disparate sources and put them into a single repository. Due to cost factors, it is not for the faint of heart; however, if you can handle it, the benefits will quickly outpace the initial investment. To take full advantage of the power of ODSI, I would recommend the training that Oracle provides.

Read full review

Verified User

Consultant in Information Technology

Information Technology and Services Company, 51-200 employees

View all 2 answers on this topic

Feature Rating Comparison

Azure Data Factory

Oracle Data Service Integrator

Connect to traditional data sources

Connecto to Big Data and NoSQL

Azure Data Factory

Oracle Data Service Integrator

Simple transformations

Complex transformations

Azure Data Factory

Oracle Data Service Integrator

Data model creation

Metadata management

Business rules and workflow

Collaboration

Testing and debugging

Azure Data Factory

Oracle Data Service 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

Very easy to use. Very easy to just grab data when needed.
Very robust and has so many features to move and transform data.
Functionality is very easy to implement with other Oracle data products.

Read full review

Verified User

Engineer in Engineering

Computer Software Company, 11-50 employees

View all 2 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

If not bundled with other products, the price can be prohibitively expensive
SAP connectors tend to be a little expensive and slightly difficult to use
The audit module had some difficulties debugging failed instances

Read full review

Verified User

Consultant in Information Technology

Information Technology and Services Company, 51-200 employees

View all 2 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

While we tested and evaluated multiple data service providers, we came to choose Oracle Data Service Integrator since our infrastructure was so heavily dependent on Oracle software. The implementation would be easier and the difference in the number of features and performance wasn't enough to sway us in another direction.

Read full review

Verified User

Engineer in Engineering

Computer Software Company, 11-50 employees

View all 2 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 provided terrific bulk data movement and data transformation services which we desperately needed
It allowed to reduce development costs and lower the total cost of ownership among disparate architectures
The enterprise edition's ELT allowed us to generate native code for wildly varied RDBMS

Read full review

Verified User

Consultant in Information Technology

Information Technology and Services Company, 51-200 employees

View all 2 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

Oracle Data Service Integrator

Azure Data Factory

Oracle Data Service Integrator

Azure Data Factory vs Oracle Data Service Integrator