Skip to Content
0

which one is better to use XSJS or HDBProcedure?

Feb 21, 2017 at 11:31 PM

52

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Feb 22, 2017 at 02:25 AM
0

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.

Show 1 Share
10 |10000 characters needed characters left 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

0