DB
DB Adapter
The DB Adapter helps you access other database systems using T-SQL commands and REST requests.
Want to try it in Azure?
Click here to learn more or
click here to create a new Enzo Server RTM 3.1 Azure VM now.
Want to try it in AWS?
Click here to learn more or
click here to create a new Enzo Server RTM 3.1 AWS VM now.
Configuration Settings
| Name | Description | Default |
|---|---|---|
| Boolean _isDefault | Make this the default configuration. Defaults to true if configName is already the default. | |
| String connectionString | Connection string to the destination database | |
| Int32 defaultTimeout | Default execution timeout for SQL commands | 30 |
Handlers
| ExecuteSQL |
Executes a SQL command that returns data
details
Arguments
SQL Callexec DB.ExecuteSQL 'SELECT * FROM table1' Http Call/bsc/db/executesql Output ColumnsThis call does not return data. |
||||||||||||||||||
| GetTable |
Executes a SELECT command on a table as specified by the table parameter
details
Arguments
SQL CallSELECT * FROM DB.table@myTable1 WHERE ID=1 Http Call/bsc/db/gettable Output ColumnsThis call does not return data. |