Informatica PowerExchange and StreamSets are contenders in the data integration and transformation category. Informatica PowerExchange seems to have an edge due to its robust data transformation capabilities, although StreamSets offers a more user-friendly and flexible implementation.
Features: Informatica PowerExchange offers robust data transformation, excellent connectivity across diverse data sources, and strong Change Data Capture (CDC) capabilities. These features make it ideal for complex data environments. StreamSets is known for its ease of configuring data pipelines, with support for both batch and streaming data and a data drift feature that detects inconsistencies. It relies on graphical interfaces that require minimal coding for integration with various platforms like AWS and Azure.
Room for Improvement: Informatica PowerExchange could improve its integration with more databases and simplify its pricing model. It also needs to support additional data types and enhance real-time transformation capabilities. StreamSets could enhance its logging and security features and provide better support for multiple SAP HANA tables. Improvements in its user interface and guidance, along with reducing high training costs, would benefit non-technical users.
Ease of Deployment and Customer Service: Informatica PowerExchange is mainly deployed on-premises but can adapt to hybrid and public clouds, with customer support reviews ranging from average to good, though response times can be slow. StreamSets is versatile for public and hybrid cloud deployments and provides flexible environment adaptations. Customer service for StreamSets is generally responsive but can also experience delays.
Pricing and ROI: Informatica PowerExchange is perceived as costly, with a complex licensing structure potentially leading to high expenses. However, it offers good ROI through its comprehensive integration and transformation capabilities. StreamSets presents a flexible pricing model, including open-source options, and is seen as expensive for small businesses. Both solutions add significant value to data processing efficiency, although ROI measurements can be intangible.
Their support aligns with what I have experienced with Informatica data quality teams, and it is quite effective.
The support was good enough, and they were able to resolve all the issues I raised in the past.
IBM technical support sometimes transfers tickets between different teams due to shift changes, which can be frustrating.
Technical errors sometimes occur, such as network breakages at the source level, which breaks connectivity.
One area that could be improved is performance, as PowerExchange sometimes has less performance compared to native connectors when dealing with a huge volume of data.
It would be beneficial if StreamSets addressed any potential memory leak issues to prevent unnecessary upgrades.
The pricing and cost depend heavily on SAP's licensing structure, especially if using SAP integration services.
PowerExchange is one of the best software solutions to build integrations with non-Oracle or standard database services, especially for SAP and Hana products.
The primary advantage of Informatica PowerExchange is being able to extract data from source systems that Informatica does not natively support.
It allows a hybrid installation approach, rather than being completely cloud-based or on-premises.
Informatica PowerExchange Connectors provides high performance, out-of-the-box connectivity without having to develop custom data access programs.
StreamSets is a data integration platform that enables organizations to efficiently move and process data across various systems. It offers a user-friendly interface for designing, deploying, and managing data pipelines, allowing users to easily connect to various data sources and destinations. StreamSets also provides real-time monitoring and alerting capabilities, ensuring that data is flowing smoothly and any issues are quickly addressed.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.