We performed a comparison between Informatica PowerCenter, SAS Data Management, and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"The number of docs has been reduced drastically, which is very good."
"It's a very powerful tool you can use to load data, get data, do the drawing between the tables, and put into the packet in a very fast way."
"To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline. Usually, you need to have a platform to be able to integrate with different technologies, including legacy data such as the mainframe. The platform should also be rich enough to transform the data per your business requirement, with no restrictions. Rich integration and rich transformation capabilities are the two key capabilities in Informatica PowerCenter. The solution also offers ease of use. Another valuable feature of Informatica PowerCenter is the drag-and-drop integration because it's GUI-based, similar to IBM and Oracle."
"I would recommend that others considering the solution go ahead and use it for any batch and high volume loads with complex transactions."
"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."
"We have found the PowerCenter and B2B data transformation most valuable."
"If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful."
"Its robustness is valuable. It is a full-fledged suite. We have a data warehouse model, and there are also a lot of data quality management tools. The repository and all other tools are there. So, it is a full package in terms of reporting tools."
"The solution is very stable. We haven't faced any issues with glitches or bugs. We haven't had any crashes."
"I am impressed with the tool's ability to customize."
"If you compare it to SQL, the memory and development times are very quick."
"The technical support is excellent."
"The product offers very good flexibility."
"The tool is reliable, quick, and powerful."
"In terms of which features I have found most valuable, I would say the importing and exporting features. Additionally, the data sorting, categorizing and summarizing features, especially how it can summarize based on categories. These are the key features."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"We can connect with multiple data sources easily using an external connector in SSIS."
"The simplicity of the solution is great. The solution also offers excellent integration."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"The initial setup was easy."
"The performance and stability are good."
"The UI is a little outdated."
"Its licensing can be improved. It should be features-wise and not bundle-wise. A bundle will definitely be costly. In addition, we might use one or two features. That's why the pricing model should be based on the features. The model should be flexible enough based on the features. Their support should also be more responsive to premium customers."
"This product is going to decommission in the next couple of years."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"The solution does not scale."
"I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases."
"In the future, I would like to see Informatica PowerCenter integrate a more powerful dashboard."
"The price of the product is an area of concern where improvements are required, considering the fact that the present licensing charges of the tool are expensive."
"The solution is quite expensive and hard to install/configure."
"We find we often have to go back and re-train users when there are changes made to the solution because the changes are not intuitive."
"Very little needs to improve but perhaps a nicer graphic interface and remaining competetive in the growing field of data analytics."
"With SAS Data Management, you have to purchase an external driver, configure all of the tables for all of the data that you will extract from Salesforce. It's not a straightforward process."
"We implemented it a while ago, and we are trying to improve the data delivery performance. We are looking into how to get faster and automated reporting. We would need better designs and workflows."
"One problem is accessing the data using a solution other than SAS. The SAS data, which we create in the SAS, cannot be accessed by other tools. We can't open those data in other applications. So we need to have that application in place."
"The pricing of the solution needs to be improved. They need to work to make it more affordable."
"The solution could use better documentation."
"I would like to see better integration with Power BI."
"Tuning using this solution requires extensive expertise to improve performance."
"We'd like more integration capabilities."
"It's a legacy tool, that is nearing the end of its useful life."
"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."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"There were some issues when we tried to connect it to data storage. It was a connection issue."