dbt vs. Oracle Data Integrator (ODI)

dbt

Oracle Data Integrator (ODI)

Overview
Product	Rating	Most Used By	Product Summary	Starting Price
dbt	Score 9.1 out of 10	N/A	dbt is an SQL development environment, developed by Fishtown Analytics, now known as dbt Labs. The vendor states that with dbt, analysts take ownership of the entire analytics engineering workflow, from writing data transformation code to deployment and documentation. dbt Core is distributed under the Apache 2.0 license, and paid Teams and Enterprise editions are available.	N/A
Oracle Data Integrator (ODI)	Score 8.6 out of 10	N/A	Oracle Data Integrator is an ELT data integrator designed with interoperability other Oracle programs. The program focuses on a high-performance capacity to support Big Data use within Oracle.	N/A

Pricing

dbt

Oracle Data Integrator (ODI)

Editions & Modules

No answers on this topic

Offerings

Pricing Offerings
dbt	Oracle Data Integrator (ODI)
Free Trial
Yes	No
Free/Freemium Version
Yes	No
Premium Consulting/Integration Services
No	No

Entry-level Setup Fee

No setup fee

Additional Details

—

More Pricing Information

Community Pulse
	dbt	Oracle Data Integrator (ODI)
Considered Both Products	dbt SI Sid Iyer BizOps Chose dbt dbt is very flexible and can fit into most data pipelines. This is a pro for most organizations that aren't fully bought into one platform (Google Cloud, etc.) Incentivized Helpful? Verified User Anonymous Chose dbt Matillion is graphical versus dbt, which is SQL code-based (that, of course, is a matter of personal preference and not an objective advantage). The integrated testing, documentation generation, lineage, etc., were additional criteria that led us to choose dbt. Incentivized Helpful? Verified User Anonymous Chose dbt I actually don't know what the alternative to dbt is. I'm sure one must exist other than more 'roll your own' options like Apache Airflow, say, bu tin terms of super easy managed/cloud data transforms, dbt really does seem to be THE tool to use. It's $50/month per dev, BUT … Incentivized Helpful? Judy Campion Data Architect Chose dbt Snaplogic is great at the Extraction and Load processes of ETL. It can pull data from anywhere, even behind firewalls. So if you need to get data from various APIs, databases, files, S3, SFTP, etc it is easy to do so. However, it requires special knowledge in order to build … Incentivized Helpful? Verified User Anonymous Chose dbt I haven't come across anything like DBT before. Incentivized Helpful? YP Yoshlin Pillay Senior Data Entry Chose dbt Most ETL pipeline products have a T layer, but dbt just does it better. The transformation is on steroids compared to the others. Also, just allows much more Adhoc solutions for very specific projects. Those ETL tools are probably better on the T part if you don't need too many … Incentivized Helpful? Obed Espina Senior Data Engineer Chose dbt Airflow can accomplish the same work as dbt (data build tool), however, dbt's (data build tool) development workflow and UI can open up data transformation and modeling work to non-data engineering teams. Looker might also be able to define data models via LookML with a … Incentivized Helpful? Verified User Anonymous Chose dbt dbt is great because of its transformation capabilities Incentivized Helpful? DD Daniel Denunzio Data Architect Chose dbt dbt fits much better in our stack, where we're using specialized tools to support our ELT approach. Incentivized Helpful?	Oracle Data Integrator (ODI) Verified User Anonymous Chose Oracle Data Integrator (ODI) This is very easy to integrate with Oracle data sources and as most of my databases are in oracle so I gave preference to this tool. Incentivized Helpful? Lakhan Suri SQL AND BI Developer Chose Oracle Data Integrator (ODI) MuleSoft Anypoint Platform and Alteryx Platform Incentivized Helpful? Cameron Gable Software Engineer III Chose Oracle Data Integrator (ODI) I have used Trifacta Google Data Prep quite a bit. We use Google Cloud Platform across our organization. The tools are very comparable in what they offer. I would say Data Prep has a slight edge in usability and a cleaner UI, but both of the tools have comparable toolsets. Incentivized Helpful? Verified User Anonymous Chose Oracle Data Integrator (ODI) Oracle Data Integrator works very well if the rest of your systems are in the Oracle environment. There are some other good alternatives out there, but for what Oracle Data Integrator has to offer, it is good. It is also a little harder to use compared to the other ones I have … Incentivized Helpful? Verified User Anonymous Chose Oracle Data Integrator (ODI) We were using Actian Pervasive before switching to Oracle and the main reason was the cost. We were getting less functionality at even more cost. Although it is much faster in terms of operation, Oracle makes it easy to connect to all data sources making data integration easier … Incentivized Helpful? zahit bogus Business Intelligence Consultant Chose Oracle Data Integrator (ODI) I have used the Pentaho Data Integrator ETL tools in different projects with the SQL Server Integration Services product from the Microsoft product family. Oracle Data Integrator ETL product is efficient in projects where Oracle databases are heavily used. The end-user … Incentivized Helpful? Verified User Anonymous Chose Oracle Data Integrator (ODI) Powerful features and Oracle based Incentivized Helpful? Holman Cárdenas, M.Eng, TOGAF®, ITIL® CIO (Chief Information Officer) Chose Oracle Data Integrator (ODI) Since our main databses are Oracle, we decided to use this tools. No other tools were evaluated (some research made, though). Incentivized Helpful? Verified User Anonymous Chose Oracle Data Integrator (ODI) I think that Oracle Data Integrator is much better because of the user interface it provides. Incentivized Helpful? Verified User Anonymous Chose Oracle Data Integrator (ODI) Chose Oracle Data Integrator for its compatibility and integration with Oracle Goldengate Incentivized Helpful? Ashwini Chandorkar Senior Analyst Chose Oracle Data Integrator (ODI) ODI is best suited for Oracle Hyperion environments. We have also used it to manage files on different operating systems. Incentivized Helpful? Paolo Borghi Oracle Business Intelligence Consultant Chose Oracle Data Integrator (ODI) Talend Data Integrator has been evaluated during the setup of the architecture for a customer, in comparison to ODI, since it's an open source ETL. But, differently from the meaning of "open source", it has licence costs too that aren't that different from ODI ones. Moreover, … Incentivized Helpful? Jérôme Françoisse Data Integration Lead Chose Oracle Data Integrator (ODI) ODI is the naturel successor of OWB, adopting the same EL-T approach but supporting a lot more technologies as source and target. The overall product is much more stable and not tied to the Oracle database. Unlike Informatica, ODI generates all the code in the native underlying … Incentivized Helpful? Gurcan Orhan Senior Solutions Architect Chose Oracle Data Integrator (ODI) Because of variety of my projects that I involved, I used nearly all the world wide known tools within data warehouse environment. Data Modeling Tools : Sybase Power Designer, SQL Developer Data Modeler, ERwin Data Modeler. Incentivized Helpful? Ely Turkenitz IS Manager, Data Services Chose Oracle Data Integrator (ODI) We migrated to ODI from OWB - and we found ODI to be light years ahead of OWB (features, performance, and connectivity). We also looked at Informatica, but were turned down by its cost. Being a SAP Business Objects shop, we also considered the SAP Data Integrator tool (it … Incentivized Helpful? Verified User Anonymous Chose Oracle Data Integrator (ODI) Oracle's own ETL tool was Oracle Warehouse Builder, initially. When Oracle built the Oracle Business Intelligence Applications Suite, Oracle is in need of a strong ETL. As Oracle Warehouse Builder is not a strong ETL that customers prefer and as already Informatica captured … Incentivized Helpful? Federico Shortrede CIO Chose Oracle Data Integrator (ODI) We thought IBM was too expensive and more difficult to use. With Microsoft, since we have our main application running with Oracle DB, we understood it’d be easier for us to work with ODI. Incentivized Helpful? Samir Patel, PMP SQL Development Team Lead Chose Oracle Data Integrator (ODI) Oracle Data Integrator is a superior tool when dealing with Hyperion Planning and Essbase cubes and applications. The native connectors allow for easy data movement and transformations from one environment to the other. I do believe that Oracle Data Integrator is a very complex … Incentivized Helpful? James Parks Technology Consultant Chose Oracle Data Integrator (ODI) Informatica was slightly more intuitive but slightly less powerful than Oracle Data Integrator. My use of Informatica was much less extensive than Oracle Data Integrator, so I can not speak as in-depth about the strengths and weaknesses of Informatica. We used ODI much more for … Incentivized Helpful? Peter Shepherd Manager Chose Oracle Data Integrator (ODI) ODI is less user friendly than FDM and DRM but is much easier to deploy than core ETL tools such as HAL or Informatica. The tool is easier to master and is usually more than capable of handling the run of the mill tasks required for Hyperion deployments. It has been a good … Incentivized Helpful? Verified User Anonymous Chose Oracle Data Integrator (ODI) IBM Infosphere, Informatica. I worked on the mentioned tools as well as ODI. I liked ODI because it is easy to use with great features that every other ETL tool has in the market. Incentivized Helpful? Verified User Anonymous Chose Oracle Data Integrator (ODI) Our organization was using the Oracle BPM and the Oracle Data Integrator has good integration with BPM. We got good support from Oracle in setting up the integrated environment. Incentivized Helpful?

Features

dbt

Oracle Data Integrator (ODI)

Data Transformations

Comparison of Data Transformations features of Product A and Product B
	dbt 9.7 Ratings 18% above category average	Oracle Data Integrator (ODI) 9.9 Ratings 20% above category average
Simple transformations	10.00 Ratings	9.90 Ratings
Complex transformations	9.50 Ratings	9.90 Ratings

Data Modeling

Comparison of Data Modeling features of Product A and Product B
	dbt 9.1 Ratings 15% above category average	Oracle Data Integrator (ODI) 9.2 Ratings 16% above category average
Data model creation	9.70 Ratings	9.30 Ratings
Metadata management	8.70 Ratings	9.50 Ratings
Business rules and workflow	9.00 Ratings	9.10 Ratings
Collaboration	10.00 Ratings	8.50 Ratings
Testing and debugging	8.00 Ratings	9.30 Ratings

Data Source Connection

Comparison of Data Source Connection features of Product A and Product B
	dbt - Ratings	Oracle Data Integrator (ODI) 9.6 Ratings 15% above category average
Connect to traditional data sources	00 Ratings	9.90 Ratings
Connecto to Big Data and NoSQL	00 Ratings	9.30 Ratings

Data Governance

Comparison of Data Governance features of Product A and Product B
	dbt - Ratings	Oracle Data Integrator (ODI) 9.1 Ratings 12% above category average
Integration with data quality tools	00 Ratings	9.50 Ratings
Integration with MDM tools	00 Ratings	8.70 Ratings

Best Alternatives
	dbt	Oracle Data Integrator (ODI)
Small Businesses	Skyvia Score 10.0 out of 10	Skyvia Score 10.0 out of 10
Medium-sized Companies	IBM InfoSphere Information Server Score 8.0 out of 10	IBM InfoSphere Information Server Score 8.0 out of 10
Enterprises	IBM InfoSphere Information Server Score 8.0 out of 10	IBM InfoSphere Information Server Score 8.0 out of 10
All Alternatives	View all alternatives	View all alternatives

User Ratings
	dbt	Oracle Data Integrator (ODI)
Likelihood to Recommend	10.0 (0 ratings)	8.0 (0 ratings)
Likelihood to Renew	- (0 ratings)	10.0 (0 ratings)
Usability	9.7 (0 ratings)	- (0 ratings)
Implementation Rating	- (0 ratings)	7.0 (0 ratings)

User Testimonials
	dbt	Oracle Data Integrator (ODI)
Likelihood to Recommend	dbt (Data Build Tool) is best suited for doing the data transformation. dbt is just a transformation tool and it is not suitable for building a data pipeline which requires extraction of data and loading. dbt is well suited for SQL based transformation logic and it is less appropriate when transformation logic requires python. Incentivized Sahil Khan Data Analyst Read full review	I tried various ETL tools and here is [where and] why I recommend Oracle Data Integrator. 1. When you want to process structured data from different databases - Teradata, Exadata, DB2, SQL, Oracle etc. 2. Oracle Data Integrator supports all platforms, hardware, and OS. This is a major advantage compared to other leading tools. 3. The ELT architecture giving a cutting edge performance over leading ETL tools. There is no need to align Oracle Data Integrator between source and target. ODI uses the source and target servers to perform complex transformations. 4. Speeds up the development and maintenance by reducing the code that developers need to write Incentivized Verified User Anonymous Read full review
Pros	user experience makes it easy to work with SQL and version control customer success team and the dbt (data build tool) community help establish best practices thorough and clear documentation Obed Espina Senior Data Engineer Read full review	Converts data from various sources into one target format using various business logic rules and integrates with various DBMS types. Transformed data from DB2, SQL Server and other Oracle databases into flat files and then used ETL jobs to load into Oracle DB target Data Integrator and Goldengate were used together to accomplish the data movement needed for business and data consolidation in live environment. Data Integrator helped with development and in reducing lead time to convert data into target. Incentivized Verified User Anonymous Read full review
Cons	Slow load times of the dbt cloud environment (they're working on it via a new UI though) More out-of-the-box solutions for managing procedures, functions, etc would be nice to have, but honestly, it's pretty easy to figure out how to adapt dbt macros Incentivized Verified User Anonymous Read full review	Oracle support is not the best when needing help with the system The documentation is also very poor and takes very long to generate Some parts of it are not intuitive to use and get hard to troubleshoot Like other Oracle products, you must have very, very thorough knowledge about their systems to understand Like all Oracle products, cost is high Incentivized Verified User Anonymous Read full review
Likelihood to Renew	No answers on this topic	It is maturing and over time will have a good pool of resources. Each new version has addressed the issues of the previous ones. Its getting better and bigger. Verified User Anonymous Read full review
Usability	dbt is very easy to use. Basically if you can write SQL, you will be able to use dbt to get what you need done. Of course more advanced users with more technical skills can do more things. Incentivized SI Sid Iyer BizOps Read full review	No answers on this topic
Alternatives Considered	Matillion is graphical versus dbt, which is SQL code-based (that, of course, is a matter of personal preference and not an objective advantage). The integrated testing, documentation generation, lineage, etc., were additional criteria that led us to choose dbt. Incentivized Verified User Anonymous Read full review	Talend Data Integrator has been evaluated during the setup of the architecture for a customer, in comparison to ODI, since it's an open source ETL. But, differently from the meaning of "open source", it has licence costs too that aren't that different from ODI ones. Moreover, the other components of the business intelligence architecture of the customer were Oracle, so we thought that ODI would suit at best with them, more than a different vendor software. Incentivized Paolo Borghi Oracle Business Intelligence Consultant Read full review
Return on Investment	In 3 months we re-wrote the data warehouse (15-20 sources) in dbt with 3 developers. We are using it continually for the past year with no issues. Sorry, I don't have ROI numbers but the impact was huge. Incentivized Judy Campion Data Architect Read full review	Oracle Data Integrator helps provide a business with the data it needs to defend the decisions it makes. Oracle Data Integrator allows you to analyze data from what can be separate, different, and often outdated data sources. It allows you to make direct comparisons when analyzing data from different pieces of equipment. Data from Oracle Data Integrator was used to analyze manufacturing quality and drive down spoilage, saving the company money. Incentivized James Parks Technology Consultant Read full review
ScreenShots