Oracle Data Integrator Cloud Service vs SSIS comparison

Oracle and Microsoft are both solutions in the Cloud Data Integration category. Additionally, 100% of Oracle users are willing to recommend the solution, compared to 79% of Microsoft users who would recommend it.

Oracle Data Integrator Clou...

Read 7 Oracle Data Integrator Cloud Service reviews

79 Views
55 Comparison Views

100% willing to recommend

SSIS

Read 73 SSIS reviews

12,026 Views
8,992 Comparison Views

79% willing to recommend

Oracle Data Integrator Clou...

SSIS

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Oracle Data Integrator Cloud Service and SSIS based on real PeerSpot user reviews.

Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed Oracle Data Integrator Cloud Service vs. SSIS Report (Updated: April 2025).

Buyer's Guide

Oracle Data Integrator Cloud Service vs. SSIS

April 2025

Download the complete report

Helped 847,862 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

Oracle Data Integrator Clou...

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Cloud Data Integration (21st)

SSIS

Average Rating

7.6

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

Data Integration (4th)

Featured Reviews

Peeyush Chouksey

Associate Manager at Accenture

Allows us to integrate different cloud services with different applications

It's lacking a lot of mapping features that Oracle OSB and SOA have. It needs to evolve a lot. When it comes to mapping, you are quite restricted. If you have to use a specific, typical function, you need to do a Java callout or something. OSB has a lot of features they are using like Java APIs because it's on-premises.

Read full review

BobAmy

Sr. Architect - Data warehousing & BI at Molina Healthcare, Inc.

Robust and does a good job of handling overload conditions

We purchase an add-on called task factory primarily to allow bulk delete, update, and upsert capability. I'd like to see this be part of the standard package. I believe there are ways to build a model and set variables so that it can be a generic process. In my next system, I would like to have a generic process that would handle all the logging and processing in a model that can be modified and enhanced as the need for a better process, or different statistics to be logged is discovered. I'd want this in a way that the model can be changed and all the processes, with their unique parameters, could all be changed with the model upgraded. I believe they should add some features that help to create the code using a model. This would allow for continuous improvement of the model uses and easy replication of all the different programs that use the model.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"Having a single vendor supporting the entire suite of applications."

"The data is stored in the cloud, making it easy to download data simultaneously into multiple smaller servers, effectively downsizing the process."

"The solution is easy to manage and offers good integration. You can run all the tasks one by one which is really helpful, and pick the day and time to do so."

"The most valuable thing to me is its simplicity. A person with zero knowledge can also develop the integration without having extensive technology knowledgebase. They can also work on creating their own integration."

"Oracle Data Integrator helps us build tables and data marts and allows us to schedule them daily, for nearly real-time data warehousing."

"It's on the cloud, so it's scalable and quite easy to work with."

"Oracle integration cloud has got the adapters for all their products, which makes integration faster."

"The most valuable features of this solution are the fast insert and fuzzy logic matching."

"SSIS' most valuable feature is its reporting services."

"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."

"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."

"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."

"We like that this solution includes a developer edition, free of charge, to allow for training."

"The initial setup was easy."

"The setup is easy to use and understand."

More SSIS pros

Cons

"I've found technical support not very effective. They should work to improve their services."

"I would like to see different cloud adapters or connectors in case of integration. When you have Oracle to Oracle, they are good. They have really good connectors, but if it is a different ERP, like Obsidian, that is where they are faced with problems in OIC."

"This is an expensive solution compared to other products on the market."

"It can be made much easier for users. They should be allowed to easily monitor the data extraction and flow, allowing them to observe real-time data flow within the software, making the process straightforward."

"It's lacking a lot of mapping features that Oracle OSB and SOA have. It needs to evolve a lot."

"The pricing could be more competitive."

"Bulk uploading can be a problem when you hit the upper limit."

"We have issues with SSIS connectors while extracting data from Excel sources."

"SSIS is not stable."

"Performance could be better."

"At one point, we did have to purchase an add-on."

"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."

"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."

"I would like to see better technical documentation because many times information is missing."

"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."

More SSIS cons

Pricing and Cost Advice

"The price is competitive compared to Boomi which is much higher."

"The solution is economical. You don't have to worry about the pricing as long as you're installing both services on the same server."

"This solution is included with the MSSQL server package."

"All of my clients have this product included as part of their Microsoft license."

"SSIS is a cheaper option compared to the cost of other ETL tools."

"We have an enterprise license for this solution."

"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."

"SSIS is fairly well-priced - I would rate it at four out of five."

"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."

More SSIS pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.

See recommendations

847,862 professionals have used our research since 2012.

Comparison Review

it_user90069

BI Expert at a healthcare company with 1,001-5,000 employees

Feb 20, 2014

Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities

Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…

Read full review

Top Industries

By visitors reading reviews

No data available

Financial Services Firm

18%

Computer Software Company

12%

Government

Healthcare Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about Oracle Data Integrator Cloud Service?

The data is stored in the cloud, making it easy to download data simultaneously into multiple smaller servers, effectively downsizing the process.

See all answers

What needs improvement with Oracle Data Integrator Cloud Service?

It can be made much easier for users. They should be allowed to easily monitor the data extraction and flow, allowing them to observe real-time data flow within the software, making the process str...

See all answers

What is your primary use case for Oracle Data Integrator Cloud Service?

I have experience working with Korean Telecom (Katie) on various projects involving data integration, especially with Oracle databases. These projects included tasks such as data collection, ETL (E...

See all answers

Which is better - SSIS or Informatica PowerCenter?

SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...

See all answers

What do you like most about SSIS?

The product's deployment phase is easy.

See all answers

What is your experience regarding pricing and costs for SSIS?

Utilizing SSIS involves no extra charges beyond the SQL Server license. It's an economical choice for my clients.

See all answers

Comparisons

No data available

Informatica PowerCenter vs SSIS

Compared 19% of the time

Talend Open Studio vs SSIS

Compared 12% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 7% of the time

IBM InfoSphere DataStage vs SSIS

Compared 7% of the time

dbt vs SSIS

Compared 5% of the time

More SSIS Competitors

Product Reports

Buyer's Guide

Oracle Data Integrator Cloud Service

March 2025

Oracle Data Integrator Cloud Service report

Download Oracle Data Integrator Cloud Service product report

Buyer's Guide

SSIS

March 2025

Download SSIS product report

Also Known As

No data available

SQL Server Integration Services

Overview

Oracle Data Integrator Cloud Service provides pushdown data processing; high performance ETL with less data movement which is best for the Cloud. Oracle Data Integrator Cloud Service executes data transformations where the data lies without having to copy data unnecessarily to remote locations.

Oracle

SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.

Microsoft

Sample Customers

Amplifon

1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo

Buyer's Guide

Oracle Data Integrator Cloud Service vs. SSIS

April 2025

Free Report: Oracle Data Integrator Cloud Service vs. SSIS

Find out what your peers are saying about Oracle Data Integrator Cloud Service vs. SSIS and other solutions. Updated: April 2025.

DOWNLOAD NOW

847,862 professionals have used our research since 2012.

See our Oracle Data Integrator Cloud Service vs. SSIS report.

See our list of best Cloud Data Integration vendors.

We monitor all Cloud Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.