Universal Data Access Components (UniDAC) - Summary

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

Summary

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

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.

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

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

Printable documentation in PDF format

A large amount of helpful demo projects

PartNumbers: PC-518408-159237 518408-159237 PC-518408-159241 518408-159241 PC-518408-159242 518408-159242 PC-518408-159238 518408-159238 PC-518408-159243 518408-159243 PC-518408-159244 518408-159244 PC-518408-159245 518408-159245 PC-518408-159246 518408-159246 PC-518408-159247 518408-159247 PC-518408-159254 518408-159254 PC-518408-159255 518408-159255 PC-518408-159256 518408-159256 PC-518408-159257 518408-159257 PC-518408-159258 518408-159258 PC-518408-159259 518408-159259 PC-518408-159260 518408-159260 PC-518408-159261 518408-159261 PC-518408-159262 518408-159262

PurchaseOptions: Universal Data Access Components (UniDAC) V1.0 Standard 1 Developer License - Standard Edition - with Subscription , Universal Data Access Components (UniDAC) V1.0 Standard 4 Developer Team License - Standard Edition - with Subscription , Universal Data Access Components (UniDAC) V1.0 Standard 1 Site Wide License (Allows Unlimited Developers at a Single Company) - Standard Edition - with Subscription , Universal Data Access Components (UniDAC) V1.0 Professional 1 Developer License - Professional Edition - with Subscription , Universal Data Access Components (UniDAC) V1.0 Professional 4 Developer Team License - Professional Edition - with Subscription , Universal Data Access Components (UniDAC) V1.0 Professional 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Professional Edition - with Subscription , Universal Data Access Components (UniDAC) V1.0 Professional with Source code 1 Developer License - Professional Edition with Source code - with Subscription , Universal Data Access Components (UniDAC) V1.0 Professional with Source code 4 Developer Team License - Professional Edition with Source code - with Subscription , Universal Data Access Components (UniDAC) V1.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

Resources: Read the Universal Data Access Components (UniDAC) License Agreement, Download the Universal Data Access Components (UniDAC) V1.0 evaluation on to your computer - Expires After 60 Days

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

Architecture of Product: 32Bit

Product Type: Component

Component Type: VCL

Compatible Containers: C++Builder 6, C++Builder 5, 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

Search Items: New Product Aug 05

Keywords: crlab corelab SQL query language Database DB Connectivity Author corelab DAC D A C UNI my sql mydac my dac