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."In the end, you have structured, proper data for use in an integrated BI solution."
"Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"Good product if you are trying implement data quality, data integration, and data management projects."
"The setup is very simple."
"Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory."
"I like the completeness of the way I can build ETL workflows."
"The partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter."
"We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models."
"It has improved the costs of managing my customer’s data."
"The most valuable feature of Matillion ETL is its user-friendly graphical interface."
"It has good integrations with Amazon Redshift and other AWS services."
"The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation."
"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good."
"The product's initial setup phase was easy."
"Matillion ETL is one hundred percent stable."
"The loading of data is the most valuable feature of Matillion ETL."
"The solution's initial setup is straightforward, especially compared to Mule, which our team has worked with before and found to be a bit more complex in terms of setup."
"It's completely user-friendly."
"Besides loading data, we do most of our transformations in ODI."
"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."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"The installation of the client ODI Studio is easy."
"What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"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."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"PowerCenter has three clients. I wish they would consolidate everything into one GUI, not three. Also, we had a persistent issue with the Informatica Developer tool but it was solved when we migrated to the newest one."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"Support could be better."
"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 performance of Informatica PowerCenter could improve."
"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."
"While the UI is good, it could be improved in its efficiency and made easier to use."
"The cost of the solution is high and could be reduced."
"I am looking forward to seeing the expansion of the source range for their data loader product."
"The product must enhance its near-real-time data capture feature."
"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."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."
"If you have something like Cisco on top of it, you will have endless problems."
"The resource management aspect of the solution could be improved."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us."
"The performance of the user interface is in need of improvement."
"The initial setup is a bit complex compared to other tools."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."