{"id":2667,"date":"2020-12-25T15:58:29","date_gmt":"2020-12-25T07:58:29","guid":{"rendered":"https:\/\/www.gudusoft.com\/?p=2667"},"modified":"2026-07-11T23:15:11","modified_gmt":"2026-07-12T07:15:11","slug":"discover-sql-server-data-lineage-in-3-minutes","status":"publish","type":"post","link":"https:\/\/www.gudusoft.com\/fr\/decouvrir-la-tracabilite-des-donnees-sql-server-en-3-minutes\/","title":{"rendered":"D\u00e9couvrez la lign\u00e9e des donn\u00e9es SQL Server en 3 minutes"},"content":{"rendered":"<div class=\"wp-block-columns is-layout-flex wp-container-7\">\n\n<div class=\"wp-block-column is-layout-flow\">\n\n<p>Cet article explique comment d\u00e9couvrir la tra\u00e7abilit\u00e9 des donn\u00e9es SQL Server en 3 minutes en utilisant l&#039;outil Grabit conjointement avec SQLFlow.<\/p>\n<p>\u00c9tapes pour capturer la provenance des donn\u00e9es dans la base de donn\u00e9es SQL Server\u00a0:<\/p>\n<ol>\n<li>Exporter la structure de la base de donn\u00e9es SQL Server\u00a0; vous pouvez sp\u00e9cifier les bases de donn\u00e9es et sch\u00e9mas \u00e0 inclure ou \u00e0 exclure.<\/li>\n<li>Envoyer les donn\u00e9es export\u00e9es \u00e0\u00a0<a href=\"https:\/\/sqlflow.gudusoft.com\/\" target=\"_blank\" rel=\"nofollow noreferrer noopener\">https:\/\/sqlflow.gudusoft.com<\/a>\u00a0pour l&#039;analyse automatique de la lign\u00e9e des donn\u00e9es<\/li>\n<li>V\u00e9rifiez le r\u00e9sultat de la tra\u00e7abilit\u00e9 des donn\u00e9es sur\u00a0<a href=\"https:\/\/sqlflow.gudusoft.com\/\" target=\"_blank\" rel=\"nofollow noreferrer noopener\">https:\/\/sqlflow.gudusoft.com<\/a>\u00a0sous votre compte.<\/li>\n<li>Exportez les r\u00e9sultats de l&#039;analyse de la lign\u00e9e des donn\u00e9es aux formats CSV, JSON et GraphML.<\/li>\n<\/ol>\n<p>Apr\u00e8s avoir analys\u00e9 le script SQL soumis par le grabit, SQLFlow visualisera la lign\u00e9e des donn\u00e9es et fournira un diagramme clair, pr\u00e9cis et exploitable.<\/p>\n<p>Gr\u00e2ce \u00e0 ce diagramme, vous pouvez facilement d\u00e9couvrir le flux\/mouvement des donn\u00e9es de leur source \u00e0 leur destination en passant par divers changements et sauts dans la base de donn\u00e9es SQL Server.<\/p>\n\n\n\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\">\n\n<h3 class=\"fusion-responsive-typography-calculated\" data-fontsize=\"28\" data-lineheight=\"36.4px\">Cliquez sur l&#039;ic\u00f4ne pour choisir votre m\u00e9thode pr\u00e9f\u00e9r\u00e9e d&#039;utilisation de SQLFlow.<\/h3>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-4\">\n\n<div class=\"wp-block-column is-layout-flow\">\n\n<h3 class=\"wp-block-heading\">Mode GUI<\/h3>\n\n\n\n<p>D\u00e9couvrez la provenance des donn\u00e9es \u00e0 l&#039;aide d&#039;une interface graphique.<\/p>\n\n\n\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\">\n\n<h3 class=\"wp-block-heading\">Mode ligne de commande<\/h3>\n\n\n\n<p>Tra\u00e7abilit\u00e9 automatis\u00e9e des donn\u00e9es via la ligne de commande<\/p>\n\n\n\n<\/div>\n\n\n<\/div>\n\n\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\">\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 style=\"text-align: center;\">Vid\u00e9o sur la tra\u00e7abilit\u00e9 des donn\u00e9es SQL Server<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-video\"><div class=\"wp-block-embed__wrapper\"><iframe loading=\"lazy\" width=\"800\" height=\"450\" src=\"https:\/\/www.youtube.com\/embed\/00Lgzy7ktpc\" frameborder=\"0\" allowfullscreen><\/iframe><\/div><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3>Vous ne souhaitez pas envoyer le sch\u00e9ma de votre base de donn\u00e9es SQL Server au serveur SQLFlow distant\u00a0?<\/h3>\n<p>Pas de probl\u00e8me ! Vous pouvez configurer <a href=\"https:\/\/www.gudusoft.com\/fr\/sqlflow-on-premise-version\/\">la version SQLFlow On-Premise<\/a> au sein de votre propre organisation et b\u00e9n\u00e9ficiez de toutes les fonctionnalit\u00e9s <a href=\"https:\/\/www.gudusoft.com\/fr\/sqlflow-cloud\/\">la version cloud de SQLFlow<\/a> alors qu&#039;aucune donn\u00e9e n&#039;est transf\u00e9r\u00e9e via Internet.<\/p>\n<h3>Besoin de d\u00e9couvrir la provenance des donn\u00e9es provenant d&#039;autres bases de donn\u00e9es\u00a0?<\/h3>\n<p>Pas de probl\u00e8me\u00a0! SQLFlow prend en charge les principales bases de donn\u00e9es, notamment\u00a0: BigQuery, Couchbase, DAX, DB2, Greenplum, HANA, Hive, Impala, Informix, MDX, MySQL, Netezza, OpenGE, Oracle, PostgreSQL, Redshift, Snowflake, SQL Server, Sybase, Teradata et Vertica.<\/p>\n<h3>Besoin de d\u00e9couvrir la provenance des donn\u00e9es issues des syst\u00e8mes de contr\u00f4le de version\u00a0?<\/h3>\n<p>Aucun probl\u00e8me\u00a0! Grabit peut r\u00e9cup\u00e9rer tous les scripts SQL depuis les syst\u00e8mes de contr\u00f4le de version comme GitHub et Bitbucket et les envoyer \u00e0 SQLFlow pour l&#039;analyse de la tra\u00e7abilit\u00e9 des donn\u00e9es. Tout cela se fait automatiquement\u00a0; il vous suffit de saisir vos identifiants GitHub ou Bitbucket.<\/p>\n\n\n\n<\/div>\n\n\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-13\">\n\n<div class=\"wp-block-column is-layout-flow\">\n\n<h2 style=\"text-align: center;\"><span style=\"font-size: 50px; color: #aa1829;\" data-fusion-font=\"true\">Passez \u00e0 la version Premium et utilisez SQLFlow d\u00e8s maintenant<\/span><\/h2>\n<h3 style=\"text-align: center;\"><span style=\"font-size: 35px; color: #aa1829;\" data-fusion-font=\"true\">D\u00e9couvrez toutes les fonctionnalit\u00e9s extraordinaires<\/span><\/h3>\n\n\n\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:20%\">\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:60%\">\n\n<ul>\n<li>Votre compte premium sera activ\u00e9 dans les 3 minutes<\/li>\n\n\n<li><p style=\"text-align: left;\">Acc\u00e8s illimit\u00e9 au service cloud SQLFlow<\/p><\/li>\n\n\n<li>Acc\u00e8s API enti\u00e8rement RESTful<\/li>\n\n\n<li>Automatisez la tra\u00e7abilit\u00e9 des donn\u00e9es de votre instance de base de donn\u00e9es<\/li>\n\n\n<li>Automatiser la tra\u00e7abilit\u00e9 des donn\u00e9es \u00e0 partir d&#039;un d\u00e9p\u00f4t Github\/Bitbucket<\/li>\n\n<\/ul>\n\n\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:40%\">\n\n<a href=\"#\" class=\"myButton\" style=\"vertical-align:middle\" data-fsc-item-path-value='sqlflow-premium-account-monthly-subscription' data-fsc-action=\"Add, Checkout\">Achetez maintenant, seulement $49,99 par mois<\/a>\n\n\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\">\n\n<h3 style=\"text-align: center;\"><span style=\"font-size: 35px; color: #aa1829;\" data-fusion-font=\"true\">Garantie satisfait ou rembours\u00e9 de 7 jours, sans poser de questions !<\/span><\/h3>\n\n\n\n<\/div>\n\n\n<\/div>","protected":false},"excerpt":{"rendered":"<p>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;\u00a0 You can specify included database, schema or exclude database, schema Send the exported data to\u00a0https:\/\/sqlflow.gudusoft.com\u00a0for automatically data lineage analysis Check the data lineage result on\u00a0https:\/\/sqlflow.gudusoft.com\u00a0under 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\u2026<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[38,31,45],"tags":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"_links":{"self":[{"href":"https:\/\/www.gudusoft.com\/fr\/wp-json\/wp\/v2\/posts\/2667"}],"collection":[{"href":"https:\/\/www.gudusoft.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gudusoft.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/fr\/wp-json\/wp\/v2\/comments?post=2667"}],"version-history":[{"count":17,"href":"https:\/\/www.gudusoft.com\/fr\/wp-json\/wp\/v2\/posts\/2667\/revisions"}],"predecessor-version":[{"id":6634,"href":"https:\/\/www.gudusoft.com\/fr\/wp-json\/wp\/v2\/posts\/2667\/revisions\/6634"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/fr\/wp-json\/wp\/v2\/media?parent=2667"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gudusoft.com\/fr\/wp-json\/wp\/v2\/categories?post=2667"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gudusoft.com\/fr\/wp-json\/wp\/v2\/tags?post=2667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}