Shard Adapter
This adapter allows you to query multiple heterogeneous systems (shard) in parallel using SQL Server and REST commands
This adapter requires advanced configuration settings; contact support for assistance.
Configuration Settings
| Name | Description | Default |
|---|---|---|
| Boolean _isDefault | Make this the default configuration. Defaults to true if configName is already the default. | |
| String type | The type of the data source (data, shard, view) | data |
| String connectionString | The connection string of the data source (or a shard name, or a view name) | |
| String sqlCommand | The default SQL (SELECT) statement to execute for this data source | |
| String options | An optional comma-separated list of options for the data source (strict, breadcrumb,readonly,timeout=nnn) | |
| String tableName | The name of the source (or Enzo) table to use when issuing UPDATE, DELETE, INSERT commands |
Handlers
| ClearContext |
Clears the session data source context for statements to execute
details
ArgumentsSQL Callexec shard.clearcontext Http Call/bsc/shard/clearcontext Output ColumnsThis call does not return data. |
|||||||||
| execshard |
Runs the default command of a data source, or a shard, defined in the adapter configuration
details
Arguments
SQL Callexec shard.execshard 'source' Http Call/bsc/shard/execshard Output ColumnsThis call does not return data. |
|||||||||
| execshardsql |
Runs the SQL command provided against a data source, or a shard, defined in the adapter configuration
details
Arguments
SQL Callexec shard.execshardsql 'source' Http Call/bsc/shard/execshardsql Output ColumnsThis call does not return data. |
|||||||||
| GetContext |
Gets the session data source context currently set for statements to execute
details
ArgumentsSQL Callexec shard.getcontext Http Call/bsc/shard/getcontext Output ColumnsThis call does not return data. |
|||||||||
| SetContext |
Sets the session data source context for statements to execute
details
Arguments
SQL Callexec shard.setcontext 'context1' Http Call/bsc/shard/setcontext Output ColumnsThis call does not return data. |
|||||||||
| SETCONTEXT_ON |
Indicates that the next SQL statement(s) are used to define a context instead of returning rows of data.
details
Arguments
SQL Callexec shard.SETCONTEXT_ON Http Call/bsc/shard/setcontext_on Output ColumnsThis call does not return data. |