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 data transformation is the solution's most valuable feature."
"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."
"The product’s flexibility is valuable."
"The product's initial setup phase was not complex. The tool is easy to install onto any of the servers, and you can integrate it."
"The user interface and user experience are perfectly all right."
"The solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems."
"From the product feature or product capability perspective, the aspects around integration, transformation, and standardization are valuable. It's fairly easy to use. It has a GUI-based interface."
"Mainstream integration and real-time integration are the best features."
"The most valuable features of Oracle Integration Cloud Service are the seeded integrations with many communication platforms, such as Slack and emails. It works best for the historical communication methods. Those are still prevalent with all the other clients. When we are doing the integrations, it makes it a little bit easier for us to communicate the same output over Slack, rather than sending out an email and downloading the report. The number of seeded functionalities within the Oracle Integration Cloud Service platform is better."
"It's very easy to get started on the solution. It's also easy to maintain, scale, and integrate according to cost factors."
"The out-of-box integration between Oracle and SAP is really beneficial"
"The solution is scalable."
"The initial setup of Oracle Integration Cloud Service was easy."
"The OIC is very good."
"The most important part would be the use of connectors. The significant number of cloud connectors available for active integration is its value."
"Oracle Integration Cloud Service is a really good product and the ROI is very good with it. It lowers development time. A development cycle that may have taken a year without Oracle Integration Cloud Service can drop down to three or four months with it."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"The solution is easy to use and developer friendly."
"It is easy to set up. The deployment is also very quick."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"The solution is stable."
"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."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The performance and stability are good."
"Should diversify more, maybe with a reporting and visualization utility,"
"V10.2 is very stable, but we are still struggling to make V10.5 stable. We found services that were down, and PowerExchange stopped working."
"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."
"Pushdown optimization could be improved."
"The solution needs better integration with other tools."
"I would like the stability to improve."
"Apache Spark has a machine learning algorithm, an area where Informatica PowerExchange lacks."
"The one place where it could be improved is definitely pricing. That's a very big problem. It depends product to product, but pricing is an issue."
"If an inbound file is larger than one GB, it cannot be transformed within Oracle."
"The solution is expensive."
"The support and resources were lacking — they weren't there."
"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."
"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."
"Sometimes, the tech support is slow to get back to us. We have had to wait up to two weeks for a response."
"Lacks features for more complex integrations."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"Performance could be better."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"The solution could improve on integrating with other types of data sources."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
More Oracle Integration Cloud Service Pricing and Cost Advice →