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

which one is better to use XSJS or HDBProcedure?

Posted on Feb 21, 2017 at 11:31 PM 79 Views

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.

Thanks!!

development tools for SAP Cloud Platform SAP HANA studio SAP Cloud Platform
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Mrityunjay Pandey
    Mrityunjay Pandey
    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
      Feb 22, 2017 at 04:13 AM

      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