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
¥¥
DAC
Mobile Application Development
iOS
¥¥
Android
¥¥
DAC
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
Click to view restrictions
¥¥
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
¥¥
¥¥
DBF
¥¥
¥¥
InterBase/Firebird
¥¥
¥¥
MongoDB
¥¥
¥¥
MySQL
¥¥
¥¥
NexusDB
¥¥
¥¥
ODBC
¥¥
¥¥
Oracle
¥¥
¥¥
PostgreSQL
¥¥
¥¥
SQL Server
¥¥
¥¥
SQLite
¥¥
¥¥
Cloud Providers
BigCommerce
¥¥3
¥¥3
Dynamics 365
¥¥3
¥¥3
FreshBooks
¥¥3
¥¥3
Google BigQuery
¥¥3
¥¥3
HubSpot
¥¥3
¥¥3
Magento
¥¥3
¥¥3
Mailchimp
¥¥3
¥¥3
NetSuite
¥¥3
¥¥3
QuickBooks
¥¥3
¥¥3
Salesforce
¥¥3
¥¥3
Salesforce MC
¥¥3
¥¥3
SugarCRM
¥¥3
¥¥3
Zoho CRM
¥¥3
¥¥3
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.