We performed a comparison between Informatica PowerCenter, Matillion ETL, and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.
Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration."What I like the most is that we have to deal with less while writing the queries."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness."
"The product's initial setup phase is very easy."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"I like the automated scheduling feature."
"The product has a good user interface."
"It can scale to a great extent. It can handle the load that we are putting on it, which is about 5TBs."
"The simplicity of this tool is nice. It has a good graphical user interface. You can also do a lot of generic stuff in the tool. If there is good connectivity to a cloud database, such as Snowflake, and you can have a lot of Snowflake functionality in the tool."
"Matillion ETL helps manage data movement, ingestion, and transformation through pipelines."
"It has improved the costs of managing my customer’s data."
"It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth"
"The loading of data is the most valuable feature of Matillion ETL."
"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"The most valuable feature that we use is the Knowledge Modules."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner."
"It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors."
"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
"The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module."
"It's completely user-friendly."
"As a connector to big data, it is not well developed. We've had problems connecting Informatica with Hadoop. The functionality to connect Informatica with Hadoop, for me it's not good."
"What I didn't like about it is that the platform itself is not great at distributed processing. When you need high parallel processing, it has some inherent issues. We had to use Java transformation, and it did not go very well. I have heard that it is going to the cloud, but we haven't tried that."
"While on-premises is a better product, we really need to move to the cloud and need the cloud to be as robust as this product."
"The multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"The reputation of Informatica is that it is expensive."
"The solution does not scale."
"The cost of the solution is high and could be reduced."
"Matillion’s on-premises capabilities don’t allow you to build something customized."
"The current version is a bit more limited because it's on a virtual machine, and everything executes on that one virtual machine."
"When using the SQL loader type there were not a lot of pre-processing features for the data. For example, if there is a table with twenty columns, but we only want to load ten columns. In that case, we can use a security script to select the specific columns needed. However, if we want to perform extensive pre-processing of the data, I faced some challenges with Matillion ETL. I did not encounter many challenges, but my overall experience is limited as I only have three years of experience."
"Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes simultaneously at the entry level."
"Unlike Snowflake which automatically takes care of upgrading to the latest version and includes additional features, with Matillion ETL we need to do this ourselves."
"Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more."
"It can have multi-environment support. We should be able to deploy it in different environments. Its integration with SAP connection is not so nice, which should be improved. It can also support an on-prem database."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"Reverse engineering is complicated and challenging to manage."
"We used a third party to do the implementation of ODI."
"The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects."
"The initial setup is a bit complex compared to other tools."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"