Informatica PowerCenter was data integration technology designed to form the foundation for data integration initiatives, application migration, or analytics. It is a legacy product.
N/A
Matillion
Score 7.8 out of 10
N/A
Matillion is a data pipeline platform used to build and manage pipelines. Matillion empowers data teams with no-code and AI capabilities to be more productive, integrating data wherever it lives and delivering data that’s ready for AI and analytics.
$2.50
Pay as you go per user
Pricing
Informatica PowerCenter (legacy)
Matillion
Editions & Modules
No answers on this topic
Developer: For Individuals
$2.50/credit
Pay as you go per user
Basic
$1000
per month 500 prepaid credits (additional credits: $2.18/credit)
Advanced
$2000
per month 750 prepaid credits (additional credits: $2.73/credit)
Enterprise
Request a Quote
Offerings
Pricing Offerings
Informatica PowerCenter (legacy)
Matillion
Free Trial
No
Yes
Free/Freemium Version
No
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
Billed directly via cloud marketplace on an hourly basis, with annual subscriptions available depending on the customer's cloud data warehouse provider.
Basically the two solutions have, more or less, the same functions and features.The difference, for me, is that ThreatQuotient make more features over the security and I think is oriented to a SOC enviroments.
InformaticaExchange Connectors is oriented to the quality, …
Informatica PowerCenter is highly flexible and scalable for different types of data and it has any inbuilt function to transform our data into the meta data structure. Some of the tool sets such as TDM, is good in some ways but need EBF more than often when running into any …
Informatica is a mature enterprise data integration platform for ETL jobs. Informatica has a suite full of tools other than PowerCenter that can be used for various use cases. It makes sense to know what the entire suite offers rather than just power center so large …
PowerCenter is simply so robust and refined that most other apps cannot do as much as it can. Even Informatica’s own Cloud version is so anemic as to not even compare against it. While from that perspective it feels bloated with too much to navigate through, many of those …
SSIS is a good entry into ETL, for smaller organizations or Microsoft-centric companies. It's strengths lie in its ease-of-use, quick turnaround, and simplicity. Its weaknesses lie in scalability and re-usability (you can achieve re-usability, however segmentation is at the …
While Talend offers a much more comfortable interface to work with, Informatica's forte is performance. And on that front, Informatica Enterprise Data Integration certainly leaves Talend in the dust. For a more back-end-centric use case, Informatica is certainly the ETL tool of …
Microsoft SSIS, Ab Initio and IBM DataStage are evaluated against Informatica. Informatica scored well on licensing, hardware infrastructure flexibility and Big Data connectivity
PowerCenter is very similar to DataStage, in that they both deal with the movement and manipulation of data from one source/system to another. As we use both extensively at my company, I cannot say how it compares beyond that both are well liked and widely used. I would assume …
PowerCenter can be run from different types of OSs and can integrate with multiple types of databases and applications compared to SSIS. PowerCenter performs better with any type of database due to its ability to use native drivers to read as well as load data. Due to its seam …
PowerCenter is the industry leader when it comes to interfacing with multiple source and target systems. The graphical interface increases employee productivity while reducing human resource expenditures and training requirements. These other tools offer some similar …
Matillion is cheaper and we really like the customer support of Matillion as well as lerning materials provided by Matillion were far better. They also made connectors for us for free while others were charging us for it.
Matillion gives great ability to connect to variety of sources and bring data into cloud data warehouse using connector based approach with which we can build complex transformation jobs which can do automated data fetches from your sources.
Matillion has better capabilities and better built-in elements that saves your time and efforts. also the connectivity across multiple data warehousing tool is better in Matillion. even the performance of the pipeline and the time required to create a particular pipeline is …
My manager selected Million based on his previous work experience. He believes it is easy to use and maintain, cheaper than competitors, and suitable for our use case.
The only other ETL tool I've used was SSIS. At first I thought Matillion seemed "kiddish" after using the polished Microsoft tool but now I think Matillion is easier and can do much more as it has so many built-in connectors etc. We selected Matillion at our job because of …
n/a -- joined the team after they already were established in Matillion. Have had brief looks at other ETL products but found nothing compelling enough to suggest a change.
We selected Matillion primarily because of it's ability to connect to numerous data sources and easily create transformation jobs. While FiveTran does a better job managing and examining deltas, it is not easy to use and is very non user friendly. SSIS was not a good fit for …
Fivetran offers a managed service and pre-configured schemas/models for data loading, which means much less administrative work for initial setup and ongoing maintenance. But it comes at a much higher price tag. So, knowing where your sweet spot is in the build vs. buy spectrum …
We decided to move forward with Matillion because it was the best tool among tools that support both ingesting data from a source system to a target database and running transformation workflows on it afterwards. Fivetran and Airbyte only support data ingestion and we had our …
Cost and ease of use were better for our purposes. Matillion distinguishes itself from Fivetran and Snaplogic through its user-friendly design, no-code interface, in-depth transformation capabilities, allowing for complex data manipulations directly within the platform, …
The Matillion selection was not my decision. But I think it's a good enough choice. It is especially valuable that the team can learn Matillion easily and that the project can be understood by the entire team with the visual environment instead of complex ETLs.
Both the Databricks platform and Dbt Cloud are more powerful from the point of view of the development lifecycle and data use cases covered. They are also more complex and require specialized data engineering skills to be used. Matillion has a lower barrier of entry for small …
Removes most of the complexity around setting up and preparing things. If you could describe with words what needs to be done to move data from A to B, the implementation in Matillion would probably be the most similar in terms of simplicity of understanding what you are doing …
Matillion is a good tool for integrating multiple clouds. Informatica has been a market standard for many years, it provides multiple capabilities for data governance, data quality, etc. However, Informatica is pretty expensive compared to Matillion. Also, Matillion is more …
Informatica Powercenter is the centerpiece of our overall enterprise data warehouse strategy. It's a critical enablement to ensure we can feed in multiple data stream and transform them into digestible data within our data warehouse. With its flexible capabilities and API availability, we were able to feed in industry standard data format as well as home grown data structure. Overall, we are very pleased with their capability and contribution to our data warehouse strategy.
Great: Need to query simpler APIs, or utilize well known services such as GSheets etc.? Matillion has got some of the best and easiest to use connectors out there. Not so great: Do you need have a competent CI/CD flow that you will be able to update / compare from Matillion as well as other sources at the same time? Good luck, you will need to be extra careful, as you might have to have a deeper dive into your servers Terminal each time you have a git conflict.
One of the challenges of PowerCenter is the lack of integration between the components and functionality provided by PowerCenter. PowerCenter consists of multiple components such has the repository service, integration service, metadata service. Considerable time and resources were required to install and configure these components before PowerCenter was available for use.
In order to connect to various data sources such as Netezza database or SAS datasets, PowerCenter requires the installation and configuration of separate plug-ins. We spent considerable time trouble-shooting and debugging problems while trying to get the various plug-ins integrated with PowerCenter and get them up and running as described in the documentation.
PowerCenter works well with structured data. That is, it is easy to work with input and output data that is pre-defined, fixed, and unchanging. It is much more difficult to work with dynamic data in which new fields are added or removed ad-hoc or if data format changes during the data ingest process. We have not been as successful in using PowerCenter for dynamic data.
One of the challenges of learning PowerCenter is that it is difficult to find documentation or publications that help you learn the various details about PowerCenter software. Unlike SAS Institute, Informatica does not publish books about PowerCenter. The documentation available with PowerCenter is sparse; we have learned many aspects of this technology through trial and error.
Static and monolithic, it will show its limits when running multiple concurrent jobs.
Github and versioning implementation is messy and broken. Don't use it.
There's not way to see/query the system resources, just wait for a server to crash due to out of memory. An admin panel would be appreciated + some env variables with updated info.
API implementation is cumbersome and limited.
There's no concept of hub and worker engine, everything happens of the same server (designing workflows and executing them). Having separate light ETL engines to run job could be better. (sort of docker/kubernetes/lambda functions).
Handling of variables is limited especially for returned values from sub components.
Some components could return more metadata at the end of their execution instead of the standard one.
Billing is badly designed not taking into account that the server is hosted by the client. Expensive.
We had several issue with migration where starting a new instance was required and then migrating the content. It was painful and time consuming also have to deal with support and engineering team on Matillion side.
CDC doesn't work as expected or it is not a mature product yet.
Matillion is easy to use and flexible to debug. Performance are good and support is giving us a good service level. There are still some technical points to be developed more (such as SAP extraction). but easy flows are really fast to be developed. We are also using a tool for migration from other tools, and it is useful as Matillion is producing XML code.
The tool is very flexible and will meet most, if not all, of your data transformation needs. It is an expert-level tool, so building your knowledge-base and user-base (and keeping that base healthy!) is very important. But it will pay off with strong data management and the ability to leverage that data in ways you haven’t thought of yet. Bottom line, data is money, and PowerCenter helps you monetize your data.
Easy tasks are really easy, and complex tasks are still possible. With prior knowledge of general data warehousing principles and experience with other data transformation tools, it's straightforward to get familiar with and use Matillion. I initially used minimal external support from a partner for some more complex tasks but very soon could work entirely independently with Matillion.
Positives; - Multi-user development environment. - The speed of transformation. - Seamless integration with other Informatica products. Negatives; - There should be fewer windows, to maintain developers' focus while using. You probably need two big monitors when you start development with Informatica Power Center. - Oracle Analytical functions should be natively used. - E-LT support as well as ETL support.
Informatica power center is a leader of the pack of ETL tools and has some great abilities that make it stand out from other ETL tools. It has been a great partner to its clients over a long time so it's definitely dependable. With all the great things about Informatica, it has a bit of tech burden that should be addressed to make it more nimble, reduce the learning curve for new developers, provide better connectivity with visualization tools.
Overall, I've found Matillion to be responsive and considerate. I feel like they value us as a customer even when I know they have customers who spend more on the product than we do. That speaks to a motive higher than money. They want to make a good product and a good experience for their customers. If I have any complaint, it's that support sometimes feels community-oriented. It isn't always immediately clear to me that my support requests are going to a support engineer and not to the community at large. Usually, though, after a bit of conversation, it's clear that Matillion is watching and responding. And responses are generally quick in coming.
Basically the two solutions have, more or less, the same functions and features.The difference, for me, is that ThreatQuotient make more features over the security and I think is oriented to a SOC enviroments. InformaticaExchange Connectors is oriented to the quality, integration and distribution of the data in order to ensure the reliability and access of data from different sources, as well as the integration in a single repository of enterprise data (External/internal)
We selected Matillion primarily because of it's ability to connect to numerous data sources and easily create transformation jobs. While Fivetran does a better job managing and examining deltas, it is not easy to use and is very non user friendly. SSIS was not a good fit for our team and required a significant amount of attention and server management that we did not want to invest in.
We're using Matillion on EC2 instances, and we have about 20 projects for our clients in the same instance. Sometimes, we're struggling to manage schedules for all projects because thread management is not visible, and we can't see the process at the instance level.
Time savings -- we could custom code nearly everything Matillion does, but it would take days/weeks instead of minutes/hours.
There's a bit of a learning curve to truly unlock Matillion's potential, and that can be frustrating for some new users, but once you get over that curve, the possibilities are endless.
It allows us to centralize the hundreds of way to bring data in, so that even if you have to troubleshoot what someone else wrote, it's easy to jump in and understand what is happening.
