cancel
Showing results for 
Search instead for 
Did you mean: 

How Do I Automate the script for Target table in HANA

Former Member
0 Kudos

Hi,

I am using BODS tool to load the Flat File Data  to HANA DB Tables.

Every time, when i ran the job  it loads the data into HANA table. After job has completed and I manually open the

HANA studio and run the two line Procedure script which takes around 20 mints of time .

So, My requirement is-- is there any automation process to run the script automatically, once job has completed in the BODS it self.

Even i have investigate on this and i got one point that, there is Pre load and Post load commands in BODS.

please suggest if its suits here or please guide any suggestions here.

I am new to this tool, please help me out to resolve this.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

sure

1) Use your procedure under Post-Load command.

or


2) Use script after dataflow and try sql inbuilt function.

Answers (2)

Answers (2)

former_member198401
Active Contributor
0 Kudos

You can use the SQL() function in the script object to call the Stored Procedure in SAP HANA. For more details refer DS Reference Guide

sql('HANA_DATASTORE_NAME','HANA_STORED_PROC_NAME')

Refer below post which is beautifully explained by .

Below is the explanation from DS Reference Guide:

SAP Data Services supports SAP HANA stored procedures with zero, one, or more output parameters.Data Services supports scalar data types for input and output parameters. Table data types are not supported; if you try to import a procedure with table type, you will receive an error message. Data Services does not support data types such as binary, blob, clob, nclob, or varbinary for SAP HANA procedure parameters.

Procedures can be called from a script or a Query transform as a new function call.

Limitations: SAP HANA provides limited support of user-defined functions (usually written in L), which can return one or several scalar values. The usage of such functions is limited to the projection list and the GROUP BY clause of an aggregation query on top of an OLAP cube or a column table. These functions are not supported by Data Services.SAP HANA procedures cannot be called from a WHERE clause

Regards

Arun Sasi

Former Member
0 Kudos

Hi Mahesh,

As we cannot pass the scripts in "POSTLOAD" & "PRELOAD" commands. It is better to place the regular scripts after the last data flow in your job.

Suggestion :- What ever the procedure script you are executing manually, can be placed in a bods script and that could serve your requirement.

PFA, below screen shot for your reference.

Place the script as shown below

Update the script as like the sample script shown below..

Regards,

Samatha B