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."I particularly like the drag-and-drop feature for designing integrations and processes."
"It is a scalable solution."
"The initial setup is easy."
"The most valuable features of this solution are the SFTP adapters, file adapters, and risk adapters, that we use in everyday projects."
"Oracle Integration Cloud Service offers a lot of adaptors."
"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."
"It's very easy to get started on the solution. It's also easy to maintain, scale, and integrate according to cost factors."
"The Oracle integration tool is the most comfortable tool for using those Oracle products."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"It's already very user-friendly and has a good dashboard."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"There are a few features that we noticed are not in the cloud. There are some improvements needed. One example is the graphical user interface that needs to improve, it could be easier to use."
"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."
"There is a payload size limit and we're unable to integrate some legacy applications."
"Oracle Integration Cloud Service can improve file handling. Currently, our real-time file polling limitation is 10 MB, if that size can be increased it would be helpful. For example, increasing the size from 10 MB to 1 GB."
"Our client was quite concerned about the cost, which is something that could be reduced."
"The solution doesn't currently have a fully fledged workflow feature like they have in OIM."
"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."
"It would be helpful if there were more tutorials or documentation to learn about Oracle Integration Cloud Service."
"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."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"The high prices attached to the product can be an area of concern where improvements are required."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"It needs more integration tools, so you can connect to different sources."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
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.
