{"id":2667,"date":"2020-12-25T15:58:29","date_gmt":"2020-12-25T07:58:29","guid":{"rendered":"https:\/\/www.gudusoft.com\/?p=2667"},"modified":"2021-03-24T01:06:06","modified_gmt":"2021-03-24T09:06:06","slug":"discover-sql-server-data-lineage-in-3-minutes","status":"publish","type":"post","link":"https:\/\/www.gudusoft.com\/fr\/discover-sql-server-data-lineage-in-3-minutes\/","title":{"rendered":"D\u00e9couvrez la lign\u00e9e des donn\u00e9es SQL Server en 3 minutes"},"content":{"rendered":"

This article illustrates how to discover SQL Server data lineage in 3 minutes by using the Grabit tool together with the SQLFlow.<\/p>\n

Steps to capture data lineage in the SQL Server database:<\/p>\n

    \n
  1. Export SQL Server database structure;\u00a0 You can specify included database, schema or exclude database, schema<\/li>\n
  2. Send the exported data to\u00a0https:\/\/sqlflow.gudusoft.com<\/a>\u00a0for automatically data lineage analysis<\/li>\n
  3. Check the data lineage result on\u00a0https:\/\/sqlflow.gudusoft.com<\/a>\u00a0under your account.<\/li>\n
  4. Export the data lineage result to CSV, JSON, Graphml<\/li>\n<\/ol>\n

    After analyzing the SQL script submitted by the grabit, the SQLFlow will visualize the data lineage and provides a nice, clean, and actionable diagram.<\/p>\n

    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.<\/p>\n<\/div><\/div><\/div>