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
    ActiveCampaign
    Azure Bus
    Azure IoT Hub
    Azure Key Vault
    Azure Storage
    Bing Search
    ConstantContact
    Couchbase
    CSV
    DB (RDBMS)
    Dropbox
    Files
    Flight Aware
    FreshBooks
    FTP
    Geonames
    GoogleDrive
    GoogleSearch
    GoogleSheet
    GreenMile
    GpsInsight
    HttpEndpoint (REST)
    Intacct
    Insteon
    Loggly
    MailChimp
    Messaging (SMS/SMTP)
    MongoDB
    Motus
    MSAD
    MSMQ
    OneDrive
    OneDrive365 (Business)
    Pipeline
    Pressero
    RabbitMQ
    SalesForce
    Shard
    SharePoint
    Slack
    SQL Server
    SQLX
    Sudoku
    Teams
    Threading
    Twilio
    Twitter
    VellemanDMX
    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

/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;