Skip to Content
author's profile photo Former Member
Former Member

which one is better to use XSJS or HDBProcedure?

Both of them can create the same functionality to manipulates the data in the system.

I am not sure in which case or if there is a case, which one is better to use if I want to manipulates a data? I have developed a lot of things but mostly by using the XSJS not HDBProcedure.


Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on Feb 22, 2017 at 02:25 AM

    Hi Hans

    I think it depends where are we going to use XSJS or HDBProcedure. For example, if you are working in a scenario where we have exposed SAP HANA views/Table and need to update some entry in our HANA tables, in this case we will prefer to use XSJS scripting, but in case we we are working within datawarehouse and need to update an integration layer from staging layer , then we would prefer to use HDBProcedures. hope this will help you.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Mrityunjay,

      Thanks for answering my question!

      I spent most of my development using SAP HANA Modelling Views/Tables, does that mean XSJS scripting is better? and avoid using the procedure at all costs?

      In more depth, does XSJS scripting executes the SQL in index server like HDBProcedure does? Thanks in advance