This article illustrates how to discover SQL Server data lineage in 3 minutes by using the Grabit tool together with the SQLFlow.
Steps to capture data lineage in the SQL Server database:
- Export SQL Server database structure; You can specify included database, schema or exclude database, schema
- Send the exported data to https://sqlflow.gudusoft.com for automatically data lineage analysis
- Check the data lineage result on https://sqlflow.gudusoft.com under your account.
- Export the data lineage result to CSV, JSON, Graphml
After analyzing the SQL script submitted by the grabit, the SQLFlow will visualize the data lineage and provides a nice, clean, and actionable diagram.
With this diagram in hand, you can easily discover the data flow/movement from its source to destination via various changes and hops on its way in the SQL Server database.
Click the icon to choose your favorite way to use the SQLFlow
SQL Server Data lineage Video
Don’t want to send your SQL Server database schema to the remote SQLFlow server?
No problem! You can set up the SQLFlow On-Premise version inside your own organization and get all features in the SQLFlow cloud version while no data transferred over the internet.
Need to discover data lineage from other databases?
No problem! SQLFlow support the major databases includes: bigquery, couchbase, dax, db2, greenplum, hana, hive, impala, informix, mdx, mysql, netezza, openedge, oracle, postgresql, redshift, snowflake, sqlserver, sybase, teradata, vertica
Need to discover data lineage from the Version control systems?
No problem! Grabit can fetch all SQL scripts from the version control system such as Github, Bitbucket and send them to the SQLFlow for the data lineage analysis. And all this is done automatically, you only need to enter the credential of Github, Bitbucket.
Go Premiun and Use SQLFlow Right Now
unlock all the extraordinary features
Your premium account will be activated within 3 minutes
Unlimited access to the SQLFlow cloud service
Fully Restful API access
Automate data lineage from your database instance
Automate data lineage from Github/Bitbucket Repo
7 Days Money Back Guarantee, No Questions Asked!
Leave A Comment
If you enjoy reading this, then, please explore our other articles below:
[…] from Oracle to MySQL to Microsoft SQL Server, SQL also provides another useful use: enabling SQL lineage […]