Universal Data Access Components (UniDAC)

What's new in UniDAC V4.0?

• Embarcadero RAD Studio XE2 now supported
• Application development for 64-bit Windows now supported
• FireMonkey application development platform now supported
• Support for master/detail relationship for TVirtualTable added
• OnProgress event in TVirtualTable added
• TDADataSetOptions.SetEmptyStrToNull property that allows inserting NULL value instead of empty string added
• Bug with processing transaction when connection is lost is fixed

What's new in UniDAC V3.70?

• Lazarus 0.9.30 and FPC 2.4.2 supported
• New DBF provider has been added
• Bug in bookmark validity check has been fixed

What's new in UniDAC V3.60?

• Added NexusDB provider
• Added support for ASCII databases in the SQLite provider (the ASCIIDataBase specific option)
• Changed Collation and Encryption function in the SQLite provider (this function has been moved to the TLiteUtils class in the SQLiteUniProvider unit)
• Improved PostgreSQL provider's performance
• Improved Encryption in the SQLite provider
• Fixed memory leak in the SQLite provider
• Fixed bug with Currency parameter type in ODBC
• Fixed bug in TUniDump in the InterBase provider
• Fixed bug processing Unicode in BLOB parameters in the InterBase provider
• Fixed bug processing parameters of stored procedures in the InterBase provider

What's new in UniDAC V3.50?

• Embarcadero RAD Studio XE supported
• Fixed bug with AL32UTF8 and ZHS16GBK encoding for Oracle in OCI and Direct modes. Now field size and strings storing in these encodings is correct.
• Fixed bug with filling default expression for fields in the design mode for inactive dataset
• Fixed bug with the LIKE keyword in the TDataSet.Filter property

What's new in UniDAC V3.0?

• Embarcadero RAD Studio 2010 now suppored
• DB2, Microsoft Access, Advantage Database Server, Adaptive Server Enterprise, and other databases (using ODBC provider) support added
• Now the subdetail is refreshed before the AfterRefresh event of the detail is called
• ConnectionTimeout is now used when resolving the host name

What's new in UniDAC V2.7?

• SQLite support added
• Added the Disconnected property to TCustomDADataSet
• Added distinction between empty string and null value when saving/loading string fields in TVirtualTable
• Fixed bug with the GotoCurrent method
• Fixed bug with LocalMasterDetail and Prepare method
• Fixed bug with FullRefresh and macros
• Fixed bug with PSInTransaction returning True when no transaction is explicitly started (InterBase provider)
• Fixed bug with TUniStoredProc not alowing data editing for the SQL Server provider
• Fixed bug with Unified SQL and stored procedure call for the SQL Server provider
• Added the UseParamTypes specific option for the PostgreSQL provider
• Fixed bug with not closing portal for prepared statements in the PostgreSQL provider
• Added support for TQuery.DataSource property in BDE Migration Wizard

What's new in UniDAC V2.5?

Unified SQL support - Unified SQL allows to write truly database-independent SQL code. Unified SQL includes:

• Macros - in Unified SQL macros can evaluate to a different value depending on the provider used by the TUniConnection component.
• If - for the purpose of extra flexibility Unified SQL supports conditional inclusion of SQL code into resulting statements. This allows to set different SQL for different DBMS.
• Functions - standard for calling common SQL functions. In run time function is transformed either to the corresponding native function, or to an equivalent expression.
• Literal - provides universal syntax for date, time, and timestamp literals.

TUniLoader component - serves for fast loading of data to the database. For each type of database server TUniLoader uses its specific interfaces for loading with maximum speed. For example, Oracle Direct Path Load interface is used for Oracle.

TUniDump component - serves to store data from tables or editable views as a script and to restore data from a received script.

TUniConnection.AssignConnect method - shares physical connection between several TUniConnection components

What's new in UniDAC V2.0?

• PostgreSQL support added

What's new in UniDAC V1.2?

• Delphi 2009 and C++Builder 2009 supported
• Extended Unicode support for Delphi 2007 added
• Free Pascal 2.2 supported
• Powerful design-time editors implemented in Lazarus
• Completed with more comprehensive structured Help

Universal Data Access Components (UniDAC) General usability

• Direct access to server data. Does not require installation of other data provider layers (such as BDE and ODBC)
• Access without using client library [ Oracle, MySQL ]
• 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 ]

Universal Data Access Components (UniDAC) 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 ]
• Connection timeout management [ Oracle, SQL Server, MySQL ]

Universal Data Access Components (UniDAC) 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
• 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

Universal Data Access Components (UniDAC) 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

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

Universal Data Access Components (UniDAC) 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

Universal Data Access Components (UniDAC) 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

Universal Data Access Components (UniDAC) 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

Universal Data Access Components (UniDAC) 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 ]

Universal Data Access Components (UniDAC) 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

Universal Data Access Components (UniDAC) 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

Universal Data Access Components (UniDAC)  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

Universal Data Access Components (UniDAC) Visual extensions

• Includes the source code of enhanced TCRDBGrid data-aware grid control
• Customizable connection dialog

Universal Data Access Components (UniDAC) 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
• Printable documentation in PDF format
• A large amount of helpful demo projects

UniDAC Standard Edition includes the UniDAC common engine, but does not include server-specific data providers. Required providers can be installed with ODAC, SDAC, MyDAC, IBDAC. UniDAC Standard Edition is a cost-effective solution for those database application developers who need only several of supported data providers, or already have some of DACs.

UniDAC Professional Edition includs all UniDAC Standard Edition features with support for four data access providers: Oracle, SQL Server, MySQL, InterBase/Firebird/Yaffil. In addition, UniDAC Professional Edition includes the DataSet Manager tool which is intended to organize datasets in your application.