We performed a comparison between Informatica PowerCenter, Pentaho Data Integration and Analytics, and SAS Data Integration Server based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."Has a good visual tool for data mapping."
"Can manage a huge quantity of data and provide reliability."
"Informatica PowerCenter is a very good ETL tool."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"Technical support, and their approach is good. They have a support portal and support tickets. If you open a ticket it has multiple levels of severity from level one to very high or critical."
"It has helped us monetize."
"The greatest feature is that it is very easy to have someone come in and jump right in. It is one of the nicest tools in terms of getting a person acquainted quickly."
"The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness."
"I can create faster instructions than writing with SQL or code. Also, I am able to do some background control of the data process with this tool. Therefore, I use it as an ELT tool. I have a station area where I can work with all the information that I have in my production databases, then I can work with the data that I created."
"It's very simple compared to other products out there."
"Provides a good open source option."
"The abstraction is quite good."
"It's my understanding that the product can scale."
"The amount of data that it loads and processes is good."
"One of the most valuable features is the ability to create many API integrations. I'm always working with advertising agents and using Facebook and Instagram to do campaigns. We use Pentaho to get the results from these campaigns and to create dashboards to analyze the results."
"Flexible deployment, in any environment, is very important to us. That is the key reason why we ended up with these tools. Because we have a very highly secure environment, we must be able to install it in multiple environments on multiple different servers. The fact that we could use the same tool in all our environments, on-prem and in the cloud, was very important to us."
"The most valuable feature of the solution is its amazing capabilities in regard to data handling."
"The solution is very stable."
"The solution offers very good data manipulation and loading."
"I found it is kind of weird that not all of the mapping changes are treated as true changes."
"Lacks ability to calculate cost of the product."
"The licensing is difficult."
"The solution could have better documentation on basic steps or blocks that specify what to do."
"This product is going to decommission in the next couple of years."
"It should be more cloud-centric than on-prem-centric."
"The solution does not scale."
"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 product needs more plugins."
"I would like to see more improvements with AS400 DB2."
"I could not connect to our Hadoop environment in an easy and flexible way, and it was important to scale our data warehouse."
"The performance could be improved. If they could have analytics perform well on large volumes, that would be a big deal for our products."
"The testing and quality could really improve. Every time that there is a major release, we are very nervous about what is going to get broken. We have had a lot of experience with that, as even the latest one was broken. Some basic things get broken. That doesn't look good for Hitachi at all. If there is one place I would advise them to spend some money and do some effort, it is with the quality. It is not that hard to start putting in some unit tests so basic things don't get broken when they do a new release. That just looks horrible, especially for an organization like Hitachi."
"The web interface is rusty, and the biggest problem with Pentaho is debugging and troubleshooting. It isn't easy to build the pipeline incrementally. At least in our case, it's hard to find a way to execute step by step in the debugging mode."
"In the Community edition, it would be nice to have more modules that allow you to code directly within the application. It could have R or Python completely integrated into it, but this could also be because I'm using an older version."
"I would like to see support for some additional cloud sources. It doesn't support Azure, for example. I was trying to do a PoC with Azure the other day but it seems they don't support it."
"The initial setup of SAS Data Integration Server was complex."
"The transform tool has limited access. They should make it more flexible."
"So I would like to see improved integration with other software."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →