dbt vs. Integrate.io

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

Xplenty is really well suited to gather information from many different sources. So if you are in an envitoment with lots of different IT-systems and you want to get an overview and collect data Xplenty can do this really well. It’s required for you to have some technical knowledge about setting up the software.

Incentivized

• 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

• ETL
• data aggregation
• scheduling

Incentivized

• 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

• When fault records lack granularity, debugging might be difficult.
• It isn't always simple to utilize.

Incentivized

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

I found them super cool and helpful in any regarding to implementation.

Incentivized

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

Integrate.io is the first platform with a complete set of tools and connectors for data-driven decision making. In addition, it connects the web apps use every day to save time, automate tasks, and focus on what matters most. In just a few minutes, you can set up automated workflows using thousands of the most popular web apps—no code required.

Incentivized

• 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

• It has an easy-to-use drag-and-drop interface and easy to learn tool.
• It is simple to manage data source and destination connections and the ability to add notes to dataflows.
• Its customer service is excellent, and they're always working to make sure we're getting the most out of their product.

Incentivized