We performed a comparison between Oracle Integration Cloud Service and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Integration Platform as a Service (iPaaS) solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The OIC is very good."
"Technical support responds quickly."
"People are able to scale up, learn it quickly, and start delivering."
"The most valuable feature is the ease of customization."
"Oracle Integration Cloud Service integrates well and is user-friendly. If you are not a developer or ops engineer you can still use the solution with ease. You do not need to have developers' knowledge, you can easily adapt and learn quickly to integrate the services. They have good documentation."
"The most important part would be the use of connectors. The significant number of cloud connectors available for active integration is its value."
"It's very easy to get started on the solution. It's also easy to maintain, scale, and integrate according to cost factors."
"The most valuable features of this solution are the SFTP adapters, file adapters, and risk adapters, that we use in everyday projects."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"The interface is very user-friendly."
"The initial setup was easy."
"SSIS' best feature is SFTP connectivity."
"We would love to have more and more ready-to-use interfaces from Oracle."
"While most of the adapters are available through Oracle Integration Cloud Services, they do not have a lot of features. I would like to see some enrichment in this area and for the solution to go deeper into the applications and upgrade the adapters."
"Configurable timeouts on each connection would be good."
"They should provide tutorials for beginners to learn about the processes."
"The logging capabilities could be enhanced. Currently, logs are only retained for a few days, which can be inconvenient for administrators. Ideally, we'd like the option to configure log retention periods, like a month or fifteen days, instead of the current one-week limit."
"Oracle Integration Cloud Service can improve the downloading and uploading of files. I've submitted this issue to the Oracle Idea Labs. The issue is from the front end of Oracle Integration Cloud, we cannot download or upload a file directly or drag and drop it."
"The solution is expensive."
"There is a payload size limit and we're unable to integrate some legacy applications."
"This solution needs full support for real-time processing."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
"We'd like more integration capabilities."
"I would like to see more features in terms of the integration with Azure Data Factory."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"Improvement as per customer requirements."
"The creation of the measure in the DAC's model could be improved."
"We have issues with SSIS connectors while extracting data from Excel sources."
More Oracle Integration Cloud Service Pricing and Cost Advice →
Oracle Integration Cloud Service is ranked 3rd in Integration Platform as a Service (iPaaS) with 32 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Oracle Integration Cloud Service is rated 8.0, while SSIS is rated 7.6. The top reviewer of Oracle Integration Cloud Service writes "An integration tool that is highly compatible and easy to maintain". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Oracle Integration Cloud Service is most compared with Oracle Data Integrator (ODI), AWS Glue, Mule Anypoint Platform, Oracle GoldenGate and Talend Data Management Platform, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our Oracle Integration Cloud Service vs. SSIS report.
We monitor all Integration Platform as a Service (iPaaS) 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.