Source - SQL Server

Dataedo has been named a 2020 Gartner Peer Insights Customers' Choice for Metadata Management Solutions. Read our reviews here.

Build a data dictionary for your SQL Server databases

Extract data dictionary with a few clicks

Dataedo allows you to connect and scan metadata from multiple data sources and extract data dictionary automatically with just a few clicks. You can quickly export it as a convenient and good looking HTML documentation

Data dictionary →

Document data model and stored procedures

Dataedo reads stored procedures, user-defined functions and triggers with their script, attributes and parameters, then lets you describe each element and saves in your documentation.

Stored procedures documentation →

Keep data dictionary up to date automatically

Set up automated daily tasks in Windows Scheduler to update schema and generate documentation automatically.

Automate Generation of Database Documentation →

Track changes in schema

Easily track changes in the schema of your databases. Dataedo scans schema of your databases and allows you to track, analyze and comment their changes.

Schema Change Tracking →

Take a product tour

Profile data and analyze data quality in your SQL Server databases

Use sample data to learn what data is stored in your data assets. Dataedo scans all values in selected tables and calculates useful metrics like rows number, percentage of distinct and empty rows. It also shows minimum and maximum values, average, median, span or deviation. This allows you to peak into values itself and identify areas that require improvements.

Take a product tour

Document and visualize relationships of your SQL Server databases

Visualize data model with ERDs

Import foreign keys

Describe relationships manually

Cross-database relationships

Visualize data model with ERDs

Visualize your Snowflake databases with ER Diagrams and make them transparent and accessible for everyone. Drag & drop tables to the pane, choose columns to display to understand and explain data model for easier querying, reporting and development.

ER Diagrams →

Import foreign keys

Dataedo reads foreign key constraints from DBMS and adds table relationships to the diagram automatically.

Document Foreign Keys →

Keep data dictionary up to date automatically

It is easy to add relationships in Dataedo data model repository for foreign keys with no FK constraints in the DBMS.

Document relationships manually →

Document and visualize cross-database relationships

Dataedo allows you to define relationships across databases and create cross database ERDs.

Document cross-database relationships →

Take a product tour

Describe data schema of your SQL Server databases

Organize schema in subject areas

Decode cryptic names

Track Progress

Custom fields

Organize schema in subject areas

Organize complex databases and data environments with subject areas into smaller folders representing a topic, subject area, project etc. to make your data sources more manageable.

Subject Areas →

Decode cryptic names with aliases

Many databases have confusing names of tables and columns. Dataedo helps you fix that issue with the option to add meaningful aliases (titles) for data elements.

Aliases →

Keep data dictionary up to date automatically

Many databases have confusing names of tables and columns. Dataedo helps you fix that issue with the option to add meaningful aliases (titles) for data elements.

Progress tracking →

Add more information with custom fields

Dataedo gives you ability to define custom plain text fields to describe your data. You can define different fields for different elements, like tables, columns, stored procedures etc.

Custom Fields →

Take a product tour

Document and analyze data lineage

Dataedo Desktop

Document data lineage

Extract data lineage of views automatically from dependencies and SQL parsing on object and column level.
Learn more.

Dataedo Web Catalog

Analyze data lineage diagrams

Understand your data better, easily identify the impact of planned changes, and ensure regulatory compliance through interactive data lineage diagrams. Learn more.

Take a product tour

Document SSIS

SQL Server Integration Services (SSIS) is a Microsoft's ETL tool. Dataedo allows you to import SSIS packages and create some lineage automatically and for the rest provide convenient suggestions for data flows. In the future we will add more data lineage generation automation using SQL parsing.

Take a product tour

Discover and classify sensitive data in your SQL Server databases

Scan your databases and find and tag fields holding personal data so you can know what data you are processing and where to comply with data protection regulations such as GDPR or CCPA.

Dataedo finds fields holding potentially sensitive data automatically from entire data catalog using built in functions. You and your team can curate metadata tags manually.

Take a product tour

Share complete documentation in convenient format

Dataedo Web Catalog

Self-hosted web portal for self-service data & building data community. Create a place where all people in your organization can go to find, learn about, discuss and contribute their findings about data.

See live sample

Dataedo HTML Docs

Easily export your documentation into lightweight and easily shareable interactive HTML documents. Self-host them on your drive or any web server.

See live sample

PDF & Excel Exports

Additionally, you can quickly export your documentation to PDF and Excel files.

See live sample

Take a product tour

More capabilities

On premises Metadata Repository

Gather all company metadata and allow collaboration in the shared metadata repository.

Metadata scanners for various databases

Connect to your data source, extract data structures and metadata and load them into the repository.

Business definitions with Business Glossary

Build and share a universal glossary of business terms, policies and rules.

Build a community around your SQL Server schema

Data Community allows everyone to share their observations about data through comments, ratings, questions, to-dos, and warnings.

Design database

Easily design new tables and update your database with DDL statements.

Import schema changes

Import changes in structure of your databases in a few simple steps and keep your documentation up to date automatically.

Take a product tour

Why our customers love Dataedo?

"We jump started all of our Data Governance efforts using the tool. We documented key databases quickly and easily and published the information to our analyst community."

Sandra Recca

- Sr. Director

Fitch Ratings, Inc.

"Dataedo is improving my work a lot. With documentation, the learning curve is smaller and I can have more time to work."

Nuno Vieira

- BI Tech Analyst

Hiscox

"Thanks to Dataedo I spent more time figuring out the connection string to the instance than I did running the report. It was a great experience."