dbt vs. Informatica Intelligent Data Management Cloud

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
dbt
Score 9.0 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.
$0
per month per seat
Informatica Intelligent Data Management Cloud
Score 7.0 out of 10
N/A
The Informatica® Intelligent Data Management Cloud™ (IDMC) is designed to help businesses efficiently handle the complex challenges of dispersed and fragmented data to innovate with their data on virtually any platform, any cloud, multi-cloud and multi-hybrid.N/A
Pricing
dbtInformatica Intelligent Data Management Cloud
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
dbtInformatica Intelligent Data Management Cloud
Free Trial
YesNo
Free/Freemium Version
YesNo
Premium Consulting/Integration Services
YesNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
dbtInformatica Intelligent Data Management Cloud
Features
dbtInformatica Intelligent Data Management Cloud
Data Transformations
Comparison of Data Transformations features of Product A and Product B
dbt
9.7
8 Ratings
18% above category average
Informatica Intelligent Data Management Cloud
-
Ratings
Simple transformations10.08 Ratings00 Ratings
Complex transformations9.38 Ratings00 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
dbt
9.1
8 Ratings
15% above category average
Informatica Intelligent Data Management Cloud
-
Ratings
Data model creation9.78 Ratings00 Ratings
Metadata management8.78 Ratings00 Ratings
Business rules and workflow9.08 Ratings00 Ratings
Collaboration10.06 Ratings00 Ratings
Testing and debugging8.08 Ratings00 Ratings
Best Alternatives
dbtInformatica Intelligent Data Management Cloud
Small Businesses
Skyvia
Skyvia
Score 10.0 out of 10
Skyvia
Skyvia
Score 10.0 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
dbtInformatica Intelligent Data Management Cloud
Likelihood to Recommend
10.0
(10 ratings)
8.3
(13 ratings)
Likelihood to Renew
-
(0 ratings)
9.0
(1 ratings)
Usability
9.7
(3 ratings)
-
(0 ratings)
Support Rating
-
(0 ratings)
8.0
(3 ratings)
User Testimonials
dbtInformatica Intelligent Data Management Cloud
Likelihood to Recommend
dbt Labs
The prerequisite is that you have a supported database/data warehouse and have already found a way to ingest your raw data. Then dbt is very well suited to manage your transformation logic if the people using it are familiar with SQL. If you want to benefit from bringing engineering practices to data, dbt is a great fit. It can bring CI/CD practices, version control, automated testing, documentation generation, etc. It is not so well suited if the people managing the transformation logic do not like to code (in SQL) but prefer graphical user interfaces.
Read full review
Informatica
Informatica Cloud is a great tool for use when data must be formatted consistently. Once configured, it is very robust and reliable. It is also well-suited for an organization without a robust IT staff to maintain a full server infrastructure. It offers a cost-effective approach to high-quality data integration for even the largest organizations. Organizations without staff experienced in data analytics may find it challenging to take advantage of the more complex results of this tool.
Read full review
Pros
dbt Labs
  • dbt supports version control through GIT, this allows teams to collaborate and track the data transformation logic.
  • dbt allows us to build data models which helps to break complex transformation logic into simple and smaller logic.
  • dbt is completely based on SQL which allows data analyst and data engineers to build the transformation logic.
  • dbt can be easily integrated with snowflake.
Read full review
Informatica
  • Once the secure connection is established it’s quite easy to operate and create new jobs. The controls are simple, and we appreciate the fact there are not a lot of complex fine-tunings required. Navigation is also easy, and we enjoy the ability to open multiple tabs in the browser to work on multiple projects.
  • The monitoring functionality works well to help track the progress of the jobs, again, without too much complication. In a fast dev environment, speed is essential and we quickly seeing the status/progress of jobs as well as any errors if the jobs fail helps us maintain speed.
  • The web interface is a lot easier to interact with than the client/on-prem version. Putting much of the heavy lifting of interacting with the tool onto the shoulders of the browser makes it easier to keep multiple sessions open and get in/out quickly without having to VPN into the office.
Read full review
Cons
dbt Labs
  • Field-level lineage (currently at table level)
  • Documentation inheritance - if a field is documented the downstream field of the same name could inherit the doc info
  • Adding python model support (in beta now)
Read full review
Informatica
  • The User Interface can be a bit difficult to get in initial stages.
  • Error messages are hard to understand which sometimes takes a lot of time for the resolution
  • Cannot Implement complex SQL queries which should be fixed in future release.
Read full review
Usability
dbt Labs
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.
Read full review
Informatica
No answers on this topic
Support Rating
dbt Labs
No answers on this topic
Informatica
I've never had trouble getting into contact with Informatica's support for technical help. I give it a nine because it does pretty well for mid to enterprise-scale workflows.
Read full review
Alternatives Considered
dbt Labs
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 there's a FREE version for 1 dev seat with no read-only access for anyone else, so you can always start with that and then buy yourself a seat later.
Read full review
Informatica
First, the wizard is easy to use making the learning curve for simple ETL tasks nice. Second, since Informatica is mature there are a good variety of connectors available. Finally, we have driven some fairly complex ETL solutions using only the cloud.
Read full review
Return on Investment
dbt Labs
  • Simplified our BI layer for faster load times
  • Increased the quality of data reaching our end users
  • Makes complex transformations manageable
Read full review
Informatica
  • Cut costs on the number of staff we need for data import.
  • Cut costs for automation that can be done for data that no longer has to be manually imported.
  • We've saved countless dollars by eliminating duplicates in our system with this tool.
Read full review
ScreenShots