Skip to Content

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

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Istvan Balazs

    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

    (0) 

Leave a Reply