We performed a comparison between Informatica PowerExchange, 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."The user interface and user experience are perfectly all right."
"The solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems."
"The product’s flexibility is valuable."
"It is easy to integrate the solution with other tools."
"The main benefit of PowerExchange is its native real-time capabilities. Competing tools are counting on third-party packages or Oracle to offer real-time capabilities. However, Informatica has a native ability to scan the data on the file system level and capture the changes almost instantly when I push it to the consumers. The solution has a powerful built-in replication engine."
"Provides a significant amount of control over the landscape and overall implementation."
"Overall, it's a good tool. It's currently number one on the market. It pretty much has all the necessary capabilities to pull the incremental data from the source system, technically speaking."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"The tool is reliable, quick, and powerful."
"If you compare it to SQL, the memory and development times are very quick."
"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."
"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."
"The product offers very good flexibility."
"I am impressed with the tool's ability to customize."
"This is an established product with powerful data analysis and varied options for user entry points."
"SSIS' most valuable feature is its reporting services."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"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."
"It is easy to set up the product."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"The technical support is very good."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"V10.2 is very stable, but we are still struggling to make V10.5 stable. We found services that were down, and PowerExchange stopped working."
"They should make it quick and easy for use of citizen data integration or for people or integrators developing at the customer side. They could be development teams within the business team. For them, the product owners can consider making it a little bit more seamless and a little bit more democratized."
"The one place where it could be improved is definitely pricing. That's a very big problem. It depends product to product, but pricing is an issue."
"Should diversify more, maybe with a reporting and visualization utility,"
"The major shortcoming of PowerExchange is high availability and failover. None of the versions we've used to date have had the out-of-the-box ability to enable failover and high-availability requirements. This is a significant challenge and risk."
"The solution could be made more user-friendly. The configurations are also quite difficult."
"The product is not suitable for application integration."
"I would like the stability to improve."
"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."
"I would like the tool to include the ability to automate the modifications of the integrations."
"The pricing of the solution needs to be improved. They need to work to make it more affordable."
"The solution is quite expensive and hard to install/configure."
"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."
"Very little needs to improve but perhaps a nicer graphic interface and remaining competetive in the growing field of data analytics."
"The solution could use better documentation."
"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."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"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."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"The creation of the measure in the DAC's model could be improved."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."