Skip to Content

SAP HANA Data Flow Visualization

Problem description: sometimes it’s useful to have graphical representation of SAP HANA objects interaction. SAP HANA Studio doesn’t have such functionality.


There are a lot of javascript visualization libraries, vis.js (http://visjs.org/) is one of the most popular of such libraries. Vis.js library is easy to use and has many demo examples. This library is used for visualization in this demo project.


Demo project consists of 3 parts: HANA Views (MODEL folder), HANA XSJS Services(SERVICE folder) and vis.js part (VIS folder):

Tree.PNG

For testing of this project, you have to place XS DFV project (in attachment, replace .txt with .zip) in the root of your SAP HANA system and activate it. Then launch HANADataFlowVisualization.html: http://host:port/DFV/VIS/HANADataFlowVisualization.html?path=DFV. Variable path=DFV means that DFV is the HANA package for visualization. Output:

Data Flow.PNG

So you are able to analyze relations between views, tables and procedure, check author of objects and full technical name of objects.


Github: GitHub – dmitrimarinin/SAP_HANA_Dataflow_vis: SAP HANA Data Flow Visualization

2 Comments
You must be Logged on to comment or reply to a post.
  • Great article! Always in a need for tools that are not out of the box.

    I tried to recreate DFV in my system and during testing received an error message.

    [Deprecation] Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user’s experience. For more help, check https://xhr.spec.whatwg.org/.

     

    then I tried replacing sap-ui-core, /sap/ui5/1/resources/sap-ui-core.js

    with multiple version of SAP UI SDK

    script src=“https://sapui5.hana.ondemand.com/1.28.37/resources/sap-ui-core.js”

    script src=“https://sapui5.hana.ondemand.com/1.36.10/resources/sap-ui-core.js”

    script src=“https://sapui5.hana.ondemand.com/1.40.10/resources/sap-ui-core.js”

    and received same error message.

    with latest SAPUI5 version.

    1.46.7 is referring to jquery, JSON model.

    Do you have any recommendation how to fix this issue?

    Best Regards,

    Istvan

    • Hi Istvan.

      I uploaded a delivey unit to GitHub. I tested it on SAP HANA express edition – hana2sp02. It works fine.

      Regards,

      Dmitry.