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 solution is scalable."
"It is a scalable solution."
"The out-of-box integration between Oracle and SAP is really beneficial"
"The most valuable feature is the ease of customization."
"The dashboard provided by Oracle Integration Cloud for monitoring and error handling is very intuitive."
"The most valuable feature of Oracle Integration Cloud Service is its performance."
"OIC offers a number of pre-built technology and SaaS adapters for high productivity for a wide range of target systems, both in-house via agents and cloud/SaaS, via a very flexible range of interfaces."
"The Oracle integration tool is the most comfortable tool for using those Oracle products."
"The most important features are it works well and provides self-service BI."
"SSIS integrates well with SQL servers and Microsoft products."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"The solution's customer service could be better."
"Configurable timeouts on each connection would be good."
"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."
"Make it more similar to the on-premises features. For example, if you can edit the code directly rather than just dragging and dropping, or if you can edit the examples by going into the background, and one-click migration, I'd like to see included in the next release."
"The solution is expensive."
"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."
"In designer mode, sometimes the browser closure or other unknown issues can cause strange behavior, which requires a restart."
"Options for scaling could be improved."
"I would like to see more features in terms of the integration with Azure Data Factory."
"We have issues with SSIS connectors while extracting data from Excel sources."
"We'd like them to develop data exploration more."
"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."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
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), Mule Anypoint Platform, AWS Glue, Oracle GoldenGate and AWS AppSync, 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.