{"id":2521,"date":"2022-08-29T09:58:35","date_gmt":"2022-08-29T14:58:35","guid":{"rendered":"https:\/\/www.dpriver.com\/blog\/?p=2521"},"modified":"2022-09-10T09:31:57","modified_gmt":"2022-09-10T14:31:57","slug":"azure-sql-data-lineage-tool","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/azure-sql-data-lineage-tool\/","title":{"rendered":"Azure SQL data lineage tool"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-6\">\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:66.66%\">\n<p>Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.<\/p>\n\n\n\n<p><a href=\"https:\/\/sqlflow.gudusoft.com\">Gudu SQLFlow<\/a> can connect to the Azure SQL Database via its own connection. It can automate metadata discovery to deliver a complete, detailed overview of data flows in the Azure SQL Database. Using this information, Gudu SQLFlow creates a detailed visualization of the data lineage in JSON format that can be pushed into any third-party metadata management solution or viewed in Gudu SQLFlow\u2019s native visualization.<\/p>\n\n\n\n<p>When planning migrations, implementing DataOps, or preparing for a compliance audit, Gudu SQLFlow can help teams extract more value from their Azure SQL Database database.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link\" href=\"https:\/\/sqlflow.gudusoft.com\/?ref=dpriver.sqlserver.data.lineage\">Try SQLFlow Now<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:33.33%\">\n<div class=\"wp-block-columns is-layout-flex wp-container-4\">\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:100%\">\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"600\" height=\"600\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/08\/azuresql-data-lineage-gudu-sqlflow.png\" alt=\"\" class=\"wp-image-2529\" srcset=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/08\/azuresql-data-lineage-gudu-sqlflow.png 600w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/08\/azuresql-data-lineage-gudu-sqlflow-300x300.png 300w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/08\/azuresql-data-lineage-gudu-sqlflow-150x150.png 150w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/figure>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Gudu SQLFlow currently scans the Azure SQL database<\/h4>\n\n\n\n<p><\/p>\n\n\n\n<ul><li>SQL scripts<\/li><li>View<\/li><li>Stored procedures<\/li><li>Data dictionaries<\/li><li>functions<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Discover data lineage in the Azure database in 3 minutes<\/h4>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"1908\" height=\"866\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/09\/sqlflow-azure-sql-database-data-lineage-min.gif\" alt=\"azure SQL data lineage tool\" class=\"wp-image-2551\"\/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">What data lineage is important?<\/h4>\n\n\n\n<p>Data lineage is broadly understood as the lifecycle that spans the data\u2019s origin, and where it moves over time across the data estate. It is used for different kinds of backward-looking scenarios such as troubleshooting, tracing root causes in data pipelines, and debugging. Lineage is also used for data quality analysis, compliance, and \u201cwhat if\u201d scenarios often referred to as impact analysis. Lineage is represented visually to show data moving from source to destination including how the data was transformed. Given the complexity of most enterprise data environments, these views can be hard to understand without doing some consolidation or masking of peripheral data points.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Why choose Gudu SQLFlow?<\/h4>\n\n\n\n<p><a href=\"https:\/\/www.gudusoft.com\">Gudu SQLFlow<\/a> automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud, and Hadoop environments by parsing SQL Script and stored procedure. Depict all the data movement graphically.<\/p>\n\n\n\n<p>It supports more than 20 major database types and still growing, including AWS Athena, Google BigQuery, Couchbase, Dax, DB2, Greenplum, SAP Hana, Hive, Impala, Informix, MDX, MySQL, Netezza, odbc, OpenEdge, Oracle, PostgreSQL, presto, AWS Redshift, Snowflake, Spark SQL, SQL server, Sybase, Teradata, HP Vertica.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex\">\n<div class=\"wp-block-button is-style-fill\"><a class=\"wp-block-button__link has-aqua-splash-gradient-background has-background\" href=\"https:\/\/sqlflow.gudusoft.com\" target=\"_blank\" rel=\"noreferrer noopener\">Try Gudu SQLFlow Now<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. Gudu SQLFlow can connect to the Azure SQL Database via its own connection. It can automate metadata discovery to deliver a complete, detailed overview of data flows in the Azure SQL Database. Using this information, Gudu SQLFlow creates a detailed visualization of the data lineage in JSON format that can be pushed into any third-party metadata management solution or viewed in Gudu SQLFlow\u2019s native visualization. When planning migrations,\u2026<\/p>\n","protected":false},"author":1,"featured_media":2529,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[66,93],"tags":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Azure SQL data lineage tool<\/title>\n<meta name=\"description\" content=\"Azure SQL data lineage tool\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dpriver.com\/blog\/azure-sql-data-lineage-tool\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Azure SQL data lineage tool\" \/>\n<meta property=\"og:description\" content=\"Azure SQL data lineage tool\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dpriver.com\/blog\/azure-sql-data-lineage-tool\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and Data Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-29T14:58:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-10T14:31:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/08\/azuresql-data-lineage-gudu-sqlflow.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\",\"name\":\"SQL and Data Blog\",\"url\":\"https:\/\/www.dpriver.com\/blog\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png\",\"contentUrl\":\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png\",\"width\":251,\"height\":72,\"caption\":\"SQL and Data Blog\"},\"image\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\",\"url\":\"https:\/\/www.dpriver.com\/blog\/\",\"name\":\"SQL and Data Blog\",\"description\":\"SQL related blog for database professional\",\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dpriver.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/azure-sql-data-lineage-tool\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/azure-sql-data-lineage-tool\/\",\"name\":\"Azure SQL data lineage tool\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\"},\"datePublished\":\"2022-08-29T14:58:35+00:00\",\"dateModified\":\"2022-09-10T14:31:57+00:00\",\"description\":\"Azure SQL data lineage tool\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/azure-sql-data-lineage-tool\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dpriver.com\/blog\/azure-sql-data-lineage-tool\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/azure-sql-data-lineage-tool\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dpriver.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Azure SQL data lineage tool\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/azure-sql-data-lineage-tool\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/azure-sql-data-lineage-tool\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7\"},\"headline\":\"Azure SQL data lineage tool\",\"datePublished\":\"2022-08-29T14:58:35+00:00\",\"dateModified\":\"2022-09-10T14:31:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/azure-sql-data-lineage-tool\/\"},\"wordCount\":343,\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"articleSection\":[\"Data Governance\",\"SQLFlow\"],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\/\/www.dpriver.com\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Azure SQL data lineage tool","description":"Azure SQL data lineage tool","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dpriver.com\/blog\/azure-sql-data-lineage-tool\/","og_locale":"en_US","og_type":"article","og_title":"Azure SQL data lineage tool","og_description":"Azure SQL data lineage tool","og_url":"https:\/\/www.dpriver.com\/blog\/azure-sql-data-lineage-tool\/","og_site_name":"SQL and Data Blog","article_published_time":"2022-08-29T14:58:35+00:00","article_modified_time":"2022-09-10T14:31:57+00:00","og_image":[{"width":600,"height":600,"url":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/08\/azuresql-data-lineage-gudu-sqlflow.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/www.dpriver.com\/blog\/#organization","name":"SQL and Data Blog","url":"https:\/\/www.dpriver.com\/blog\/","sameAs":[],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png","contentUrl":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png","width":251,"height":72,"caption":"SQL and Data Blog"},"image":{"@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/www.dpriver.com\/blog\/#website","url":"https:\/\/www.dpriver.com\/blog\/","name":"SQL and Data Blog","description":"SQL related blog for database professional","publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dpriver.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.dpriver.com\/blog\/azure-sql-data-lineage-tool\/","url":"https:\/\/www.dpriver.com\/blog\/azure-sql-data-lineage-tool\/","name":"Azure SQL data lineage tool","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/#website"},"datePublished":"2022-08-29T14:58:35+00:00","dateModified":"2022-09-10T14:31:57+00:00","description":"Azure SQL data lineage tool","breadcrumb":{"@id":"https:\/\/www.dpriver.com\/blog\/azure-sql-data-lineage-tool\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dpriver.com\/blog\/azure-sql-data-lineage-tool\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dpriver.com\/blog\/azure-sql-data-lineage-tool\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dpriver.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Azure SQL data lineage tool"}]},{"@type":"Article","@id":"https:\/\/www.dpriver.com\/blog\/azure-sql-data-lineage-tool\/#article","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/azure-sql-data-lineage-tool\/"},"author":{"name":"admin","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7"},"headline":"Azure SQL data lineage tool","datePublished":"2022-08-29T14:58:35+00:00","dateModified":"2022-09-10T14:31:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dpriver.com\/blog\/azure-sql-data-lineage-tool\/"},"wordCount":343,"publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"articleSection":["Data Governance","SQLFlow"],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/www.dpriver.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/2521"}],"collection":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/comments?post=2521"}],"version-history":[{"count":7,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/2521\/revisions"}],"predecessor-version":[{"id":2552,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/2521\/revisions\/2552"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/media\/2529"}],"wp:attachment":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/media?parent=2521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/categories?post=2521"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/tags?post=2521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}