Introduction

Enzo Server
  Installation
  Quick Start

  Core Features
    Async Calls
    ConnectionStrings
    Edge Cache
    Scheduling
    Views

  Advanced Capabilities
    Change Data Capture

  Administration
    Configuration Settings
    Logins & ACL
    Auditing
    Current Executions
    Linked Server
    SSL

/features/connectionstrings




CONNECTION STRINGS


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.

DRIVER={MySQL ODBC 5.3 UNICODE Driver};Server=YOUR_SERVER; Database=YOUR_DATABASE; User=YOUR_UID;Password=YOUR_PWD;Option=3;