Oracle Data Integrator and Fivetran are key players in the data integration and ETL domain. Oracle Data Integrator is seen as more robust with its advanced technical capabilities, whereas Fivetran shines with its simplicity and ease of use.
Features: Oracle Data Integrator supports complex data integration flows, implements reusable mappings, and offers design-time automation with scripting. It facilitates real-time data integration across various technologies. Fivetran simplifies setup with seamless connectors and integrates well with transformation tools such as dbt. It also efficiently handles data synchronization and complex data pipelines.
Room for Improvement: Oracle Data Integrator users note the steep learning curve, seek better integration with Oracle products, and desire enhanced error handling and GUI enhancements. Suggestions for integration with version control and interface performance optimizations are also common. Fivetran users report limited customization, lacking detailed pipeline observability, and seek more cost-effective pricing along with more connectors and faster processing speed from third-party APIs.
Ease of Deployment and Customer Service: Oracle Data Integrator is mainly on-premises with a capacity for complex setups and customization, but customer support varies, especially across multiple Oracle products. Fivetran, cloud-deployed, offers easier deployment but has costly pricing models. Customer support experiences are mixed, with responsiveness varying among users.
Pricing and ROI: Oracle Data Integrator is generally costly and priced variably depending on project complexity, but it offers significant ROI by automating ETL processes and reducing operational costs. Fivetran’s usage-based pricing can be prohibitive for small projects but is competitive for larger ones, offering fast ROI through efficient data integration.
It saves us the effort of having one to two data engineers managing the tasks that Fivetran handles.
The technical support provided by Fivetran has generally been good, with a response time and competence that I would rate as good.
I can get solutions quickly, and any tickets I submit to Oracle are responded to and resolved rapidly.
During the duration of the time that we used Fivetran, it was highly stable.
From a cost perspective, if the number of connectors is lesser, then Fivetran is not the most cost-efficient option.
Improvement in existing connectors with new features is desirable.
If I use a source system like Oracle and a target system like Teradata, ODI will still run, but it struggles a bit with different infrastructures.
Our current yearly contract for Fivetran is approximately $70,000.
ODI is cheaper compared to Informatica PowerCenter and IBM DataStage.
The most valuable feature of Fivetran is its built-in connectors for a wide range of data sources.
The ability to seamlessly integrate with a large variety of data sources is valuable.
Oracle Data Integrator (ODI) is powerful and strong if my system uses Oracle components for environments like OLTP, enterprise data warehouse, or data marts.
Fivetran, the global leader in data movement, is trusted by companies like OpenAI, LVMH, Pfizer, Verizon and Spotify to centralize data from SaaS applications, databases, files, and other sources into cloud destinations, including data lakes. With high-performance pipelines, seamless interoperability, and enterprise-grade security, Fivetran empowers organizations to modernize their data infrastructure, power analytics and AI, ensure compliance, and achieve transformative business outcomes. Learn more at Fivetran.com
Oracle Data Integrator (ODI) is a data integration software solution that provides a unified infrastructure to streamline data and application integration projects. It uses a powerful design approach to data integration, which separates the declarative rules from the implementation details. The solution is based on a unique ELT (Extract Load Transform) architecture, eliminating the need for a standalone ETL server and proprietary engine.
Oracle Data Integrator Features
ODI has many valuable key features. Some of the most useful ones include:
Oracle Data Integrator Benefits
There are many benefits to implementing ODI. Some of the biggest advantages the solution offers include:
Reviews from Real Users
Below are some reviews and helpful feedback written by PeerSpot users currently using the Oracle Data Integrator (ODI) solution.
Brian D., Business Process and Strategy Specialist Advisor at NTTData, says, “The Knowledge Module (KM) is my favorite feature of ODI. This is where I learned how to use variables to make jobs dynamic. I took that knowledge and created a KM that would go into iTunes and pull the sales of eBooks. Making something that is reusable, like a KM, is important to not only reduce build time but also maintenance in the future.”
Ashok S., Applications Support Manager at a marketing services firm, mentions, "The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
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.
