Database & Data Modeling Tools Tutorials

Database and data modeling tools tutorials.

All tools

SQL Server Management Studio (SSMS)

MySQL Workbench

Oracle SQL Developer

pgAdmin

phpMyAdmin

DataGrip

Toad for Oracle

Toad for SQL Server

Toad for IBM DB2

Azure Data Studio

IBM Data Studio

Microsoft Access

Dbeaver

HeidiSQL

SQL Workbench/J

MongoDB Compass

Aqua Data Studio

Power BI

SQL Server Integration Services (SSIS)

Most recent articles

SSIS Data Lineage - Complete Guide to Tracking Data Flow from SQL to BI - This guide explains what SSIS data lineage is, why it matters, how to document it, and how to automate lineage end-to-end using a dedicated SSIS data lineage tool such as Dataedo.
How to Document SSIS Packages - Complete step-by-step guide - This guide walks you through what to document, how to document it, and how to automate metadata extraction using examples from a typical daily ETL pipeline moving data from an operational system into a data warehouse.
How to Connect Analysis Services to Power BI and Document It with Dataedo - This guide explains how to connect Analysis Services to Power BI step by step, and then shows how to document and govern that integration using Dataedo.
How to connect Oracle to Power BI - Step-by-step guide - Learn how to connect Oracle to Power BI: setup, Import vs DirectQuery, optimization, troubleshooting, and Oracle → Power BI lineage with Dataedo.
How to connect SQL Server to Power BI - Step-by-step guide - Learn how to connect SQL Server to Power BI: Import vs DirectQuery, gateway, performance tips, troubleshooting, and lineage SQL Server → Power BI with Dataedo.