Data Catalog for SQL Server

Better understand and easily document your SQL Server databases

Quickly generate convenient and interactive documentation of your SQL Server databases

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
dataedo
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.
dataedo
Keep data dictionary up to date automatically
Set up automated daily tasks in Windows Scheduler to update schema and generate documentation automatically.
dataedo
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.
dataedo

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
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.
dataedo
Import foreign keys
Dataedo reads foreign key constraints from DBMS and adds table relationships to the diagram automatically.
dataedo
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.
dataedo
Document and visualize cross-database relationships
Dataedo allows you to define relationships across databases and create cross database ERDs.
dataedo

Describe data schema of your SQL Server databases

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.
dataedo
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.
dataedo
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.
dataedo
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.
dataedo

Document and analyze data lineage

define_flows
Dataedo Desktop
Document data lineage
Extract data lineage of views automatically from dependencies and SQL parsing on object and column level.
Learn more.
define_flows
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.

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
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 Web Catalog
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
Dataedo Web Catalog
PDF & Excel Exports

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

See live sample
Take a product tour
Take a product tour

Why our customers love Dataedo?

See more testimonials
Trusted by:

Document your SQL Server databases today

Create comprehensive data documentation and share it with your team