Bots From Extension: sql_server
MS SQL - Read, Write and Update tables in Microsoft SQL
This extension provides 9 bots.
Bot @ms-sql:append
Bot Position In Pipeline: Sink
Microsoft SQL - add a new record to an existing database table
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| dbname* | Text | Database Name | |
| table* | Text | Database table name |
Bot @ms-sql:create-table
Bot Position In Pipeline: Sink
Microsoft SQL - create tables
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| dbname* | Text | Database Name | |
| table_name* | Text | Database table name |
Bot @ms-sql:delete-table
Bot Position In Pipeline: Source
Microsoft SQL - Delete table from Database
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| dbname* | Text | Database Name | |
| table_name* | Text | Database table name |
Bot @ms-sql:list-dbtables
Bot Position In Pipeline: Source
Microsoft SQL - get database tables
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| dbname | Text | Database Name |
Bot @ms-sql:meta
Bot Position In Pipeline: Source
Microsoft SQL - get database table schema
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| dbname* | Text | Database Name | |
| table* | Text | Database table name |
Bot #ms-sql:read
Bot Position In Pipeline: Sink
Microsoft SQL - query the data from a database table. Expects 'table' and 'dbname' columns from input dataset; Optional 'limit' can also be provided (default 1000)
This bot expects Full CFXQL.
Bot translates the Query to native query of the Data source supported by this extension.
Bot *ms-sql:system-summary
Bot Position In Pipeline: Source
Microsoft SQL - System Summary
This bot expects a Full CFXQL.
Bot applies the Query on the data that is already loaded from previous bot or from a source.
Bot @ms-sql:tables-meta
Bot Position In Pipeline: Source
Microsoft SQL - get database tables capacity information
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| dbname | Text | Database Name |
Bot @ms-sql:update
Bot Position In Pipeline: Sink
Microsoft SQL - update an existing record within a database table
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| dbname* | Text | Database Name | |
| table* | Text | Database table name | |
| replace_record | Text | yes | Specify yes/no to replace/update existing record |
| key_column | Text | Key column to be provided if replace_record is false | |
| update_columns | Text | Specify comma separated columns that has to update, by default all the columns will be updated |