Virtual Data Access Components (VirtualDAC)Virtual Data Access Components (VirtualDAC)

DevartData Access ToolsVCL Component
Version 15.0.1 (Jun 15, 2026)

SQL querying and in-memory dataset components for Delphi, C++Builder, and Lazarus.

  • Execute SQL queries across multiple datasets and data sources.
  • Create and manage in-memory datasets for application data processing.
  • Combine and transform data using SQL-based virtual datasets.
Devart logo

Prices from:

Loading...
Available individuallyOur Price
Virtual Data Access Components (VirtualDAC)Loading
VirtualDataSet
Virtual Data Access Components (VirtualDAC) enable applications to work with data stored in memory or retrieved from different sources through a unified dataset interface. Developers can perform SQL operations on virtual datasets, combine information from multiple sources, and integrate the results with data-aware controls.

Virtual SQL Query Processing

Allows SQL queries to be executed on datasets derived from TDataSet descendants, enabling joins, filtering, and aggregation across multiple data sources.

In-Memory Table Storage

Provides a virtual table component that stores data entirely in memory, allowing applications to manage temporary or dynamically generated data without relying on external databases.

Virtual Dataset Wrapper

Enables representation of custom or external data collections as TDataSet descendants using event handlers, allowing them to integrate with standard database-aware components.

Aggregate And Grouping Operations

VirtualDAC supports SQL aggregate functions and grouping operations when querying virtual datasets. Applications can calculate totals, averages, counts, and other aggregated values while combining data from multiple datasets within a single SQL query.

Multi-Source Data Querying

Enables combining and querying data from different datasets, including in-memory tables and database datasets, within a single SQL statement.

Design-Time Table Management

Includes design-time editors that allow developers to define fields and populate virtual tables directly within the development environment.

Unicode and Character Set Support

Supports Unicode and international character sets to ensure correct handling of multilingual data.

Local Data Sorting and Filtering

Provides built-in mechanisms for sorting, filtering, and updating data within virtual datasets without requiring database server interaction.

Product Compatibility

Review the details below to ensure this product is supported within your environment.

Component Type

  • VCL Component

IDE Support

  • C++Builder
  • Delphi
  • RAD Studio