which one is better to use XSJS or HDBProcedure?

[Former Member]

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!!

[former_member228588 · Accepted solution]

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.

[Former Member · Accepted solution]

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