Enzo Server
  Quick Start
  Core Features
    Async Calls
    Edge Cache
    HTTP Access
  Advanced Capabilities
    Change Data Capture
    Configuration Settings
    Logins & ACL
    Current Executions
    Linked Server

  User Guides
     Sharding Overview


    All Adapters

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



The DevHost is an application that hosts the Enzo Server DLLs so that a local version of Enzo runs when the DevHost runs. The DevHost starts automatically when you debug your adapter from Visual Studio; as a result you do not need to install Enzo Server on your development machine since the DevHost runs it for you.

Although not required, you can install Enzo Server and the SDK on the same machine. Enzo Server listens on ports 9550 (sql), 19550 (http) and 49550 (https) by default, while the version of Enzo hosted by the DevHost listens on ports 9551 (sql) and 19551 (http).

Running SQL Commands

Once the DevHost has started, you can execute SQL commands from within the DevHost directly.

Since the DevHost runs Enzo on port 9551 you can also execute SQL commands from SQL Server Management Studio by connecting to (local),9551.

HINT: The Query window loads the content of the .sql file located in your project file. Saving changes from the DevHost will update the project file automatically. This allows you to build your test cases progressively using SQL commands.

To start the DevHost, you first need to create a project in Visual Studio (see the First Adapter section), and press F5 to debug your adapter. The project automatically starts the DevHost for you.

To run a SQL command from the DevHost, type a SQL command in the Query window, select the SQL command you typed and press the Execute icon (or press F5).

Load Multiple Adapters

By default the DevHost loads a single adapter: the one you are currently building. However you can load additional adapters by using File->Load Adapter from the DevHost menu, or by updating the adapters.txt file from your project.

  • Adapters.txt
    Your adapter project contains a Adapters.txt file as part of the project. Each line contains the name and location of the adapter you want to load. For example, this loads the MyAdapter.dll adapter created within the MYCORP namespace.


    This loads the Twitter adapter from Blue Syntax (BSC):


    Note that depending on the location of your solution, the path to the adapter is optional. The DevHost will attempt to locate the DLL in a sibling folder. So if your adapter is found in the D:\Projects\EnzoUnified\Adapters\BSC\ folder, and you want to load the Twitter adapter from the same BSC parent folder, the following declaration will be sufficient:


  • DevHost
    Load a new adapter dynamically from the DevHost by selecting File->Load Data Adapter. Find the main adapter DLL file you want to load and press OK.

Datarack Help System

The DevHost offers multiple capabilities, including the ability to view the loaded adapters' built-in help system: Datarack. As part of the responsibility to build an adapter, you should view what Datarack displays for your adapter to ensure its built-in documentation is accurate and useful.

To view your adapter's built-in help system, select the Datarack tab and select your adapter.

You should review the information provided by Datarack to make sure your adapter is well documented.