SAP Hana Cloud-7.305.1447

SAP Hana Cloud

Author Arun Kumar(arunk@argos-labs.com)

: Sandeep Kumar (sandeepsharma@argos-labs.com)

Primary Features

Sap hana cloud plugin is used to connect to cloud database and we can perform the database operations such as delete ,create ,update, fetchall ,fetchone and insert.

Need help?

Technical contact to tech@argos-labs.com

May you search all operations,

Input (Requirement)

SAP Database Op- Select the database operation.

Advanced Input (Optional)

Host- Enter the host name.
User- Enter the username of database.
Port- Enter the Port number.
Password- Enter the password.
SQL Query: Enter the sql query.

Return Value

Return Value: It will return the output in string format.

Create set up for SAP Hana Cloud

1.Create your account - https://account.hana.ondemand.com/#/home/welcome

- Select service marketplace search for sap hana cloud and then create the instance for sap hana cloud.

And then assign role collection for sap hana cloud and select sap hana cloud administrator.

Copy the Host name and User name from properties

Parameter setting examples (diagrams)

Query

Create:

CREATE TABLE TEST_TABLE( ID INTEGER PRIMARY KEY, NAME NVARCHAR(40), CREATED_AT TIMESTAMP);

Fetchall:

SELECT * FROM TEST_TABLE;

Delete:

DELETE FROM TEST_TABLE WHERE ID = 1;

Update:

UPDATE TEST_TABLE SET NAME = 'raj' WHERE ID = 1;

FetchOne:

SELECT NAME FROM TEST_TABLE WHERE ID = 2;

Insert :

INSERT INTO TEST_TABLE (ID, NAME, CREATED_AT)

VALUES (2,'sameer', CURRENT_TIMESTAMP)

Return Code

0 Execution successful
1 Execution failed