Configurations
Name | Description | Sample |
---|---|---|
database_server | JDBC connection that specifies the database location. | |
database_port | ||
integrated_security | Integrated Security will leverage Windows Authentication and ignore any username entered | |
trust_server_cert_ssl_require | Trust Server Certificate flag | |
database_username | The username of the user that this handler will use to connect to the database. | |
database_password | The password of the user that this handler will use to connect to the database. | ********* |
kinetic_api_location | API Location (https://acme.kinops.io/app/api/v1). | |
kinetic_api_username | The username for impersonated user. | |
kinetic_api_password | The impersonated user's password. | ********* |
kapp_slug | The kapp slug where the form that holds the query templates is located. | |
kapp_form_slug | The form slug for the form where query templates are saved. | |
enable_debug_logging | Enable debug logging if the value is set to 'Yes'. | No |
Parameters
Name | Description | Sample |
---|---|---|
Error Handling | Determine what to return if an error is encountered. | |
Database | Database to Access for example sqlserver, oracle or postgresql. | |
Database Name | Database Name | |
SQL Action | SQL Action Type. Use fetch for a SELECT statement or run for an UPDATE query. | |
Template Name | A query to search the Kinetic Form to find the saved procedure. | |
Query Values | A JSON object used to do variable binding with the saved procedure. |
Results
Name | Description |
---|---|
Result | |
Handler Error Message |
Download
GitHub
On This Page
Other Versions
Looking for a workflow engine?
Learn more about the Kinetic Data Enterprise Workflow Platform.
Check it out
Return to Top