Universal Data Access Components Features

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, MySQL, PostgreSQL ]
• Interface compatible with standard data access methods, such as BDE and ADO
• VCL and VCL for .NET versions of library available
• Separated run-time and GUI specific parts allow you to create pure console applications
• Unicode support
• National charset support [ Oracle, MySQL, InterBase, PostgreSQL ]
• Unified SQL for writing server-independent queries

Network and connectivity

• Disconnected Model 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  ]

Compatibility

• Full support of the latest server versions
• Support for embedded server versions
• Compatible with all IDE versions starting with Delphi 6 and C++Builder 6, except Delphi 8, and with Free Pascal
• 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 and Statement Caching
  • Oracle optimizer control
  • CLIENT_IDENTIFIER support
  • DBMS_ALERT support with the TUniAlerter component [ New ]
• 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
• MySQL
  • HANDLER syntax support
  • Possibility to retrieve last auto-incremented value
• 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 [ New ]
• PostgreSQL
  • Advanced sequences support
  • Advanced Large Objects support
  • Ability to control Fetch block size
  • Returning result sets from stored procedures
  • SSL support
  • Notifications support with the TUniAlerter component [ New ]
• SQLite [New]
  • Support for all commonly used data types
  • Possibility to retrieve last auto-incremented value
• DB2 [New]
  • Advanced sequences support
  • Schema and function path support

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

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

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

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

Product clarity

• Complete documentation sets
• A large amount of helpful demo projects

Licensing and support

• Included annual UniDAC Subscription with Priority Support
• Licensed royalty-free per developer, per team, or per site