ODBC Driver for Zoho CRM enables ODBC-compliant applications to query and modify Zoho CRM data using standard SQL. The driver supports direct HTTPS connections, HTTP proxy connections, Unicode data, and bulk operations.
The driver executes SQL-92 queries against Zoho CRM data. Supported constructs include:
The driver supports DML (INSERT, UPDATE, DELETE) operations to modify Zoho CRM data.
Multiple SQL statements can be combined into batches for efficient bulk modifications to Zoho CRM data.
The driver supports the standard ODBC interface, including:
The driver also supports advanced connection string parameters, enabling desktop and web applications to connect to Zoho CRM from various environments and platforms that support ODBC.
The driver fully supports all data types defined in the Zoho CRM API and is compatible with the Zoho CRM API itself.
The driver provides bidirectional mapping between Zoho CRM and ODBC data types.
The driver connects to Zoho CRM directly via HTTPS. HTTP proxy connections are supported for environments with restricted internet access.
The driver supports any character set, including Latin, Cyrillic, Hebrew, and Chinese, with automatic character encoding and no configuration required.
The driver includes local metadata caching, connection pooling, and query optimization to improve performance.
The driver runs on both 32-bit and 64-bit Windows systems (x32 and x64 architectures) with no additional configuration needed.
The driver is compatible with ODBC-aware applications, including Microsoft Excel and Visual Studio, and integrates with various tools and systems.
For a complete list of compatible tools and platforms, see Requirements and compatibility.