Introduction

Enzo Server
  Installation
  Quick Start
  Core Features
    Async Calls
    ConnectionStrings
    Edge Cache
    HTTP Access
    Scheduling
    Views
  Advanced Capabilities
    Change Data Capture
  Administration
    Configuration Settings
    Logins & ACL
    Auditing
    Current Executions
    Linked Server
    SSL

  User Guides
     Sharding
     Sharding Overview

     SharePoint

   Adapters
    All Adapters


  SDK
    Overview
    Installation
    DevHost
    Create A Simple Adapter
    Best Practices
    Developer Guide
      Handler Columns
      Handler Options
      Handler Decorators
      Dynamic Columns
      Table & Table Enumerators
      Virtual Tables



DB Adapter








The DB Adapter helps you access other database systems using T-SQL commands and REST requests.




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

Name Description Default
sql R An SQL command to execute
execTimeout An optional timeout value that overrides the default setting 30
_configName An optional definition other than the default for the current login

SQL Call

exec DB.ExecuteSQL 'SELECT * FROM table1'
SELECT * FROM DB.ExecuteSQL 'SELECT * FROM table1'


Http Call

/bsc/db/executesql

Output Columns

This call does not return data.

GetTable Executes a SELECT command on a table as specified by the table parameter details 

Arguments

Name Description Default
tableName The table name to execute the SELECT command against
_where An optional WHERE clause
_cols An optional list of columns *
_configName An optional definition other than the default for the current login
_execTimeout An optional timeout value that overrides the default setting 30

SQL Call

SELECT * FROM DB.table@myTable1 WHERE ID=1


Http Call

/bsc/db/gettable

Output Columns

This call does not return data.