Informatica PowerCenter and SSIS both compete in the data integration tools category. Informatica PowerCenter has the upper hand with extensive error-handling capabilities and collaboration across development teams, while SSIS is noted for its affordability and seamless Microsoft integration.
Features: Informatica PowerCenter handles large data volumes, supports complex transformations, and provides robust security and performance features. It facilitates collaboration for development teams and offers vast scalability. SSIS integrates smoothly within the Microsoft ecosystem, offers strong performance for simple data processes, and is affordable.
Room for Improvement: PowerCenter faces criticism for its high cost, complex setup, outdated GUI, and limitations in real-time processing and cloud connectivity. SSIS is challenged by debugging difficulties, bugs affecting reliability, and lacking built-in API engines and comprehensive data source support, which may require third-party tools.
Ease of Deployment and Customer Service: PowerCenter is primarily deployed on-premises with a robust but occasionally slow support system. Its technical support is effective but sometimes criticized for slow initial responses. SSIS, often on-premises with cloud integration, benefits from Microsoft's ecosystem and has well-regarded customer service, although complex issues can cause delays.
Pricing and ROI: PowerCenter is known for its high price, offering value to large enterprises with advanced data needs. It's seen as a quality investment for complex data integrations. SSIS offers a more budget-friendly solution, integrated with SQL Server, economical for organizations using Microsoft products. However, additional costs can arise from required adapters and third-party components.
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
I like the technical support provided by Informatica.
Informatica PowerCenter is stable and can scale well.
It processes large volumes of data quickly.
Utilizing more stored procedures from Oracle databases in an easy way would significantly boost performance.
SSIS has a difficult learning curve when dealing with complex transformations.
I find that the pricing and licensing for Informatica PowerCenter align with its quality.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
The system supports real-time integration, which is essential for many of my tasks.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
Informatica PowerCenter is a data integration and data visualization tool. The solution works as an enterprise data integration platform that helps organizations access, transform, and integrate data from various systems. The product is designed to support companies in the full cycle of a project, from its initial rollout to critical deployments. Informatica PowerCenter allows developers and analysts to collaborate while accelerating the work process to deploy projects within days instead of months.
The Advanced edition of the product provides an additional real-time engine which allows companies to have always-on enterprise data integration. This ensures seamless collaboration and increment of data lineage visibility and impacts analysis.
The Premium edition of the solution offers an early warning system that detects unexpected behaviors or incorrect utilization of resources in the workflows and alerts companies in the case that these occur. This version of the product also offers automatic data validation, which ensures data accuracy and reduces testing time and expenditure of resources for by up to 90%.
Informatica PowerCenter Features
The product provides users with various features which allow them to execute data integration initiatives such as analytics, data warehousing, data governance, consolidation, and application migration. The features of the solution include:
Informatica PowerCenter Benefits
The benefits of using Informatica PowerCenter include:
Reviews from Real Users
Yahya T., a developer and architect at L'Oreal, says the product is stable, provides good support, and integrating it with other systems is very fast.
Mohamed E., a senior manager for Data management and data governance at a tech company, says PowerCenter is stable, mature, and offers flexibility in building the pipeline and has a drag-and-drop mode because it's GUI-based; technical support is brilliant.
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.