|
Editions |
|
|
|
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 features of UniDAC editions. See Features for the detailed list of UniDAC features.
| Features | Express | Standard | Professional |
|---|---|---|---|
Direct Connectivity |
|||
| Oracle |
|
 |
 |
| SQL Sever |
|
|
|
| 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 |
|
|
|
|
Obtaining metadata about database objects TUniMetaData |
|
|
|
|
Storing a database as a script TUniDump |
|
|
|
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 | |
|
|
| Advantage | |
|
|
| Amazon Redshift | |
|
|
| ASE | |
|
|
| DB2 | |
|
|
| DBF | |
|
|
| Excel | |
|
|
| InterBase/Firebird | |
|
|
| MongoDB | |
|
|
| MySQL | |
|
|
| NexusDB | |
|
|
| ODBC | |
|
|
| Oracle | |
|
|
| PostgreSQL | |
|
|
| SQLite | |
|
|
| SQL Server | |
|
|
Cloud Providers |
|||
| BigCommerce | |
|
|
| Dynamics 365 | |
|
|
| FreshBooks | |
|
|
| Google BigQuery | |
|
|
| HubSpot | |
|
|
| Magento | |
|
|
| Mailchimp | |
|
|
| NetSuite | |
|
|
| QuickBooks | |
|
|
| Salesforce | |
|
|
| Saleforce MC | |
|
|
| Sugar CRM | |
|
|
| Zoho CRM | |
|
|
Design-Time Features |
|||
| Enhanced component and property editors | |
|
|
| Migration Wizard | |
|
|
| DataSet Manager | |
|
|
Cross IDE Support |
|||
| Lazarus and Free Pascal Support | |
|
|
1 Available only if included in the data provider edition.
2 Available only in Professional Edition with Source Code.
3 The required ODBC driver is sold and distributed separately from UniDAC.