{"id":2493,"date":"2022-08-28T08:36:58","date_gmt":"2022-08-28T13:36:58","guid":{"rendered":"https:\/\/www.dpriver.com\/blog\/?p=2493"},"modified":"2022-09-10T09:43:04","modified_gmt":"2022-09-10T14:43:04","slug":"sql-server-data-lineage-tool","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2022\/08\/sql-server-data-lineage-tool\/","title":{"rendered":"SQL Server data lineage tool"},"content":{"rendered":"\n

<\/p>\n\n\n\n

\n
\n

Gudu SQLFlow<\/a> can connect to the SQL Server\/MSSQL database via its own connection. It can scan the metadata and read all the SQL stored procedure code and logic stored in it. 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

\n
Try SQLFlow Now<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\n
\n
<\/figure>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n

#### Gudu SQLFlow currently scans SQL Server database<\/h4>\n\n\n\n

<\/p>\n\n\n\n

- SQL scripts<\/li>
- T-SQL scripts<\/li>
- View<\/li>
- Stored procedures<\/li>
- Functions<\/li>
- Triggers<\/li>
- Data dictionaries<\/li><\/ul>\n\n\n\n

  #### Discover data lineage in SQL Server database in 5 minutes<\/h4>\n\n\n\n
  <\/figure>\n\n\n\n

  #### What data lineage is important?<\/h4>\n\n\n\n

  Data lineage helps you know data complexity and gives you a full overview of how your data moves across systems, including where it originated, how it transforms along the way, and how it\u2019s interconnected. Such an overview will help you boost your data governance efforts, increase overall trust in data, achieve full regulatory compliance, accelerate root cause and impact analyses, roll out our frequent bug-free releases, painlessly migrate to the cloud, and more. <\/p>\n\n\n\n

  #### Why choose Gudu SQLFlow?<\/h4>\n\n\n\n

  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

  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>\n\n\n\n

  \n
  Try Gudu SQLFlow Now<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

  Gudu SQLFlow can connect to the SQL Server\/MSSQL database via its own connection. It can scan the metadata and read all the SQL stored procedure code and logic stored in it. 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. Gudu SQLFlow currently scans SQL Server database SQL scripts T-SQL scripts View Stored procedures Functions Triggers Data dictionaries Discover data lineage in SQL Server database in 5 minutes What data lineage is important? Data lineage helps\u2026<\/p>\n","protected":false},"author":1,"featured_media":2497,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[93],"tags":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"\nSQL Server data lineage tool<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n