Prep and transform your data for AI, fast

Visually build ETL flows with drag-and-drop ease or write complex SQL transformations. Go from raw data to analysis-ready, without switching tools.

Magic ETL

Data transformation for everyone

Use Domo’s drag-and-drop ETL tools to combine and transform data from many sources quickly without coding. Perfect for business analysts and data teams.

A line diverging into two arrow lines

Flexible options

Visualize your data flows or write SQL to quickly blend and transform your data sets.

Gears

Repeatable flows

Build data flows once, run them automatically with each update, and get alerts if a step fails.

A database with a beaker in front of it

Rapid results

Transform data fast using Domo’s Adrenaline engine and built-in data science tools to reveal new insights.

Explore and enrich your data with Magic ETL

Use Domo’s ETL tools to clean, combine, and prep data visually without coding or SQL.

Domo product integration

Drag-and-drop ETL

Suitable for users new to SQL, Magic ETL lets you build dataflows visually by dragging and dropping steps, so you see your process clearly.

A calendar with a clock in front of it

Automate your data updates by scheduling pipelines to run automatically.

A database icon with a plus sign

Combine large data sets from different sources into one table for easier analysis.

A table icon

Quickly map or change data values between columns to fit your analysis needs.

Domo product integration

SQL-based ETL

Advanced analysts can write SQL queries to build fast, complex data pipelines with Domo’s SQL tile.

A table with a pencil in front of it

Do complex data transformations and join data sets quickly.

A database icon with a plus sign

Update data sources directly from Domo to keep all your systems in sync.

Code/development icon (</>)

Use SQL commands to handle advanced queries like subqueries and joins for deeper data analysis.

Product feature cars automotive graph

Get predictive insights

Domo’s ETL tools let anyone prepare data and use predictive models to find trends and make smarter decisions without needing data science skills.

A database with a beaker in front of it

Use R or Python scripts to perform detailed data analysis or bring in custom models.

Four dots divided into two groups by a line

Use built-in tools for forecasting, classification, and anomaly detection to create accurate statistical models.

A small circle in front of a bigger one

Easily deploy your external models in Magic ETL to automate data prep and find trends without coding.

"One of the best parts for me was learning Magic ETL so I could create my own datasets instead of having to rely on our team of engineers."
Image of Linda Fligg
Linda Fligg
Senior Business Operations Analyst, GE Healthcare
See the story
GE logo displayed on a blue building facade with corrugated metal siding and a black vent section.
"We didn't have to go find a visualization tool, an ETL tool, a cloud data warehouse, and spend all that money and effort integrating it all together. Domo has all of that at its disposal."
Smiling bald man with red beard and black glasses wearing a checkered shirt on a white background.
Adam Skinner
Chief Technology Officer, CitrusAd
See the story
Person typing on laptop beside a smartphone displaying a bar chart on a wooden table.
"We no longer have to focus on trying to find or manipulate data [thanks to Domo's drag-and-drop Magic ETL]."
Bruce Harris
Bruce Harris
Director of Financial Applications, Torchy's Tacos
See the story
Exterior of Torchy's Tacos restaurant with a red cartoon devil statue on top of a tall chimney against a partly cloudy sky.
"We created ETLs to automatically tell us which stores are low on inventory or will be low within the next few weeks. We can then take that information to our buyers and say, 'You are missing out on revenue and you're not ordering quickly enough.'
A photo of a smiling man
Paul James
Marketing Analytics Manager, Zippo
See the story
Two lighters by Zippo

Discover all Domo data integration features to speed up your data workflows

View all Features
Cut image with devices with product background images

Get started with Domo

See how your data can drive faster, clearer decisions.