![Informatica PowerExchange [EOL] Logo](https://images.peerspot.com/image/upload/c_scale,dpr_3.0,f_auto,q_100,w_64/gaXfZsz7e51ho14qsm4PpcUN.jpg?_a=BACMTiGT)
Informatica PowerExchange and SSIS are both data integration tools with distinct strengths. PowerExchange excels in standardization and scalability, especially for non-Oracle database integrations, but SSIS often gets the edge for its ease of use and cost efficiency, as it is included with SQL Server and incurs no additional cost.
Features: PowerExchange offers robust data integration and real-time capabilities, efficiently handling large datasets and non-standard databases. Its integration with databases like Teradata enhances performance and scalability. SSIS, known for its user-friendliness, provides strong integration capabilities with SQL Server, featuring drag-and-drop functionality and support for various data sources, offering flexibility in scripting and connectivity for efficient data transformations.
Room for Improvement: PowerExchange's pricing and real-time processing enhancements, as well as support for newer data types, require improvement. User interface and connectivity could also be enhanced. SSIS users seek better scalability, integration with non-Microsoft tools, and improved real-time processing support. Attention is needed for debugging, error logging, and easier setup processes.
Ease of Deployment and Customer Service: Both PowerExchange and SSIS offer flexible deployment options, including on-premises and cloud. PowerExchange users report varied support experiences, whereas SSIS benefits from straightforward integration with Microsoft products, leveraging Visual Studio familiarity. Technical support experiences for both vary, with some users facing delays.
Pricing and ROI: PowerExchange is perceived as expensive but valuable for its comprehensive features, while SSIS is cost-effective and part of the SQL Server license. PowerExchange's challenges with pricing are balanced by benefits in large-scale environments, whereas SSIS offers a straightforward and budget-friendly pricing structure for many organizations.
It is considered cost-efficient because it leads to the re-utilization of channels and platforms, which saves time and money.
The tool has made us tremendously more efficient and saved us a significant amount of money.
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
Their support aligns with what I have experienced with Informatica data quality teams, and it is quite effective.
Informatica's technical support team is very supportive and provides help whenever required.
The support was good enough, and they were able to resolve all the issues I raised in the past.
The first line of support needs to be more knowledgeable.
I would rate the scalability of SSIS at a 7 because we are able to use various third-party items with it, allowing for functionality with a number of different things.
Technical errors sometimes occur, such as network breakages at the source level, which breaks connectivity.
It processes large volumes of data quickly.
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.
The addition of data quality dashboards or measures would also help in profiling data to assess its health before sharing or moving it.
Within the South African context, if you are getting your enterprise agreement from First Technology, they don't provide support.
SSIS could be integrated with more services, such as Power BI, to make the reporting structures more user-friendly.
The logging capabilities could be improved, particularly for error logging.
Informatica PowerExchange is considered cost-efficient due to reduced number of APIs needed.
The pricing and cost depend heavily on SAP's licensing structure, especially if using SAP integration services.
However, it could be a bit cheaper.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
It was included in our licensing for SQL server, and our licensing for SQL server was extremely cheap, making it a very good price point for us.
It also reduces the number of APIs needed for new integrations by offering a unified exchange platform.
The primary advantage of Informatica PowerExchange is being able to extract data from source systems that Informatica does not natively support.
PowerExchange is one of the best software solutions to build integrations with non-Oracle or standard database services, especially for SAP and Hana products.
I would rate it at a 10 as it is highly reliable; we have never had any problems with it.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
The main benefits SSIS provides for my company is to streamline processes.
![Informatica PowerExchange [EOL] Logo](https://images.peerspot.com/image/upload/c_scale,dpr_3.0,f_auto,q_100,w_40/gaXfZsz7e51ho14qsm4PpcUN.jpg?_a=BACMTiGT){kind=small}
| Company Size | Count |
|---|---|
| Small Business | 8 |
| Midsize Enterprise | 3 |
| Large Enterprise | 12 |
| Company Size | Count |
|---|---|
| Small Business | 27 |
| Midsize Enterprise | 19 |
| Large Enterprise | 58 |
![Informatica PowerCenter vs Informatica PowerExchange [EOL] Logo](https://images.peerspot.com/image/upload/c_scale,dpr_3.0,f_auto,q_100,w_30/gaXfZsz7e51ho14qsm4PpcUN.jpg?_a=BACMTiGT){kind=small}
![Oracle Data Integrator (ODI) vs Informatica PowerExchange [EOL] Logo](https://images.peerspot.com/image/upload/c_scale,dpr_3.0,f_auto,q_100,w_30/8g8t9pkm2lzijgdvjrnla0p56jcn.jpeg?_a=BACMTiGT){kind=small}
![SharePlex vs Informatica PowerExchange [EOL] Logo](https://images.peerspot.com/image/upload/c_scale,dpr_3.0,f_auto,q_100,w_30/gx7fdc2s39xboxn6pa3oukdu9s75.png?_a=BACMTiGT){kind=small}
![Qlik Talend Cloud vs Informatica PowerExchange [EOL] Logo](https://images.peerspot.com/image/upload/c_scale,dpr_3.0,f_auto,q_100,w_30/bceq7xfg24vcset503xm0hyyr88r.jpg?_a=BACMTiGT){kind=small}
Informatica PowerExchange [EOL] offers advanced data integration capabilities, emphasizing data transformation, real-time integration, and connectivity to diverse data sources, ensuring seamless access and management of big data in complex environments.
Informatica PowerExchange [EOL] is a robust tool for managing data integration and transformation processes. It supports connectivity to numerous sources, enabling real-time data capture and transformation. With native connectors and APIs, it allows seamless integration, ensuring data mapping across data formats. While strong at data handling and integration, improvements in pricing, real-time processing, and enhanced technical support are necessary. Expanded cloud integration and improved high availability will further bolster its efficiency in managing extensive datasets, supporting ETL, and integrating systems like SAP.
What are the most important features of Informatica PowerExchange?Informatica PowerExchange [EOL] is implemented widely in sectors requiring robust data integration solutions. It serves industries such as finance, healthcare, and retail, facilitating the creation of data warehouses and lakes. Used for ETL processes and operational analytics, it integrates systems like Hadoop, Oracle, and legacy environments, driving efficient communication and information sharing.
SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.
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.
![Informatica PowerExchange [EOL] vs. SSIS report](https://www.peerspot.com/assets/media/images/icons/pdf-c33db68f.svg){kind=icon}
