Virtual Data Access Components

Virtual Data Access Components (VirtualDAC, formerly known as VirtualTable), is a library of components that extends data processing capabilities in Delphi and C++Builder including Community Edition on Windows, Linux, macOS, iOS and Android for both 32-bit and 64-bit platforms. VirtualDAC consists of components that allow creating in-memory data storage and executing complex SQL queries to in-memory tables when developing Delphi applications.

VirtualQuery

The TVirtualQuery component is used to retrieve data with SQL queries from sources that are any TDataSet descendants. Due to this, you can build complex SQL queries to Delphi in-memory data (data sources are TVirtualTable, TVirtualDataSet or another TVirtualQuery) or to data stored in different RDBMS'es (data sources can be TUniQuery, TOraQuery, TMSQuery, TMyQuery, etc. at the same time).

VirtualTable

The TVirtualTable component represents an in-memory data storage that does not have linked data files. TVirtualTable allows to load data from an XML file or an existing dataset, and then wraps the data in the usual way, as in any TDataSet descendant.

VirtualDataSet

The TVirtualDataSet component is data wrapper that doesn't store data in memory and interacts with data using event handlers. It allows to represent arbitrary data (arrays, lists, objects, etc.) as TDataSet descendants and link it with any DB-aware components to display data or modify it.



Cross-Platform Solution for Delphi and C++Builder

VirtualDAC is a cross-platform solution for developing applications using various IDEs: RAD Studio, Delphi and C++Builder on Windows, macOS, iOS, Android, for both 32-bit and 64-bit platforms. VirtualDAC also provides support for the FireMonkey platform, which allows you to develop visually spectacular high-performance desktop and mobile native applications.

Cross-platform and cross-IDE solution

Advanced Design-Time Editors

We offer various design-time editors that provide convenient interface and rich facilities for both creating TVirtualTable fields and filling them with data in design-time that can be saved in dfm or a file afterwards.

VirtualDAC Productivity
Key Features

Development for iOS and Android mobile devices using VirtualDAC becomes still easier, as VirtualDAC allows your mobile applications to work with multiple databases as simply as desktop applications do.

Our product is compatible with the latest IDE versions and editions including Community Edition: Embarcadero RAD Studio 12 Athens, Delphi 12 Athens, C++ Builder 12 Athens, Lazarus (and FPC). It is also compatible with the previous IDE versions since Delphi 6 and C++Builder 6.

All major GUI frameworks supported: develop VCL applications for Windows or cross-platform FMX applications in Delphi, as well as LCL applications for Windows, macoS, or Linux in Lazarus.


All our components and libraries are designed to help you write high-performance, lightweight data access layers, therefore they use advanced data access algorithms and techniques of optimization.

Visit our Support page to get instant help from knowledgeable and experienced professionals, a quick resolution of your problems, and nightly builds with hotfixes.

Discover Other Connectivity Solutions

ADO.NET - ODBC - SSIS - Excel Add-ins - Delphi - OData


Absolutely free Express edition that consists of TVirtualTable and TVirtualDataSet components

Licensed royalty-free per developer, per team, or per site

Includes annual VirtualDAC Subscription with Priority Support

Get extra benefits with Devart for Enterprise

Learn more about our convenient software purchasing process and an array of benefits for enterprise companies.
  • Bonuses for corporate clients

    These may include fast and effective deployment, corporate budget optimization, and a number of special deals.
  • Dedicated manager

    We will save your time by providing a dedicated manager to consult you and guide you through all the purchasing and licensing processes.