We performed a comparison between Informatica PowerExchange, Oracle Integration Cloud Service, and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The user interface and user experience are perfectly all right."
"The scalability is excellent."
"It is easy to integrate the solution with other tools."
"The solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems."
"The product’s flexibility is valuable."
"Overall, it's a good tool. It's currently number one on the market. It pretty much has all the necessary capabilities to pull the incremental data from the source system, technically speaking."
"This product is easy to install and it can be done in a few hours."
"The agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."
"The lack of features in something like Oracle Integration Cloud leaves some room for leads implementation partners like us"
"People are able to scale up, learn it quickly, and start delivering."
"OIC's accuracy is quite good."
"Technical support responds quickly."
"The most valuable feature of Oracle Integration Cloud Service is its ease of use. We do not depend on any tool to develop it. Everything is on the browser and is easy to integrate, even for someone who does not understand a lot about coding."
"The initial setup of Oracle Integration Cloud Service was easy."
"It is a scalable solution."
"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."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"We can connect with multiple data sources easily using an external connector in SSIS."
"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."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"It's already very user-friendly and has a good dashboard."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"The solution could be made more user-friendly. The configurations are also quite difficult."
"The major shortcoming of PowerExchange is high availability and failover. None of the versions we've used to date have had the out-of-the-box ability to enable failover and high-availability requirements. This is a significant challenge and risk."
"I would like the stability to improve."
"Integration with the largest number of databases and other systems would be important."
"Pushdown optimization could be improved."
"The product's high costs can be an area of concern where improvements are required."
"The connectivity with T24 core banking could be improved."
"I would like to have easier integration with cloud platforms."
"Sometimes, the tech support is slow to get back to us. We have had to wait up to two weeks for a response."
"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."
"Now the platform is not built in a way that you can define."
"The solution is expensive."
"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."
"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."
"We would love to have more and more ready-to-use interfaces from Oracle."
"The solution doesn't currently have a fully fledged workflow feature like they have in OIM."
"We have issues with SSIS connectors while extracting data from Excel sources."
"The performance of SSIS could improve when comparing it to Oracle Database."
"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 interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"It hangs a lot of the time."
"It would be nice if you could run SSIS on other environments besides Windows."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"The solution could improve on integrating with other types of data sources."
More Oracle Integration Cloud Service Pricing and Cost Advice →