Universal Data Access Components (UniDAC) - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

Universal Data Access Components (UniDAC) by Devart (formerly Core Lab)

URLs: universal-data-access-components-unidac, universal data access components unidac, universaldataaccesscomponentsunidac, devart

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. Universal Data Access Components (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 Universal Data Access Components (UniDAC) with its server-independent interface lets you easily create cross-database applications. Universal Data Access Components (UniDAC) gives outstanding flexibility and independence to your projects.

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.

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

A library of nonvisual cross-database data access components for Delphi, Delphi for .NET, and C++Builder.

Pricing: Universal Data Access Components (UniDAC) V4.0 Standard 1 Developer License - Standard Edition - with Subscription, Universal Data Access Components (UniDAC) V4.0 Standard 4 Developer Team License - Standard Edition - with Subscription, Universal Data Access Components (UniDAC) V4.0 Standard 1 Site Wide License (Allows Unlimited Developers at a Single Company) - Standard Edition - with Subscription, Universal Data Access Components (UniDAC) V4.0 Professional 1 Developer License - Professional Edition - with Subscription, Universal Data Access Components (UniDAC) V4.0 Professional 4 Developer Team License - Professional Edition - with Subscription, Universal Data Access Components (UniDAC) V4.0 Professional 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Professional Edition - with Subscription, Universal Data Access Components (UniDAC) V4.0 Professional with Source code 1 Developer License - Professional Edition with Source code - with Subscription, Universal Data Access Components (UniDAC) V4.0 Professional with Source code 4 Developer Team License - Professional Edition with Source code - with Subscription, Universal Data Access Components (UniDAC) V4.0 Professional with Source code 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Professional Edition with Source code - with Subscription, Universal Data Access Components (UniDAC) Standard Subscription Renewal 1 Developer License - Standard Edition - Subscription Renewal, Universal Data Access Components (UniDAC) Standard Subscription Renewal 4 Developer Team License - Standard Edition - Subscription Renewal, Universal Data Access Components (UniDAC) Standard Subscription Renewal 1 Site Wide License (Allows Unlimited Developers at a Single Company) - Standard Edition - Subscription Renewal, Universal Data Access Components (UniDAC) Professional Subscription Renewal 1 Developer License - Professional Edition - Subscription Renewal, Universal Data Access Components (UniDAC) Professional Subscription Renewal 4 Developer Team License - Professional Edition - Subscription Renewal, Universal Data Access Components (UniDAC) Professional Subscription Renewal 1 Site Wide License (Allows Unlimited Developers at a Single Company) - Professional Edition - Subscription Renewal, Universal Data Access Components (UniDAC) Professional with Source code Subscription Renewal 1 Developer License - Professional Edition with Source code - Subscription Renewal, Universal Data Access Components (UniDAC) Professional with Source code Subscription Renewal 4 Developer Team License - Professional Edition with Source code - Subscription Renewal, Universal Data Access Components (UniDAC) Professional with Source code Subscription Renewal 1 Site Wide License (Allows Unlimited Developers at a Single Company) - Professional Edition with Source code - Subscription Renewal

Evals & Downloads: Read the Universal Data Access Components (UniDAC) help file, Read the Universal Data Access Components (UniDAC) License Agreement, Download the Universal Data Access Components (UniDAC) V4.0 evaluation on to your computer - Exipres After 30 Days

Operating System for Deployment: Windows 7, Windows Vista, Windows XP, Windows ME, Windows 2000, Windows 98, Windows NT 4.0, Windows 95, Windows NT 3.51

Architecture of Product: 32Bit, 64Bit

Product Type: Component

Component Type: VCL

Compatible Containers: Embarcadero RAD Studio XE, Embarcadero RAD Studio 2010, CodeGear RAD Studio 2009, C++Builder XE, C++Builder 2010, C++Builder 2009, C++Builder 2007, C++Builder 6, C++Builder 5, Delphi XE, Delphi 2010, Delphi 2009, Delphi 2007 for Win32, Delphi 2006 (10.0), Delphi 2005 (9.0), Delphi 7.0, Delphi 6.0, Delphi 5.0, Kylix 3.0, MySQL 5.0

Product Class: Business Components

Keywords: corelab DAC D A C UNI my sql mydac my dac

crlab corelab

Database DB Connectivity

SQL query language

Part numbers: PC-518408-403491 518408-403491 PC-518408-403495 518408-403495 PC-518408-403497 518408-403497 PC-518408-403493 518408-403493 PC-518408-403499 518408-403499 PC-518408-403501 518408-403501 PC-518408-403503 518408-403503 PC-518408-403505 518408-403505 PC-518408-403507 518408-403507 PC-518408-403509 518408-403509 PC-518408-403511 518408-403511 PC-518408-403513 518408-403513 PC-518408-403515 518408-403515 PC-518408-403517 518408-403517 PC-518408-403519 518408-403519 PC-518408-403521 518408-403521 PC-518408-403523 518408-403523 PC-518408-403525 518408-403525