Description
This plugin integrates with SAP ASE, originally known as Sybase SQL Server, which is a relational database server. The plugin uses the Interactive SQL parser (isql) utility to integrate with Sybase and execute SQL commands.
- Overview
- Documentation
- Version history
Quick Info
Product
DevOps Deploy (HCL Launch)
Type
plugin
Compatibility
HCL Launch version 7.0.x or later
Created by
HCLSoftware
Website
Published Date
Last Updated
Summary
Steps
Summary
The Sybase plugin provides steps to integrate with a Sybase Adaptive Server Enterprise relational database server.
This plugin includes one or more steps, click Steps for step details and properties.
Compatibility
This plugin requires HCL Launch version 7.0.x or later.
This plugin runs on all operating systems that HCL Launch supports.
Installation
See Installing plugins in HCL Launch for installing and removing plugins.
Steps
The following process steps are available in the Sybase plugin.
Run SQL Scripts
Execute one or more SQL scripts on the server.
| Name | Type | Description | Required |
|---|---|---|---|
| Additional Arguments | String | Specify any additional arguments to append to the isql utility. Separate each argument by a new line. | No |
| Database | String | The name of the database in which the Isql session begins. | Yes |
| Error Notification | Enumeration:
|
Select the action to take when a SQL file returns an error. Valid values are: Fail, Warn, and FailAfter. The default value is Fail On Error which fails the process immediately. Warn On Error only warns that an error occured. Fail After Errors executes all SQL scripts and fail afterwards if any errors occurr. | No |
| ISQL Path | String | The path to the isql command executable. | Yes |
| Password | Password | The case-sensitive password to authenticate with Sybase. | Yes |
| SQL Files | String | Specify either a list of SQL files separated by newlines, or a control file containing files listed in the same format. Note that any file without a .sql extension is treated as a control file. | Yes |
| SYBASE.sh Path | String | The path to your SYBASE profile which is the SYBASE.sh file. If specified, this file will be sourced before executing SQL scripts. This is not necessary if you source the file in your agent startup profile. For example: /opt/sybase/SYBASE.sh. | No |
| Server Name | String | The name of the Adaptive Server in which to connect. If nothing is specified, the default SYBASE server name is used. | No |
| Username | String | The case-sensitive username to authenticate with Sybase. | Yes |