UniDAC

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.

UniDAC Edition Matrix

Features Express Standard Professional

Direct Connectivity

Oracle Click to view restrictions No Yes
SQL Sever Click to view restrictions No Yes
MySQL Click to view restrictions Yes Yes
PostgreSQL Click to view restrictions Yes Yes
SQLite Click to view restrictions No Yes
ASE (SAP Sybase Adaptive Server Enterprise) No No Yes
DBF No No Yes

Desktop Application Development

Windows Click to view restrictions Yes Yes
macOS Click to view restrictions No Yes
Linux Click to view restrictions No Yes

Mobile Application Development

iOS Click to view restrictions No Yes
Android Click to view restrictions No Yes

Data Access Components

Base Components:
TUniConnection
TUniQuery
TUniSQL
TUniTable
TUniStoredProc
TUniUpdateSQL
TUniDataSource
Yes Yes Yes
Script Executing
TUniScript
Yes Yes Yes
Transactions managing
TUniTransaction
Yes Yes Yes
Fast data loading into the server
TUniLoader
Click to view restrictions No Yes

Database Specific Components

Messaging between sessions and applications
TUniAlerter
Click to view restrictions No Yes
Obtaining metadata about database objects
TUniMetaData
Click to view restrictions No Yes
Storing a database as a script
TUniDump
Yes No Yes

Database Activity Monitoring

Monitoring of per-component SQL execution
TUniSQLMonitor
Yes Yes Yes

Additional Components

Advanced connection dialog
TUniConnectDialog
Yes Yes Yes
Data encryption and decryption
TUniEncryptor
Click to view restrictions No Yes
Data storing in memory table
TVirtualTable
Yes Yes Yes
Dataset that wraps arbitrary non-tabular data
TVirtualDataSet
Yes Yes Yes
SQL queries against TDataSet descendants
TVirtualQuery
No No Yes
Advanced DBGrid with extended functionality
TCRDBGrid
Yes Yes Yes
Records transferring between datasets
TCRBatchMove
Click to view restrictions No Yes

Database Providers

Access No Yes Yes
Advantage No Yes Yes
Amazon Redshift No Yes Yes
ASE No Yes Yes
DB2 No Yes Yes
DBF No Yes Yes
InterBase/Firebird No Yes Yes
MongoDB No Yes Yes
MySQL No Yes Yes
NexusDB No Yes Yes
ODBC No Yes Yes
Oracle No Yes Yes
PostgreSQL No Yes Yes
SQLite No Yes Yes
SQL Server No Yes Yes

Cloud Providers

BigCommerce No Click to view restrictions Click to view restrictions
Dynamics 365 No Click to view restrictions Click to view restrictions
FreshBooks No Click to view restrictions Click to view restrictions
Google BigQuery No Click to view restrictions Click to view restrictions
HubSpot No Click to view restrictions Click to view restrictions
Magento No Click to view restrictions Click to view restrictions
Mailchimp No Click to view restrictions Click to view restrictions
NetSuite No Click to view restrictions Click to view restrictions
QuickBooks No Click to view restrictions Click to view restrictions
Salesforce No Click to view restrictions Click to view restrictions
Saleforce MC No Click to view restrictions Click to view restrictions
Sugar CRM No Click to view restrictions Click to view restrictions
Zoho CRM No Click to view restrictions Click to view restrictions

Design-Time Features

Enhanced component and property editors Yes Yes Yes
Migration Wizard Yes Yes Yes
DataSet Manager No No Yes

Cross IDE Support

Lazarus and Free Pascal Support No No Click to view restrictions

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.

© 1997-2024 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback