Universal Data Access Components Editions
Universal Data Access Components comes in three editions: Express, Standard, and Professional.
The Express edition is free. It includes the UniDAC common engine, but does not include any data providers and additional components. UniDAC Express Edition supports only the following data providers: Oracle, SQL Server, MySQL, InterBase (Firebird), PostgreSQL, and SQLite, which are installed with ODAC, SDAC, MyDAC, IBDAC, PgDAC, and LiteDAC, respectively.
The Standard edition includes the UniDAC common engine and data providers.
The Professional edition shows off the full power of UniDAC, including mobile application development, data encryption, and additional components for working with databases, such as TUniAlerter, TUniDump, TUniMetaData, TCRBatchMove, etc. Professional Edition also includes the Direct mode for Oracle, SQL Server, MySQL, and PostgreSQL, and static library linking – for SQLite. In addition, UniDAC Professional Edition includes the DataSet Manager tool, which is intended to organize datasets in your application.
You can get Source Access to UniDAC Professional Edition by purchasing a special UniDAC Professional Edition with Source Code, which includes the source code of all component classes. The source code of DataSet Manager and Migration Wizard is not distributed. The source code of the Direct mode for Oracle and SQL Server is distributed obfuscated, and for SQLite – as precompiled packages.
The matrix below compares the features of UniDAC editions. The detailed list of all UniDAC features can be found on the features page.
| Features | Express | Standard | Professional |
|---|---|---|---|
Direct Connectivity |
|||
| Oracle |
|
|
|
| SQL Server |
|
|
|
| MySQL |
|
|
|
| PostgreSQL |
|
|
|
| SQLite |
|
|
|
| ASE (SAP Sybase Adaptive Server Enterprise) |
|
|
|
| DBF |
|
|
|
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 |
|
|
|
|
Obtaining metadata about database objects TUniMetaData |
|
|
|
DataBase Activity Monitoring |
|||
|
Monitoring of per-component SQL execution TUniSQLMonitor |
|
|
|
Additional Components |
|||
|
Advanced connection dialog TUniConnectDialog |
|
|
|
|
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 |
|
|
|
Database Providers |
|||
| Access |
|
|
|
| Excel |
|
|
|
| Advantage |
|
|
|
| Amazon Redshift |
|
|
|
| ASE |
|
|
|
| DB2 |
|
|
|
| DBF |
|
|
|
| InterBase/Firebird |
|
|
|
| MongoDB |
|
|
|
| MySQL |
|
|
|
| NexusDB |
|
|
|
| ODBC |
|
|
|
| Oracle |
|
|
|
| PostgreSQL |
|
|
|
| SQL Server |
|
|
|
| SQLite |
|
|
|
Cloud Providers |
|||
| BigCommerce |
|
|
|
| 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 |
|
|
|
Cross IDE Support |
|||
| Lazarus and Free Pascal Support |
|
|
|
| Single License Price | Free | $349.95 | $599.95 |
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.