on 05-14-2016 5:38 PM
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.
sure
1) Use your procedure under Post-Load command.
or
2) Use script after dataflow and try sql inbuilt function.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.