{"id":2539,"date":"2022-09-10T05:59:46","date_gmt":"2022-09-10T10:59:46","guid":{"rendered":"https:\/\/www.dpriver.com\/blog\/?p=2539"},"modified":"2022-09-10T08:31:41","modified_gmt":"2022-09-10T13:31:41","slug":"teradata-data-lineage-tool","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2022\/09\/teradata-data-lineage-tool\/","title":{"rendered":"Teradata 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>Teradata is&nbsp;<strong>a fully scalable relational database management system produced by Teradata Corp<\/strong>. It is widely used to manage large data warehousing operations<\/p>\n\n\n\n<p><a href=\"https:\/\/sqlflow.gudusoft.com\">Gudu SQLFlow<\/a> can connect to the Teradata Database via its own connection. It can automate metadata discovery to deliver a complete, detailed overview of data flows in the Teradata Database. Using this information, Gudu SQLFlow creates a detailed graph 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 Teradata 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-vertically-aligned-center 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=\"799\" height=\"205\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/09\/799px-Teradata_Logo.png\" alt=\"\" class=\"wp-image-2542\" srcset=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/09\/799px-Teradata_Logo.png 799w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/09\/799px-Teradata_Logo-300x77.png 300w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/09\/799px-Teradata_Logo-768x197.png 768w\" sizes=\"(max-width: 799px) 100vw, 799px\" \/><\/figure>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Gudu SQLFlow currently scans the Teradata 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><li>Macro<\/li><li>BTEQ scripts<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Discover data lineage in the Teradata database in 3 minutes<\/h4>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"1908\" height=\"884\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/09\/sqlflow-teradata-database-data-lineage2-min.gif\" alt=\"teradata data lineage tool\" class=\"wp-image-2549\"\/><\/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>Teradata is&nbsp;a fully scalable relational database management system produced by Teradata Corp. It is widely used to manage large data warehousing operations Gudu SQLFlow can connect to the Teradata Database via its own connection. It can automate metadata discovery to deliver a complete, detailed overview of data flows in the Teradata Database. Using this information, Gudu SQLFlow creates a detailed graph 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, implementing DataOps, or preparing for a compliance audit, Gudu SQLFlow can help\u2026<\/p>\n","protected":false},"author":1,"featured_media":2548,"comment_status":"closed","ping_status":"closed","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>Teradata data lineage tool<\/title>\n<meta name=\"description\" content=\"Teradata 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\/2022\/09\/teradata-data-lineage-tool\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Teradata data lineage tool\" \/>\n<meta property=\"og:description\" content=\"Teradata data lineage tool\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dpriver.com\/blog\/2022\/09\/teradata-data-lineage-tool\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and Data Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-10T10:59:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-10T13:31:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/09\/teradata_snail.png\" \/>\n\t<meta property=\"og:image:width\" content=\"224\" \/>\n\t<meta property=\"og:image:height\" content=\"224\" \/>\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\/2022\/09\/teradata-data-lineage-tool\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/2022\/09\/teradata-data-lineage-tool\/\",\"name\":\"Teradata data lineage tool\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\"},\"datePublished\":\"2022-09-10T10:59:46+00:00\",\"dateModified\":\"2022-09-10T13:31:41+00:00\",\"description\":\"Teradata data lineage tool\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/2022\/09\/teradata-data-lineage-tool\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dpriver.com\/blog\/2022\/09\/teradata-data-lineage-tool\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/2022\/09\/teradata-data-lineage-tool\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dpriver.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Teradata data lineage tool\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/2022\/09\/teradata-data-lineage-tool\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/2022\/09\/teradata-data-lineage-tool\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7\"},\"headline\":\"Teradata data lineage tool\",\"datePublished\":\"2022-09-10T10:59:46+00:00\",\"dateModified\":\"2022-09-10T13:31:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/2022\/09\/teradata-data-lineage-tool\/\"},\"wordCount\":331,\"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":"Teradata data lineage tool","description":"Teradata 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\/2022\/09\/teradata-data-lineage-tool\/","og_locale":"en_US","og_type":"article","og_title":"Teradata data lineage tool","og_description":"Teradata data lineage tool","og_url":"https:\/\/www.dpriver.com\/blog\/2022\/09\/teradata-data-lineage-tool\/","og_site_name":"SQL and Data Blog","article_published_time":"2022-09-10T10:59:46+00:00","article_modified_time":"2022-09-10T13:31:41+00:00","og_image":[{"width":224,"height":224,"url":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/09\/teradata_snail.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\/2022\/09\/teradata-data-lineage-tool\/","url":"https:\/\/www.dpriver.com\/blog\/2022\/09\/teradata-data-lineage-tool\/","name":"Teradata data lineage tool","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/#website"},"datePublished":"2022-09-10T10:59:46+00:00","dateModified":"2022-09-10T13:31:41+00:00","description":"Teradata data lineage tool","breadcrumb":{"@id":"https:\/\/www.dpriver.com\/blog\/2022\/09\/teradata-data-lineage-tool\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dpriver.com\/blog\/2022\/09\/teradata-data-lineage-tool\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dpriver.com\/blog\/2022\/09\/teradata-data-lineage-tool\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dpriver.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Teradata data lineage tool"}]},{"@type":"Article","@id":"https:\/\/www.dpriver.com\/blog\/2022\/09\/teradata-data-lineage-tool\/#article","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/2022\/09\/teradata-data-lineage-tool\/"},"author":{"name":"admin","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7"},"headline":"Teradata data lineage tool","datePublished":"2022-09-10T10:59:46+00:00","dateModified":"2022-09-10T13:31:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dpriver.com\/blog\/2022\/09\/teradata-data-lineage-tool\/"},"wordCount":331,"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\/2539"}],"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=2539"}],"version-history":[{"count":6,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/2539\/revisions"}],"predecessor-version":[{"id":2550,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/2539\/revisions\/2550"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/media\/2548"}],"wp:attachment":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/media?parent=2539"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/categories?post=2539"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/tags?post=2539"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}