The EC-SQLServer plugin interacts with the Microsoft SQL Server command line tool called osql.exe. The osql tool allows the user to perform sql statements against the database. For example, you can execute a single sql file or execute a query from a text area. Moreover the postp feature is available.
More information about Microsoft SQL server can be found at here.
Plugin Version 2.0.12.2020102903 Revised on June 15, 2020
Plugin procedures
| For all parameter descriptions below, required parameters are shown in bold italics. |
Plugin configuration
Plugin configurations are sets of parameters that apply across some or all of the plugin’s procedures. They are intended to reduce repetition of common values, create predefined sets of parameters for end users, and to securely store credentials where needed. Each configuration is given a unique name that is entered in designated parameters on procedures that use them.
Plugin configurations are created by navigating to CloudBees CD . On the right side of the line for the specific plugin, there is a "Configure" link which will open the Configuration page.
Plugin configuration parameters
| Parameter | Description |
|---|---|
Configuration Name | Provide a unique name for the configuration. (Required) |
User Name | Provide the user login ID. Remember that login IDs are case sensitive. |
Password | Provide the user-specified password |
RunSQLFile
The RunSQLFile procedure creates and executes a command line from the parameters you provide in the procedure form, This command line will call the SQL Server’s utility called osql.exe
| Parameter | Description |
|---|---|
Path to osql.exe | Absolute path to the Sql Server utility osql.exe |
Server | The name of the server you want to connect to. (This is the command-line '-S' option) (Required) |
SQL Statement | Provide any sql statement to run against the database. (This is the command-line '-Q' option) |
Database name | Issues a USE db_name statement when osql is started. (This is the command-line '-d' option) |
Path to a sql file | Absolute path to a sql file. (This is the command-line '-i' option) |
Configuration name | The name of the configuration that contains the SQL Server user and password. |
Result (output property path) | Property name used to store the result of queries. |
