Informatica PowerExchange and Matillion Data Productivity Cloud compete in the data transformation and integration space. Matillion seems to have the upper hand due to its ease of use and cloud-native features.
Features: Informatica PowerExchange is known for its robust data transformation and integration capabilities, offering native real-time features and broad scalability. It efficiently handles diverse data formats and supports comprehensive data lifecycle management. Matillion Data Productivity Cloud boasts an intuitive interface, seamless integration with AWS, and flexible pipeline orchestration, making it efficient for quick setups.
Room for Improvement: Informatica PowerExchange faces challenges with high costs, complex installations, and real-time data processing. Users express a need for enhanced high availability and integration features. Matillion requires more frequent updates, better documentation, and improved database integrations. It also needs to address challenges with concurrent workloads and real-time data capture.
Ease of Deployment and Customer Service: Informatica PowerExchange is primarily deployed on-premises, leading to complex setups but fitting traditional infrastructure. Matillion's design for cloud environments, especially AWS, makes deployment easier while benefiting from cloud-native features. Customer service experiences for Informatica vary, while Matillion could improve its technical support responsiveness.
Pricing and ROI: Informatica PowerExchange is more expensive with costs based on capacity and connector fees. Nevertheless, it provides ROI through streamlined operations. Matillion offers flexible pay-as-you-go pricing in the cloud, making it budget-friendly for smaller teams. Both solutions deliver significant ROI, though Matillion’s model is more adaptable for cloud-native operations.
It is considered cost-efficient because it leads to the re-utilization of channels and platforms, which saves time and money.
Consequently, we adjusted our processes to use Matillion Data Productivity Cloud only for extraction and ingestion, while Snowflake handled all transformations and jobs.
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.
They communicate effectively and respond quickly to all inquiries.
Depending on the nature of data sets, volume, and mixture of different data, the scalability could be improved as manual code writing is still required.
The autoscale process works well, allowing the system to start another node automatically if the first machine reaches 80% capacity.
Technical errors sometimes occur, such as network breakages at the source level, which breaks connectivity.
The addition of data quality dashboards or measures would also help in profiling data to assess its health before sharing or moving it.
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 main areas for improvement are AI features and scalability.
Connections to BigQuery for extracting information are complex.
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.
Matillion Data Productivity Cloud offers discounts and special deals, especially when dealing with high-volume clients or fewer existing clients in specific regions, like Spain.
The pricing is moderate, neither expensive nor cheap.
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.
The predefined connectors eliminate the need to write code for connectivity.
Matillion Data Productivity Cloud is effective for ingest functions, particularly when moving information to Snowflake and performing many transformations.
Company Size | Count |
---|---|
Small Business | 8 |
Midsize Enterprise | 3 |
Large Enterprise | 12 |
Company Size | Count |
---|---|
Small Business | 6 |
Midsize Enterprise | 10 |
Large Enterprise | 11 |
Informatica PowerExchange Connectors provides high performance, out-of-the-box connectivity without having to develop custom data access programs.
Matillion Data Productivity Cloud features an intuitive graphical interface, seamless AWS integration, and efficient data management. Its tools streamline complex tasks for SFDC, RDS, Marketo, Facebook, and Google AdWords.
Matillion Data Productivity Cloud provides fast transformations with built-in verification, easy scheduling, and sampling. With automatic scalability and diverse data source support, it simplifies complex data tasks. Users benefit from cloud data warehousing and integrating data into Snowflake while appreciating its ease of use by non-technical teams. Enhancements can focus on frequent API adjustments, improved documentation, faster performance with less latency, and better error handling.
What are the key features of Matillion Data Productivity Cloud?
What benefits and ROI should users seek in reviews?
In industries such as technology, finance, and healthcare, Matillion Data Productivity Cloud is implemented to streamline ETL processes, optimize data pipeline construction, and enhance data migration efforts. It supports efficient data loading and integration between cloud and on-premises databases, aiding industries in managing data-driven projects.
We monitor all Cloud 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.