Skip to Content
0

which one is better to use XSJS or HDBProcedure?

Feb 21, 2017 at 11:31 PM

51

avatar image
Hans Yustiawan

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
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
avatar image
Mrityunjay Pandey Answered 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
▼ Viewable by all users
Hans Yustiawan
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

0
Comment