We performed a comparison between Informatica PowerCenter, SAS Access, 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 most complex task, in this case, was to read and transform BLOB data, and Java transformation in Informatica Power Center was a great solution."
"It works with any multi-databases, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use."
"Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System."
"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."
"The technical support is excellent."
"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."
"PowerCenter performs well during data transformation and optimization."
"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."
"The most valuable feature is you have native access to the external databases."
"The most valuable aspect of the solution is the ease of access to the data in those databases."
"The most valuable part of SAS/ACCESS is what it is made for: connecting to remote systems that are not part of your physical SAS environment."
"Overall, it's a good product."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"The setup was easy. All Microsoft products are easy to set up."
"It is easy to set up the solution."
"SSIS is easy to use."
"The UI is very user-friendly."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"It would be better if I could do all the work within a single window. If I'm working on any mapping and if I have to switch to sessions, I have to open a new window altogether. If I have to get into workflows, I have to open a new window. It was also very expensive. In the next release, I would like it to be more user-friendly."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"The initial setup is not straightforward. You need expertise to do it."
"Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design."
"This solution needs the functionality to do batch processing of data. It also lacks connectivity to NoSQL, unstructured data sources."
"Its scalability can be improved. It is not scalable."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"Lacks ability to calculate cost of the product."
"I can't really recall any missing feature or general improvement that is needed. We don't really add too many new kinds of databases and therefore our needs are already met."
"The pricing model needs to be reconsidered and adjusted."
"The solution can provide access to the newer databases that come out sooner."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
"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."
"We'd like more integration capabilities."
"I would like to see more features in terms of the integration with Azure Data Factory."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"The performance of SSIS could improve when comparing it to Oracle Database."
"Generic processes should be used instead of custom code for each table."