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."Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"I like the completeness of the way I can build ETL workflows."
"Once you have learned Informatica, it is very easy to use."
"The most valuable feature of Informatica PowerCenter is the flow designer functionally. It is the best out of any ETL tool. Additionally, the solution is reliable and trustable in dealing with large data sources anytime. When we're using billions of data transactions, it's smooth."
"The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"UI-based ability to create data mapping."
"It's a complete package, which is why we use this solution."
"It is easy to set up the solution."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"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."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"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."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"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."
"It is easier to use than other technical open-source technologies."
"Stability-wise, I rate the solution a ten out of ten."
"Workato is low code, intuitive, and easy to use."
"The most valuable features are easy integration, quick tab to develop, quick tab to market, and interactive integration platform."
"Their automation and workflows are very strong, and you can build the workflows very easily and quickly."
"It's easy to understand, makes flows and is efficient."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"The solution does not scale."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"Informatica, in my opinion, is very rigid and not very flexible, whereas platforms like Alteryx or Matillion are very flexible and agile."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"Compared to solutions offering similar functionalities, Informatica PowerCenter is not very flexible regarding customized integrations."
"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."
"The solution could improve by having quicker release updates."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
"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."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"The management dashboard in the solution is an area with shortcomings that needs improvement."
"A limitation is that their cloud presence is only in North America and Europe."
"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."
"I would like to see the dashboarding and reporting processes improved."
"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."
"It is tedious to make a tailor-fit function."
"From the deployment point of view, our customers encounter platform downtime where it does not serve the actual request on the systems."