Supported target platforms
-
Windows 32-bit and 64-bit
-
macOS 64-bit
-
Mac ARM
-
iOS 64-bit
-
iOS Simulator ARM 64-bit
-
Android 32-bit and 64-bit
-
Linux 32-bit (only in Lazarus and Free Pascal) and 64-bit
General usability
-
Direct access to server data. Does not require installation of other data provider
layers (such as BDE)
-
Access without using client library [ Oracle, SQL Server, MySQL, PostgreSQL, SQLite, DBF ]
-
Interface compatible with standard data access methods, such as BDE and ADO
-
VCL, LCL and FMX versions of library available
-
Separated run-time and GUI specific parts allow you to create pure console applications
such as CGI
-
Unicode support
-
National charset support [ Oracle, MySQL, InterBase, PostgreSQL ]
-
Unified SQL for writing server-independent queries
-
Highly usable design time support
-
Easy to deploy
Network and connectivity
-
Disconnected Mode with automatic connection control for working with data offline
-
Local Failover for detecting connection loss and implicitly reexecuting certain
operations
-
Ability to search for installed servers in a local network [ SQL
Server, MySQL, PostgreSQL ]
-
Connection timeout management [ Oracle, SQL Server, MySQL,
PostgreSQL, ODBC ]
-
Support for OS authentication
-
Support for Proxy Authentication
-
Support for the change expired password
-
Support for both IPv6 and Ipv4 protocol
Compatibility
-
Full support of the latest server versions
-
Support for embedded server versions
-
Compatible with Delphi 6, 7, C++Builder 6, Borland Delphi Studio 2006, Code Gear RAD Studio 2007, 2009, Embarcadero RAD Studio 2010, XE, XE2, XE3, XE4, XE5, XE6, XE7, XE8, Seattle, Berlin, Tokyo, Rio, Sydney, Alexandria
-
Support for Lazarus 2.2.6 and FPC 3.2.2 for Windows, macOS and Linux (32-bit and 64-bit)
-
Wide reporting component support, including support for InfoPower, ReportBuilder,
FastReport
-
Support for all standard and third-party visual data-aware controls
-
Allows you to use Professional Edition of Delphi and C++Builder to develop client/server
applications
Server-specific features
Oracle
-
Multiple Oracle Homes support
-
Oracle sequence support
-
Direct LOB access support
-
Temporary LOB management routines
-
Temporary LOBs for updating LOB fields
-
OCI Connection Pooling, Proxy Session Pooling, and Statement Caching
-
Oracle optimizer control
-
CLIENT_IDENTIFIER support
-
DBMS_ALERT support with the TUniAlerter component
-
Secure connections with SSL, SSH, and HTTP tunneling
-
Oracle package support
-
Oracle 9i scrollable cursor support
-
DML array operations support
-
ProxySession support
-
External Procedure support
-
ROWID values retrieval
-
Overloaded stored procedures support
-
Support for WITH FUNCTION clause
SQL Server
-
Possibility to change application name for a connection
-
Possibility to change workstation identifier for a connection
-
Configuration of OEM/ANSI character translation
-
Enhanced support for SQL Server Compact Edition
-
Enhanced support for User-defined Types of SQL Server
-
Ability to lock records and tables
MySQL
-
HANDLER syntax support
-
Transaction isolation level support
-
Possibility to retrieve last auto-incremented value
-
Session identifer retrieval
-
Server object information retrieval
-
Row-level and table-level locking support
-
Secure connections with SSL, SSH, and HTTP tunneling
InterBase/Firebird
-
Advanced BLOB support
-
Streaming (non-caching) BLOB access support
-
Advanced generator support
-
Advanced support for the character set OCTETS
-
Support for the Firebird 2 EXECUTE BLOCK syntax
-
Support for the Firebird 2 RETURNING clause
-
Advanced locking for Firebird 2
-
Automatic updates by DB_KEY unique field for Firebird 2
-
Multiple transactions support with the TUniTransaction component
-
InterBase events support with the TUniAlerter component
-
Comprehensive array data type support
-
Default value support for stored procedures
-
InterBase services components for configuring server parameters and security
-
Support for the Firebird 3 BOOLEAN datatype
-
Support for the Firebird 2.1 trusted authentication
-
- Support for InterBase OTW encryption
PostgreSQL
-
Advanced sequences support
-
Advanced Large Objects support
-
Ability to control Fetch block size
-
Returning result sets from stored procedures
-
Secure connections with SSL, SSH, and HTTP tunneling
-
Notifications support with the TUniAlerter component
-
Support for PostgreSQL Asynchronous Notification with the TUniAlerter component
-
Supports the possibility of retrieving last inserted OID value
-
Advanced errors support
-
Support for the PostgreSQL notices
SQLite
-
Support for all commonly used data types
-
Support for autoincrement fields
-
Possibility to retrieve last auto-incremented value
-
SQLite database encryption in Direct mode using different encryption algorithms
-
Data Type Mapping
-
Support for automatic database creation on connect
-
Support for Shared-Cache mode
-
Support for SQLite user-defined functions
-
Support for SQLite user-defined collations
-
Support for SQLite extensions loading
-
Support for SQLite R*Tree module
-
Support for SQLite FTS3 and FTS4 extensions
-
Support for multi-SQL statements executing
MongoDB
-
Support for all commonly used data types
-
Support for native MongoDB query and update commands syntax
-
Support for displaying/modifying documents using regular data-aware controls like TDBGrid
-
Support for simply modifying documents in code using "fluent" interface
-
Support for reading/writing documents in the Extended JSON format
-
Support for working with collections via regular SQL using VirtualDAC
DB2
-
Advanced sequences support
-
Schema and function path support
DBF
-
Support for variety of database formats: dBaseIII-dBase10, dBase for Windows, HiPer-Six, FoxPro 2, Visual FoxPro
-
Support for all native data types
-
Support for native dBase functions
-
Support for autoincrement fields
-
Support for .dbt (dBase), .fpt (FoxPro) and .smt (HiPer-Six) MEMOs
-
Support for .mdx (dBaseIV+) and .cdx (Visual FoxPro) indexes
-
Support for table management commands: CREATE/DROP/PACK/ZAP/REINDEX TABLE, ALTER TABLE ADD/DROP/ALTER COLUMN
-
Support for index management commands: CREATE/DROP INDEX
Performance
-
High overall performance
-
Fast controlled fetch of large data blocks
-
Optimized string data storing
-
Advanced connection pooling
-
High performance of applying cached updates with batches
-
Caching of calculated and lookup fields
-
Fast Locate in a sorted DataSet
-
Preparing of user-defined update statements
-
High performance batch processing
-
Intelligent fetch block size control
-
Advanced connection pooling
-
SmartFetch Mode enabling fast bi-directional navigation through large datasets
Local data storage operations
-
Database-independent data storage with TVirtualTable component
-
CachedUpdates operation mode
-
Local sorting and filtering, including by calculated and lookup fields
-
Local master/detail relationship
-
Master/detail relationship in CachedUpdates mode
Data access and data management automation
-
Automatic data updating with TUniQuery, TUniTable, and TUniStoredProc components
-
Automatic record refreshing and locking
-
Automatic query preparing
-
Support for ftWideMemo field type in Delphi 2006 and higher
-
Data Type Mapping
-
Support for Data Encryption in a client application
Extended data access functionality
-
Separate component for executing SQL statements
-
Simplified access to table data with TUniTable component
-
Ability to retrieve metadata information with TUniMetaData component
-
BLOB compression support
-
Support for using macros in SQL
-
FmtBCD fields support
-
Ability to customize update commands by attaching external components to TUniUpdateSQL
objects
-
Deferred detail DataSet refresh in master/detail relationships
-
MIDAS technology support
-
UniDataAdapter component for WinForms and ASP.NET applications
-
Distributed transactions support with the TUniTransaction component [ Oracle, SQL Server ]
-
Default value support for stored procedures
-
RefreshQuick method [ SQL Server, MySQL ]
-
Fast record insertion with TUniLoader component
-
NonBlocking mode allows background executing and fetching data in separate threads
-
LargeInt fields support
-
Object-oriented building of SELECT statements
Data exchange
-
Transferring data between all types of TDataSet descendants with TCRBatchMove
component
-
Data export and import to/from XML (ADO format)
-
Ability to synchronize positions in different DataSets
-
Extended data management with TUniDump component
Script execution
-
Advanced script execution features with the TUniScript component
-
Support for executing individual statements in scripts
-
Support for executing huge scripts stored in files with dynamic loading
-
Ability to use standard clients tool syntax in scripts
SQL execution monitoring
-
Extended SQL tracing capabilities provided by the TUniSQLMonitor component and
dbMonitor
-
Borland SQL Monitor support
-
Ability to send messages to dbMonitor from any point in your program
Visual extensions
-
Includes the source code of enhanced TCRDBGrid data-aware grid control
-
Customizable connection dialog
Design-time enhancements
-
DataSet Manager tool to control DataSet instances in the project
-
Advanced design-time component and property editors
-
Automatic design-time component linking
-
Easy migration from BDE and ADO with Migration Wizard
-
More convenient data source setup with the TUniDataSource component
-
Syntax highlighting in the design-time editors
Resources:
- Code documentation and guides in the CHM, PDF, and HXS formats
- Many helpful demo projects
Licensing and support
-
Included annual UniDAC Subscription with Priority Support
-
Licensed royalty-free per developer, per team, or per site