Additional
Overview
Features >>
History
Download
Forum
Tickets
Polls
Which driver do you use or will use most of time ?
 
AnyDAC Features
Direct access to multiple DBMS’s
AnyDAC is a cross DBMS data access engine (DAC) supporting many DBMS’s and offering developers a unified API to all of them.  Due to AnyDAC's open architecture we are constantly extending our set of supported DBMS.
 
High performance

Applications of all types will benefit from multiple AnyDAC high performance features, including Rowset Fetching, Array DML Command Execution, Command Batches, etc. Also, AnyDAC code is deeply optimized. Our software engineers spend considerable time making AnyDAC one of the fastest data access engines on the market.

 
Quality Assurance

AnyDAC 1.x had enough stable codebase. AnyDAC 2.x has about 70 fixes. That reduces total time of application development with AnyDAC 2.0 and makes it more reliable.

 
Complete control

AnyDAC has above 60 options, controlling almost all aspects of data access functionality: fetching rows, updating rows, resources usage and data types handling. The option values are inheritable from manager (top level component) to connections and datasets.

 

 
Flexible data type handling

AnyDAC supports most data types supported by current DBMS’s, including different kinds of BLOB data, Unicode data, high precision numbers, etc. Also, programmer has complete control on the mapping of row column data types into dataset field types and backwards.

 
Flexible fetching

AnyDAC is very fast and flexible at data rows fetching. 9 parameters control all aspects of row set fetching.

 

 
Flexible data updating
AnyDAC is very flexible and transparent to the programmer at data updates. 12 parameters control all aspects of posting data updates to the DBMS.
 
Array command execution

AnyDAC is faster than most data access components at SQL command execution and offers great features, like command array execution.

 
Asynchronous command execution
Besides the fact that AnyDAC is ready for multy threading environment, it offers "simple to use" features not requiring from a programmer to deal with threading.
 
Command text macro processing

AnyDAC has an extended command macro processor. It provides for dynamical changing of command text before being sent to the DBMS, hide SQL dialect differences and perform conditional expansion of command text.

 
Flexible and fast in-memory data storage engine

AnyDAC has a very powerful in-memory data storage engine. It's design is based on ADO.Net System.Data namespace architecture and outperforms it in many areas, including speed and memory usage.

 
Advanced GUI

AnyDAC comes with a set of predefined dialogs, thereby simplifying application development.

 
Monitoring and Tracing
To monitor the database access activities of your AnyDAC application you can use AnyDAC tracing and monitoring features. Including the ADMonitor utility, which is analogue to BDE SQLMonitor, but out performs it.