{"id":2669,"date":"2023-02-24T09:37:04","date_gmt":"2023-02-24T14:37:04","guid":{"rendered":"https:\/\/www.dpriver.com\/blog\/?p=2669"},"modified":"2023-02-24T09:41:51","modified_gmt":"2023-02-24T14:41:51","slug":"data-visualization","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2023\/02\/data-visualization\/","title":{"rendered":"Data Visualization with SQLFlow"},"content":{"rendered":"\n

Being able to know when the data is changed, how it is modified and who did the update secures your data flow, gives the insights of what strategy your business shall apply and more importantly, helps you to avoid the potential data issues on your business. <\/p>\n\n\n\n

You may have encountered the following problems in your daily work:<\/p>\n\n\n\n

- How can I generate ER Diagram from my database<\/li>
- How should I easily understand the relationships between my data and get a clear view on it<\/li>
- Where does this data error come from? Is there a way for me to easily trace the error source?<\/li>
- …<\/li><\/ul>\n\n\n\n

  Seems all the above issues are pointing to an ultimate final question: How to visualize my data?<\/strong><\/p>\n\n\n\n

  By visualizing the data, we can retrieve the output as an ER diagram, a Json\/CSV style metadata file or the schema of data lineage<\/strong>. <\/p>\n\n\n\n

  ### SQLFlow, a vibrant, out of box data lineage and data visualization analysis tool<\/strong><\/h3>\n\n\n\n

  Gudu SQLFlow<\/a> has the ability to analyze complex SQL transimitions and supports more than 20 types of relational and non-relational database. Your business platform can be quickly integrated with Gudu SQLFlow by with Gudu SQLFlow UI<\/em>, Gudu SQLFlow Rest API<\/em>, Gudu SQLFlow library<\/em> or Gudu SQLFlow Widget<\/em>.<\/p>\n\n\n\n

  <\/figure>\n\n\n\n

  SQLFlow<\/a> specializes in the field of data analysis for visualization . It empowers the data lineage analysis capability and provide the data visualization solutions for enterprises such as Oracle, SAP, SAMSUNG, J.P.Morgan etc<\/em>.<\/p>\n\n\n

  \n
  <\/figure><\/div>\n\n\n

  Supporting more than 20 major databases and still growing, SQLFlow provides automation in building the lineage no matter where the SQL resides: databases, file system, Github, Bitbucket and etc.<\/p>\n\n\n\n

  <\/figure>\n\n\n\n

  SQLFlow<\/a> is able to visualize the data with your expected format, based on the input you give(you can either directly connect to database or just give the database log, metadata file), it can generate:<\/p>\n\n\n\n

  ### E-R Diagram<\/a><\/h3>\n\n\n\n
  <\/figure>\n\n\n\n

  ### Picture file<\/h3>\n\n\n\n
  <\/figure>\n\n\n\n

  ### Json\/CSV<\/h3>\n\n\n\n
  <\/figure>\n\n\n\n

  ## SQLFlow is designed for<\/strong><\/h2>\n\n\n\n
  - Improving data quality, providing the trust in data and escorting corporate decision-making.<\/li><\/ul>\n\n\n\n
    - Regulatory compliance, a complete data trace display to meet the data compliance requirements.<\/li><\/ul>\n\n\n\n
      - Data intelligence, visualization of the data dependencies and locating data at all levels.<\/li><\/ul>\n\n\n\n
        - Empowering your business system, supporting the rapid iteration of the system.<\/li><\/ul>\n\n\n\n

          Try the SQLFlow online web tool<\/a> now and sign up for free!<\/p>\n","protected":false},"excerpt":{"rendered":"

          Being able to know when the data is changed, how it is modified and who did the update secures your data flow, gives the insights of what strategy your business shall apply and more importantly, helps you to avoid the potential data issues on your business. You may have encountered the following problems in your daily work: How can I generate ER Diagram from my database How should I easily understand the relationships between my data and get a clear view on it Where does this data error come from? Is there a way for me to easily trace the\u2026<\/p>\n","protected":false},"author":6,"featured_media":2459,"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":"\nData Visualization with SQLFlow<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n\n\n\n\t\n\t\n\t\n