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.
Demo project consists of 3 parts: HANA Views (MODEL folder), HANA XSJS Services(SERVICE folder) and vis.js part (VIS folder):
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:
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
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
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?
I uploaded a delivey unit to GitHub. I tested it on SAP HANA express edition - hana2sp02. It works fine.