Join tables across databases, by drag and drop
Customers in PostgreSQL, orders in MySQL, targets in an Excel file: join them on one canvas without moving the data first.
| id | name |
|---|---|
| 1 | Somchai K. |
| 2 | Narin P. |
| 3 | Malee S. |
| id | customer_id | total |
|---|---|---|
| 1042 | 1 | 1,250 |
| 1043 | 2 | 480 |
| 1044 | 1 | 2,900 |
| 1045 | 3 | 760 |
| order | customer | total |
|---|---|---|
| #1042 | Somchai K. | ฿1,250 |
| #1043 | Narin P. | ฿480 |
| #1044 | Somchai K. | ฿2,900 |
| #1045 | Malee S. | ฿760 |
What it does, who uses it, when
Across databases and files
Put tables from several connections and uploaded CSV or .xlsx files on one canvas, and join them by drawing a line between columns.
More than a join
Inner, left, right and full joins; filter rows; pick columns; group by with count, sum, avg, min and max; stack tables with union; add formula columns.
See it before you save
Preview the first 100 rows while you design, then save it as a pipeline that writes a table and runs on a schedule.
How it works
Place tables
Drag tables from each connection, or an uploaded file, onto the canvas.
Connect and shape
Draw a line between matching columns, pick the join type, and add filter, group by or formula steps.
Preview and save
Check the preview, then save it as a pipeline to run again.
Works well with
Pipelines and schedules
Save a Join Canvas result as a table in the database you choose, or send it as a report by email, SFTP, S3 or a shared folder. Run it by hand or on a schedule, and see every run.
DetailsDatabase connections
Connect PostgreSQL, MySQL, SQL Server, Oracle, SQLite and MongoDB over TLS or an SSH tunnel, mark them read-only, and let the team use them without knowing the password.
Details
Frequently asked questions
Do I need to write SQL?
No, every step is set on screen. If you like SQL, the SQL Editor can query across connections too.
Can I join with an Excel file?
Yes. Upload a CSV or an .xlsx file up to 50 MB and place it on the canvas next to database tables. Old .xls files are not supported yet.
Is my data copied to Ruamhub?
No. Previews read straight from your databases. A result is written only when you set a pipeline target, and that table lives in a database you choose.
Bring all your databases into one place
Start free, or book a demo and we will walk through it with your own team’s data.