Developer Reference : Getting Started : Programmer's Guide : Overview of Zen Access Methods
 
Overview of Zen Access Methods
The following topics introduce and summarize the methods of programming with Zen:
Overview of Zen Access Methods
SQL Access in Zen
Other topics provide details and instructions for developing Microkernel Engine applications, designing databases, using language interfaces, accessing and managing data, and working with client-server environments.
Overview of Zen Access Methods
The following table lists the Zen access methods and APIs.
Access Method
Description
Used For
Btrieve (MicroKernel Engine)
Original Btrieve API
Creating Btrieve database applications
ADO (Microsoft IDEs)
High-level visual or code-based programming
Visual programming of transactional or relational (SQL) applications. This is the recommended programming interface for Microsoft development environments.
PDAC (Embarcadero IDEs)
Zen Direct Access Components for Delphi and C++ Builder
Replaces functionality of Embarcadero data-aware components and eliminates need for Embarcadero Database Engine.
ODBC (relational)
Microsoft’s Open Database Connectivity
Creating SQL-based applications
Java Class Library
Java Class Library for MicroKernel Engine data access.
Creating Java-based applications that connect to the MicroKernel Engine
JDBC
Implementation of Oracle Java database connectivity
Creating JDBC-based SQL applications using an industry-standard API.
Distributed Tuning Interface (DTI)
Zen API for monitoring and administration
Performing administrative and utility functions from applications, creating and maintaining Data Dictionary Files from applications
Distributed Tuning Objects (DTO)
Zen object-oriented programming interface for monitoring and administration
Performing administrative and utility functions from applications, creating and maintaining Data Dictionary Files from applications
SQL Access in Zen
ODBC is the data access method for SQL databases. It brings several advantages:
Improved performance
Standards-based API
Central to the operation of the Zen replication product
You do not have to learn the ODBC API to develop Zen applications. Additional interfaces, such as OLE DB or JDBC, can simplify development.