{"id":1840,"date":"2020-11-28T06:54:37","date_gmt":"2020-11-28T06:54:37","guid":{"rendered":"https:\/\/www.gudusoft.com\/?page_id=1840"},"modified":"2026-07-14T02:14:23","modified_gmt":"2026-07-14T10:14:23","slug":"get-started-with-data-lineage-example","status":"publish","type":"page","link":"https:\/\/www.gudusoft.com\/fr\/exemple-de-demarrage-avec-la-lignee-de-donnees\/","title":{"rendered":"Commencer"},"content":{"rendered":"<p>Nouveau sur <strong>Gudu SQLFlow<\/strong>Commencez ici. Collez une requ\u00eate et obtenez la tra\u00e7abilit\u00e9 des donn\u00e9es au niveau des colonnes en quelques secondes. Vous trouverez ci-dessous un exemple concret, les trois fa\u00e7ons d&#039;utiliser SQLFlow et les prochaines \u00e9tapes. Seules des connaissances de base en SQL sont n\u00e9cessaires\u00a0; aucune exp\u00e9rience pr\u00e9alable en tra\u00e7abilit\u00e9 des donn\u00e9es n&#039;est requise.<\/p>\n\n\n\n<div class=\"gd-stats\">\n<div class=\"gd-stat\"><b>Gratuit<\/b><span>Visualiseur en ligne \u2014 aucune inscription requise pour les exemples<\/span><\/div>\n<div class=\"gd-stat\"><b>39<\/b><span>Les dialectes SQL pris en charge<\/span><\/div>\n<div class=\"gd-stat\"><b>3<\/b><span>Modes d&#039;utilisation\u00a0: interface utilisateur, API REST, sur site<\/span><\/div>\n<div class=\"gd-stat\"><b>Niveau de colonne<\/b><span>lign\u00e9e, directe et indirecte<\/span><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-group gd-callout is-layout-constrained\"><div class=\"wp-block-group__inner-container\">\n\n<p><strong>Essayez-le maintenant\u00a0:<\/strong> ouvrir le <a href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=get-started\" target=\"_blank\" rel=\"noreferrer noopener\">Visualiseur SQLFlow gratuit<\/a>Collez le code SQL ci-dessous, s\u00e9lectionnez la base de donn\u00e9es et cliquez sur <em>Visualiser<\/em>.<\/p>\n\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Exemple concret\u00a0: tra\u00e7abilit\u00e9 au niveau des colonnes \u00e0 partir d\u2019une requ\u00eate<\/h2>\n\n\n\n<p>Consid\u00e9rons cette instruction, qui charge un tableau r\u00e9capitulatif \u00e0 partir de deux tables sources\u00a0:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO deptsal (dept_no, dept_name, salary) SELECT d.deptno, d.dname, SUM(e.sal + NVL(e.comm, 0)) AS sal FROM dept d LEFT JOIN (SELECT * FROM emp WHERE hiredate &gt; DATE &#039;1980-01-01&#039;) e ON e.deptno = d.deptno GROUP BY d.deptno, d.dname;<\/code><\/pre>\n\n\n\n<p>Les donn\u00e9es dans <code>d\u00e9partemental<\/code> vient de <code>d\u00e9partement<\/code> et <code>employ\u00e9<\/code>SQLFlow en d\u00e9duit la valeur exacte <strong>niveau de colonne<\/strong> relations :<\/p>\n\n\n\n<ul>\n<li><code>deptsal.dept_no<\/code> vient de <code>d\u00e9partement.deptno<\/code><\/li>\n<li><code>deptsal.nom_du_d\u00e9partement<\/code> vient de <code>nom du d\u00e9partement<\/code><\/li>\n<li><code>deptsal.salaire<\/code> vient de <code>emp.sal<\/code> et <code>emp.com<\/code>, combin\u00e9s par <code>SOMME(...)<\/code><\/li>\n<\/ul>\n\n\n\n<p>Il capture \u00e9galement le <strong>lign\u00e9e indirecte<\/strong> qui fa\u00e7onne le r\u00e9sultat sans y appara\u00eetre : <code>date d&#039;embauche<\/code> dans le <code>O\u00d9<\/code> filtre et <code>d\u00e9partement.deptno<\/code>\/<code>emp.deptno<\/code> dans le <code>REJOINDRE<\/code>SQLFlow transforme tout cela en un diagramme interactif que vous pouvez explorer, suivre en amont et en aval, et exporter.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.gudusoft.com\/wp-content\/uploads\/2020\/11\/tutorial_diagram_panel.jpg\" alt=\"Interface SQLFlow affichant un diagramme de tra\u00e7abilit\u00e9 des donn\u00e9es au niveau des colonnes\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Trois fa\u00e7ons d&#039;utiliser SQLFlow<\/h2>\n\n\n\n<div class=\"gd-linkgrid\">\n<a class=\"gd-linkcard\" href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=get-started\" target=\"_blank\" rel=\"noreferrer noopener\"><b>Interface utilisateur Web en ligne<\/b><span>Collez du code SQL, t\u00e9l\u00e9chargez des fichiers ou connectez-vous \u00e0 une base de donn\u00e9es directement dans votre navigateur\u00a0\u2014 c\u2019est gratuit pour commencer.<\/span><\/a>\n<a class=\"gd-linkcard\" href=\"https:\/\/www.gudusoft.com\/fr\/api-restful-sqlflow\/\"><b>API REST<\/b><span>Envoyez des requ\u00eates SQL via HTTP et recevez le graphe de lignage au format JSON, pour les pipelines et les outils.<\/span><\/a>\n<a class=\"gd-linkcard\" href=\"https:\/\/www.gudusoft.com\/fr\/sqlflow-on-premise-version\/\"><b>Sur site<\/b><span>H\u00e9bergez l&#039;int\u00e9gralit\u00e9 du moteur sur votre r\u00e9seau, isol\u00e9 du r\u00e9seau physique, afin que SQL ne le quitte jamais.<\/span><\/a>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Prochaines \u00e9tapes<\/h2>\n\n\n\n<div class=\"gd-linkgrid\">\n<a class=\"gd-linkcard\" href=\"https:\/\/sqlflow.gudusoft.com\/\"><b>Inscrivez-vous pour un compte gratuit<\/b><span>Des apports plus importants et du travail \u00e9conomis\u00e9<\/span><\/a>\n<a class=\"gd-linkcard\" href=\"https:\/\/docs.gudusoft.com\/1.-introduction\/getting-started\/\"><b>Guide de d\u00e9marrage<\/b><span>La proc\u00e9dure compl\u00e8te se trouve dans la documentation.<\/span><\/a>\n<a class=\"gd-linkcard\" href=\"https:\/\/docs.gudusoft.com\/1.-introduction\/getting-started\/how-to-use-sqlflow\/\"><b>Comment utiliser SQLFlow<\/b><span>Interface utilisateur, API et d\u00e9ploiement sur site\u00a0: explications<\/span><\/a>\n<a class=\"gd-linkcard\" href=\"https:\/\/www.gudusoft.com\/fr\/api-restful-sqlflow\/\"><b>API REST<\/b><span>Automatiser l&#039;extraction de lign\u00e9es via HTTP<\/span><\/a>\n<a class=\"gd-linkcard\" href=\"https:\/\/www.gudusoft.com\/fr\/telecharger-data-lineage-bibliotheque-java\/\"><b>Biblioth\u00e8que Java<\/b><span>Int\u00e9grez le moteur de lignage dans les applications JVM<\/span><\/a>\n<a class=\"gd-linkcard\" href=\"https:\/\/www.gudusoft.com\/fr\/grabit\/\"><b>Ingestionnaire SQLFlow<\/b><span>Collecter les requ\u00eates SQL provenant de bases de donn\u00e9es, de Git et de fichiers<\/span><\/a>\n<a class=\"gd-linkcard\" href=\"https:\/\/www.gudusoft.com\/fr\/ressources\/\"><b>Centre de ressources<\/b><span>Guides, historique par base de donn\u00e9es et documentation<\/span><\/a>\n<a class=\"gd-linkcard\" href=\"https:\/\/www.gudusoft.com\/fr\/faq-sql-flow\/\"><b>FAQ<\/b><span>R\u00e9ponses concernant les produits, les donn\u00e9es, les prix et les comptes<\/span><\/a>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull gd-band gd-band-navy gd-cta is-layout-constrained\" style=\"padding-top:56px;padding-bottom:56px\"><div class=\"wp-block-group__inner-container\">\n\n<h2 class=\"wp-block-heading\">Pr\u00eat \u00e0 voir votre propre SQL ?<\/h2>\n\n\n<p>Collez une requ\u00eate dans le visualiseur gratuit et observez l&#039;apparition de sa lign\u00e9e au niveau des colonnes.<\/p>\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-2\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=get-started\" target=\"_blank\" rel=\"noreferrer noopener\">Essayez SQLFlow gratuitement<\/a><\/div>\n\n\n\n<div class=\"wp-block-button is-style-outline\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.gudusoft.com\/fr\/outil-de-lignee-de-donnees-sql\/\">Explorez l&#039;outil de lign\u00e9e<\/a><\/div>\n<\/div>\n\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>New to Gudu SQLFlow? Start here. Paste a query and get column-level data lineage in seconds. Below is a worked example, the three ways to use SQLFlow, and where to go next. You only need basic SQL knowledge \u2014 no prior data lineage experience required. Freeonline visualizer \u2014 no signup for examples 39SQL dialects supported 3ways to use it \u2014 UI, REST API, on-premise Column-levellineage, direct and indirect Try it now: open the free SQLFlow visualizer, paste the SQL below, pick the database, and click Visualize. A worked example: column-level lineage from one query Consider this statement, which loads a\u2026<\/p>","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"_links":{"self":[{"href":"https:\/\/www.gudusoft.com\/fr\/wp-json\/wp\/v2\/pages\/1840"}],"collection":[{"href":"https:\/\/www.gudusoft.com\/fr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.gudusoft.com\/fr\/wp-json\/wp\/v2\/types\/page"}],"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=1840"}],"version-history":[{"count":40,"href":"https:\/\/www.gudusoft.com\/fr\/wp-json\/wp\/v2\/pages\/1840\/revisions"}],"predecessor-version":[{"id":6837,"href":"https:\/\/www.gudusoft.com\/fr\/wp-json\/wp\/v2\/pages\/1840\/revisions\/6837"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/fr\/wp-json\/wp\/v2\/media?parent=1840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}