To perform structured query language (SQL) operations in SAP HANA® via Java database connectivity as part of a chain, add a step that includes a SAP HANA JDBC connection command.
To enable these commands, an IT admin first configures an SAP HANA JDBC connector.
Execute Create
Executes a CREATE
statement
Inputs
Input |
Detail |
SQL Text/File |
Enter the SQL text or file to execute |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid inputs |
3 |
Error |
Failed to run the command |
Execute Query
Executes a SELECT
query, and receives the results as a CSV
Inputs
Input |
Detail |
SQL Text/File |
Enter the SQL text or file to execute |
Delimiter |
Select the delimiter to use in the CSV output |
Preview Results |
To see a preview of the returned rows, check this box |
Outputs
Output |
Output Type |
Record Count |
Integer |
Result Set (CSV) |
File |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid inputs |
3 |
Error |
Failed to run the command |
Execute SQL
Executes any SQL command. If there is a result set, it's available as a file output.
Inputs
Input |
Detail |
SQL Text/File |
Enter the SQL text or file to execute |
Outputs
Output |
Output Type |
Record Count |
Integer |
Result Set (CSV) |
File |
Records Updated |
Integer |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid inputs |
3 |
Error |
Failed to run the command |
Execute Update
Executes an UPDATE
statement
Inputs
Input |
Detail |
SQL Text/File |
Enter the SQL text or file to execute |
Outputs
Output |
Output Type |
Records Updated |
Integer |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid inputs |
3 |
Error |
Failed to run the command |
Get Table Definition
Retrieves the details of a table—including its columns, primary keys, and foreign keys—as JSON
Inputs
Input |
Detail |
Table |
Enter the table to retrieve the definition of |
Outputs
Output |
Output Type |
Table Metadata |
File |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid inputs were given |
3 |
Error |
Failed to run the command |
Insert Records
Executes an INSERT
statement. The source of the data can either be multi-lined text or a CSV file.
Inputs
Input |
Detail |
Table |
Enter the table to insert records into |
CSV Data Source |
Enter the CSV file to insert into the table. The columns in the CSV file must match the same order specified in the Columns input. |
Delimiter |
Select the delimiter used in the CSV Data Source input |
Is a File |
If the CSV Data Source input is a file, check this box |
Includes Headers |
If the first row of the CSV Data Source input is the headers, check this box |
Columns |
Enter the list of columns that the CSV Data Source input will populate. Order is important, and should match the CSV data source. |
Value Template |
Enter the custom values declaration for the INSERT command. Indicate values with a ? . The number of ? s should match the number of fields in the target. To auto-generate, leave blank. |
Outputs
Output |
Output Type |
Records Inserted |
Integer |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid inputs |
3 |
Error |
Failed to run the command |