We performed a comparison between Fivetran and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The product is very easy to use and very easy to configure."
"The most important feature of the solution is its ability to build data pipelines in less time."
"For us, Fivetran has been able to scale both in terms of the data we bring into our warehouse and the amount of data that we use as well."
"The general data ingestion is valuable. It's used for a lot of data. It provides about 90% of the data we use in our data warehouse without needing data engineering."
"The simplicity of the solution is its valuable feature."
"Its arrays are powerful enough to handle migrations even when the replication is happening in the background, without causing any trouble with the ongoing traffic."
"It is not like a traditional ETL, but it gives quite a lot of flexibility."
"The ease of usability is the most valuable feature. It's very easy and quick to set up. It also has a central hub as opposed to GoldenGate which is one direct interface. For GoldenGate I would have needed three interfaces whereas with HVR I have a central interface that manages everything."
"Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"The installation of the client ODI Studio is easy."
"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 has the ability to easily load slowly changing dimensions."
"The scalability is great. It's one of the reasons we chose the solution."
"It is an ETL tool, which does the extract, transform, and load."
"More connectors are needed for exotic, popular, and rising star portals."
"The customization could improve because Fivetran gives more thought to people who don't want to manage analytics workflows rather than engineers who want to be able to customize pipelines more thoroughly."
"Fivetran would be improved by adding the ability to integrate the data from third-party APIs."
"The environment must be more development-friendly."
"The documentation is decent, but it's hard to find information online about Fivetran. For example, if you try to search for an error code, you won't find much information about it in forums."
"The connections with SAP must be improved."
"It should have a few more monitoring functionalities."
"Some of the pain points we're looking at are trying to integrate some of the items in the Microsoft stack, so SharePoint and Excel, and then some of the newer Azure services."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"The initial setup is a bit complex compared to other tools."
"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"The initial setup is complex, especially if you also have to install a console."
"The stability of the software could be improved. Sometimes, the software just crashes. "
Fivetran is ranked 13th in Data Integration with 19 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews. Fivetran is rated 8.0, while Oracle Data Integrator (ODI) is rated 8.2. The top reviewer of Fivetran writes "Solution reduces time-to-value; high ROI". On the other hand, the top reviewer of Oracle Data Integrator (ODI) writes "Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved". Fivetran is most compared with AWS Database Migration Service, Qlik Replicate, Azure Data Factory, Oracle GoldenGate and Informatica Cloud Data Integration, whereas Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, SSIS, Informatica PowerCenter, Azure Data Factory and Oracle GoldenGate. See our Fivetran vs. Oracle Data Integrator (ODI) report.
See our list of best Data Integration vendors and best Cloud Data Integration vendors.
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.