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.

The Standard edition includes the UniDAC common engine and data providers.

The Professional edition shows off the full power of UniDAC, including UniDAC Standard Edition with support for the following data access providers: Oracle, SQL Server, MySQL, InterBase/Firebird/Yaffil, PostgreSQL, SQLite, NexusDB, Access, Advantage, SAP Sybase ASE, DB2, DBF, and other databases (using ODBC provider). 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 the UniDAC Professional Edition by purchasing the special UniDAC Professional Edition with source code. The Professional Edition with source code includes the source code for all component classes. The source code of DataSet Manager is not distributed. The source code of Oracle, SQL Server Direct Mode is distributed obfuscated, and SQLite Direct Mode - as precompiled packages.

The matrix below compares features of UniDAC editions. The detailed list of all UniDAC features can be found at the UniDAC Features page.

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 metainformation 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
Advanced DBGrid with extended functionality
TCRDBGrid
Yes Yes Yes
Records transferring between datasets
TCRBatchMove
Click to view restrictions No Yes

Database Providers

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

Cloud Providers

UniDAC cloud providers for:
BigCommerce
Dynamics CRM
FreshBooks
Magento
MailChimp
NetSuite
QuickBooks
Salesforce
SaleforceMC
SugarCRM
Zoho CRM
No Yes Yes

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 Using these components is possible only if they are included to the used data provider.

2 Available only in editions with source code.

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