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

  Adapters
    Azure Bus
    Azure IoT Hub
    Azure Key Vault
    Azure Storage
    Couchbase
    CSV
    DB (RDBMS)
    Files
    Flight Aware
    FTP
    Geonames
    Insteon
    Loggly
    Messaging (SMS/SMTP)
    MongoDB
    Motus
    MSAD
    MSMQ
    Pipeline
    Pressero
    RabbitMQ
    SalesForce
    Shard
    SharePoint
    SQL Server
    Threading
    Twilio
    Twitter
    VellemanDMX
    Weather (Underground)
    Whiparound
    WMI
    Xls (Excel)
    ZIP


  SDK
    Overview
    Installation
    DevHost
    Create A Simple Adapter
    Handler Columns

    Advanced SDK Concepts
      Handler Decorators
      Dynamic Columns
      Table & Table Enumerators
      Virtual Tables

/adapters/db




DB (RDBMS)


This adapter allows you to access any relational database for which a Connection String has been defined, and an appropriate ODBC driver has been installed on the Enzo Server. Possible relational databases include SQL Server, Oracle, MySQL and many more.

This adapter is particularly useful to execute SQL commands against non-SQL Server database within SQL Server directly, or to access a relational database from HTTP clients directly.


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.