We performed a comparison between Informatica PowerCenter, SSIS, and Workato based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."It's very easy to use it to develop mappings and workflows."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"It's a complete package, which is why we use this solution."
"Deployment was simple and straightforward."
"What I like most about Informatica PowerCenter is that it's the best tool in the market for data integration. Currently, I work in L'Oréal, where a new system from SAP is used. Informatica PowerCenter integration with SAP is very, very fast and very, very simple, so you have the server flow from SAP, and through Informatica PowerCenter, you can ingest the data and make that data available for the business more quickly."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"I like the completeness of the way I can build ETL workflows."
"It is UI friendly and has all the advantages of an ETL tool."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"The simplicity of the solution is great. The solution also offers excellent integration."
"The solution is easy to use and developer friendly."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"We can connect with multiple data sources easily using an external connector in SSIS."
"SSIS' best feature is SFTP connectivity."
"The initial setup of this solution is very straightforward."
"It is easier to use than other technical open-source technologies."
"Stability-wise, I rate the solution a ten out of ten."
"The most valuable features are easy integration, quick tab to develop, quick tab to market, and interactive integration platform."
"It's easy to understand, makes flows and is efficient."
"It is very easy to use. It takes complex workloads away, and it provides very smooth integration. It has got a lot of out-of-the-box connectors. It has got a lot of out-of-the-box APIs, which makes it really easy to integrate with applications for different use cases, whether it is in finance, HR, or customer operations. It is by far our favorite integration product."
"Their automation and workflows are very strong, and you can build the workflows very easily and quickly."
"Workato is low code, intuitive, and easy to use."
"The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"They should release new versions for the solution's on-premises setup."
"The reputation of Informatica is that it is expensive."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"Integrating new tools can be tricky and challenging."
"Now they are migrating to a new version, and they have something that is called Informatica Developer. Previously, they just had PowerCenter. Now, when they move everything to Informatica Developer it's not as good or stable like it was when it was PowerCenter, though it has some nice features. This Developer tool could be better."
"Integration with Artificial Intelligence would benefit this solution."
"The high prices attached to the product can be an area of concern where improvements are required."
"It's a legacy tool, that is nearing the end of its useful life."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"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."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"I would like to see the dashboarding and reporting processes improved."
"Workato's Extract, transform, and load (ETL) and extract, load, and transform (ELT) are not very strong and could be improved for very complex transformations."
"The only minor drawback would be if there was a UI at the front of it, for apps and for a portal as well, it would make it really easy. It would be really useful if there were more apps capabilities."
"The management dashboard in the solution is an area with shortcomings that needs improvement."
"From the deployment point of view, our customers encounter platform downtime where it does not serve the actual request on the systems."
"It is tedious to make a tailor-fit function."
"A limitation is that their cloud presence is only in North America and Europe."