Universal Data Access Components (UniDAC)

by Devart (formerly Core Lab) - Product Type: Component / VCL

A library of nonvisual cross-database data access components for Delphi, Delphi for .NET, and C++Builder. Universal Data Access Components (UniDAC) provides unified access to popular database servers like Oracle, Microsoft SQL Server, MySQL, InterBase and Firebird. UniDAC offers unified approach to the database-related applications development process. That means you can switch easily between different databases in your projects without going deep into their specifics. Using UniDAC with its server-independent interface lets you easily create cross-database applications. UniDAC gives outstanding flexibility and independence to your projects.

Our regular prices are shown below. Please logon to see your discounted prices.

Universal Data Access Components (UniDAC) V1.0 Standard

Add to Cart	$ 97.95	1 Developer License - Standard Edition - with Subscription	Download (14.3 MB)
Add to Cart	$ 244.95	4 Developer Team License - Standard Edition - with Subscription	Download (14.3 MB)
Add to Cart	$ 440.95	1 Site Wide License (Allows Unlimited Developers at a Single Company) - Standard Edition - with Subscription	Download (14.3 MB)

Universal Data Access Components (UniDAC) V1.0 Professional

Add to Cart	$ 244.95	1 Developer License - Professional Edition - with Subscription	Download (27.3 MB)
Add to Cart	$ 587.95	4 Developer Team License - Professional Edition - with Subscription	Download (27.3 MB)
Add to Cart	$ 1,077.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Professional Edition - with Subscription	Download (27.3 MB)

Universal Data Access Components (UniDAC) V1.0 Professional with Source code

Add to Cart	$ 391.95	1 Developer License - Professional Edition with Source code - with Subscription	Download (30.4 MB)
Add to Cart	$ 930.95	4 Developer Team License - Professional Edition with Source code - with Subscription	Download (30.4 MB)
Add to Cart	$ 1,714.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Professional Edition with Source code - with Subscription	Download (30.4 MB)

Universal Data Access Components (UniDAC) Standard Subscription Renewal

Add to Cart	$ 48.95	1 Developer License - Standard Edition - Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 117.55	4 Developer Team License - Standard Edition - Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 215.55	1 Site Wide License (Allows Unlimited Developers at a Single Company) - Standard Edition - Subscription Renewal	Verify	Download (29 KB)

Universal Data Access Components (UniDAC) Professional Subscription Renewal

Add to Cart	$ 117.55	1 Developer License - Professional Edition - Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 274.35	4 Developer Team License - Professional Edition - Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 529.15	1 Site Wide License (Allows Unlimited Developers at a Single Company) - Professional Edition - Subscription Renewal	Verify	Download (29 KB)

Universal Data Access Components (UniDAC) Professional with Source code Subscription Renewal

Add to Cart	$ 195.95	1 Developer License - Professional Edition with Source code - Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 470.35	4 Developer Team License - Professional Edition with Source code - Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 862.35	1 Site Wide License (Allows Unlimited Developers at a Single Company) - Professional Edition with Source code - Subscription Renewal	Verify	Download (29 KB)

Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase. All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed above including volume licensing and previous versions.

Our regular prices are shown above. Please logon to see your discounted prices.

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 ]

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 ]

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

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

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 ]

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

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