Universal Data Access Components
A library of components for Delphi developers that provides direct access to multiple databases from Delphi and C++Builder including Community Edition, as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms.
Features
Standard
Professional
Direct Connectivity
Oracle
ⅴ
SQL Server
MySQL
PostgreSQL
SQLite
ASE (SAP Sybase Adaptive Server Enterprise)
DBF
DAC
Desktop Application Development
Windows
macOS
Linux
Mobile Application Development
iOS
Android
Data Access Components
Base components
TUniConnection
TUniQuery
TUniSQL
TUniTable
TUniStoredProc
TUniUpdateSQL
TUniDataSource
Script Executing
TUniScript
Transactions managing
TUniTransaction
Fast data loading into the server
TUniLoader
DataBase Specific Components
Messaging between sessions and applications
TUniAlerter
Storing a database as a script
TUniDump
Click to view restrictions
Obtaining metadata about database objects
TUniMetaData
DataBase Activity Monitoring
Monitoring of per-component SQL execution
TUniSQLMonitor
Additional Components
Advanced connection dialog
TUniConnectDialog
Yes
Data encryption and decryption
TUniEncryptor
Data storing in memory table
TVirtualTable
Dataset that wraps arbitrary non-tabular data
TVirtualDataSet
SQL queries against TDataSet descendants
TVirtualQuery
Advanced DBGrid with extended functionality
TCRDBGrid
Records transferring between datasets
TCRBatchMove
Providers
Database Providers
Access
Advantage
Amazon Redshift
ASE
DB2
InterBase/Firebird
MongoDB
NexusDB
ODBC
Cloud Providers
BigCommerce
ⅴ3
Dynamics 365
FreshBooks
Google BigQuery
HubSpot
Magento
Mailchimp
NetSuite
QuickBooks
Salesforce
Salesforce MC
SugarCRM
Zoho CRM
Design-Time Features
Enhanced component and property editors
Migration Wizard
DataSet Manager
1 Available only if included in the data provider edition.
2 Available only in editions with source code.
3 The required ODBC driver is sold and distributed separately from UniDAC.
