SOLUTIONS PARTNERS BLOGS CONTACT

 Introduction
 Concepts
   Sync Agents
   Jobs Readers & Writers
   Synthetic CDC
 Security
 Connections 
     Overview
     Databases:
      SQL Server
      MySQL
      Oracle
      Teradata
      ODBC
     Drives/FTP:
      Local Path/UNC
      AWS S3 Bucket
      Azure Container/ADLS
      Google Drive
      FTP
     HTTP/S:
      HTTP/S Connection
      Rate Limiting
      OAuth Tokens
     Messaging:
      AWS SQS
      Azure Event Hub
      Azure Service Bus
      Google PubSub
      Kafka
      MSMQ
      RabbitMQ
     Big Data
      Google BigQuery
      Azure CosmosDB
 Jobs
     High Watermark Values
     Dynamic Jobs
     Job Readers 
      Database Reader
      Drive Reader
      HTTP/S Reader
      Messaging Consumer
      Big Data

     Job Writers 
      Create From Reader
      Database Target
      Drive Target
      HTTP/S Target
      Messaging Producer
      Big Data Target

     Triggers
     Data Pipelines
 DataZen Functions
 Resync & Replay
 Sync Agent API

Connection Strings: ODBC

To connect to a database using another ODBC driver, choose Other (ODBC Driver). To use this connection, you must have first installed the desired 64-bit ODBC driver separately.


The connection string is displayed using * to hide secrets. You can toggle the display by clicking on the password button. When doing so, any secret included in the content of the ODBC Connection string will be visible.

Creating a separate DNS connection is preferred, so the actual connection string is not visible on this configuration screen. The screenshot below shows you how to use an existing DNS name created on the local machine.

The list of ODBC drivers provided are those found on the machine where DataZen Manager is installed. If the Sync Agent is running on another server, the Agent using the connection may, or may not, have the same ODBC drivers available. If the selected ODBC driver is not installed on the server where the Sync Agent is installed, the job will fail.

In addition, when using a DNS name as shown above, the same DNS name must also be created on the Sync Agent server, if the agent is running on a separate server.






601 21st St Suite 300
Vero Beach, FL 32960
United States

(561) 921-8669
info@enzounified.com
terms of service
privacy policy

PRODUCTS

ENZO SERVER
ENZO DATAZEN

SOLUTIONS

SOLUTIONS OVERVIEW
LOW-CODE INTEGRATION
SHAREPOINT INTEGRATION
RABBITMQ INTEGRATION
HYBRID SHARDING
READ/WRITE PARQUET FILES
SQL SERVER HYBRID QUERIES

RESOURCES

ENZO AZURE VM
BLOGS & VIDEOS
IN THE NEWS
ENZO ADAPTERS
ONLINE DOCUMENTATION
TCO CALCULATOR

COMPANY

LEADERSHIP TEAM
PARTNERS


© 2023 - Enzo Unified