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



Enzo Server allows you to store database connection strings centrally in an encrypted data store controlled by Enzo. This allows you to reuse connection strings throughout Enzo Adapters for specific use cases.

To manage connection strings in Enzo Manager, select the Configuration->Manage Connection Strings menu. A connection string can point to virtually any database system, including SQL Server, MySQL, Oracle and virtually any ODBC system. Depending on the database you are trying to configure you may need to install the necessary ODBC driver.

When the connection string points to an Enzo Server, the IsEnzo flag will be set to true. This is referred to as a loopback connection.

Use this screen to create, update and delete connection strings. You can also try to connect to a database from this screen.

Access to connection strings can be limited to specific Enzo logins. If no logins are specified, any Enzo login can use the connection string.

When creating a new connection string you can select a SQL Server connection or a generic ODBC connection string.

For some adapters the default catalog can be an important setting; for SQL Server the default catalog can also be set as a property of the database account. If this connection string is a loopback connection to Enzo, the default database is always assumed to be bsc, and as a result it is optional.

Leaving the Login/Password blank implies that the connection will use whatever Windows Account the Enzo Server service is running under.

The following is a sample connection string for a MySQL database using an ODBC driver.