Oracle Data Access Components (ODAC) - Summary

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

Summary

Oracle Data Access Components (ODAC) by Devart (formerly Core Lab)

URLs: core-lab-oracle-data-access-components, core lab oracle data access components, corelaboracledataaccesscomponents, devart

Provide high performance direct access to Oracle databases. Oracle Data Access Components (ODAC) is set of VCL native components for Kylix, Delphi and C++ Builder. It supports many Oracle specific features and simplifies developing of client/server applications. With Net option ODAC works directly through TCP/IP and doesn't require Oracle's software on client side. ODAC can work in managed environment and provides extended Oracle data types support including XML types, LOB's, objects, nested tables, references, timestamps and intervals.

Oracle Data Access Components (ODAC) library offers some nonvisual components for Borland Delphi, C++ Builder and Kylix. They serve for access to Oracle RDBMS. ODAC is an alternative to standard way processing data by Borland Database Engine (BDE).

ODAC uses Oracle Call Interface (OCI) directly. Also with Net option ODAC allows to connect without Oracle client software installed on workstation. In such cases ODAC requires only TCP/IP protocol and allows you to build really thin database applications.

Key features:

Direct access to Oracle data. No distributing, installing and configuring the BDE and ODBC

Doesn't require Oracle's software on client side with Net option and works directly through TCP/IP

Extended Oracle data types support including XML types, LOB's, objects, nested tables, references, timestamps and intervals

High performance controlled fetch of large data blocks

Optimized string and raw data storing

Easy work with Unicode data

Automatic data updating with TSmartQuery and TOraTable components

Automatic record locking and refreshing

NonBlocking mode allows to run long lasting background queries in separate threads

Oracle 9i scrollable cursors support

Transparent Application Failover support

Supports many Oracle specific features such as alerts, pipes and Direct Path interface

Separated run-time and GUI specific parts allow to create pure console applications such as CGI

SmartRefresh option allows two or more datasets to be synchronized automatically

Local sorting

Advanced design-time editors

OraTools Add-in extending design-time capabilities by set of tools to build and check queries, design and debug PL/SQL blocks and explore database schemas

Extended SQL tracing capabilities provided by TOraSQLMonitor component and DBMonitor application

Includes source code of TCRDBGrid enhanced data-aware grid control

Wide data-aware and reporting components support, including InfoPower, ReportBuilder, FastReport

Easy migration from BDE

Allows to use Professional Edition of Delphi, C++ Builder or Kylix to develop client/server applications

ODAC supports Oracle 10g, 9i, 8i, 8.0 and 7.3 including Personal and Lite

The following IDEs are supported by ODAC: Borland Delphi 2007, 2006, 2005, 8, 7, 6 and 5, C++ Builder 6 and 5, Kylix 3 and 2. Turbo Delphi, Turbo Delphi for .NET and Turbo C++

ODAC Editions

Oracle Data Access Components comes in three editions: ODAC Standard Edition and ODAC Professional Edition. ODAC Standard Edition includes the ODAC basic connectivity components and the ODAC Migration Wizard. ODAC Professional Edition includes additional components, access to Direct mode for connecting to the Oracle server directly over TCP/IP, and some advanced connection management features. ODAC Developer Edition is a bundle package of ODAC Professional Edition with OraDeveloper Tools, an advanced add-in for Oracle database development and administration.

Standard

Base Components - (TOraSession, TOraQuery, TSmartQuery, TOraSQL, TOraTable, TOraStoredProc, TOraUpdateSQL, TOraDataSource, TOraScript, TOraSQLMonitor, TConnectDialog, TVirtualTable, TCRDBGrid, OraDataAdapter)

Design-time features, including component editors and property editors

Migration Wizard

Professional

Additional Components - (TOraNestedTable, TOraPackage, TOraAlerter, TOraLoader, TOraTransaction, TOraQueue, TOraQueueTable, TOraQueueAdmin, TOraChangeNotification, TOraTrace, TOraErrorHandler, TOraProvider, TBDESession, TCRBatchMove)

Direct connectivity (connection without Oracle client)

Design-time features, including component editors and property editors

DataSet Manager

Migration Wizard

Smart Refresh in TSmartQuery component

Developer

Direct connectivity (connection without Oracle client)

Design-time features, including component editors and property editors

DataSet Manager

Migration Wizard

Smart Refresh in TSmartQuery component

OraDeveloper Tools

What's new in Oracle Data Access Components V8.0.1?

Embarcadero RAD Studio XE2 now supported

Application development for 64-bit Windows now supported

FireMonkey application development platform now supported

Support of 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 LOB parameters fixed

Bug with OraLoader for Number(1,0) data type fixed

Bug with Int64 data type for OraLoader fixed

Bug with filling default values for inactive DataSet in design-time fixed

What's new in Oracle Data Access Components V7.20?

Lazarus 0.9.30 and Free Pascal 2.4.2 support

Oracle 9, Oracle 10, and Oracle 11 authentication in Direct mode is now supported

Case sensitive login and password in Direct mode is now supported

Unicode login and password in Direct mode is now supported

Client Identifier in Direct mode is now supported

Support of BLOB, CLOB, and NCLOB data types in ToraLoader has been improved

Support of "table of blob/clob" data type has been improved

Bug with 'SQL statement doesn't return rows' error if previous statement execution failed is fixed

Bug with invalid update query for Blob fields if the roBeforeEdit option is set has been fixed

Bug with preparing SQL statements that contain empty table parameters has been fixed

Bug with error notification on invalid PL/SQL compilation in Direct mode has been fixed

Bug in bookmark validity check has been fixed

What's new in Oracle Data Access Components V7.10?

Added support for connections using Service Name in Direct mode.

Improved returning cursors with different fields from TOraStoredProc

Fixed Clob parameters reading and writing for charsets with varying character width

Fixed search for the TNS_ADMIN variable in the Oracle root location in the registry.

Fixed the GetOrderBy method

Fixed moving data with the OraNumber data type by the TCRBatchMove component

What's new in Oracle Data Access Components V7.00?

Embarcadero RAD Studio XE supported

What's new in Oracle Data Access Components V6.90?

Embarcadero RAD Studio 2010 now suppored

Now the subdetail is refreshed before the AfterRefresh event of the detail is called

What's new in Oracle Data Access Components V6.80?

Added support for Free Pascal under Linux

Added NoPreconnect property to TOraScript for executing CONNECT and CREATE DATABASE commands

Restored old behaviuor of the Lock method (working without explicit transaction) for compatibility with old ODAC versions

Bug with DetailDelay and refreshing closed dataset fixed

Bug with detecting DBMonitor on 64-bit Windows fixed

Bug with not calling UnregisterClient for internal command of dataset fixed

Bug with refreshing record when RefreshOptions.roBeforeEdit is set and LockMode = lmImmediate fixed

What's new in Oracle Data Access Components V6.70?

Delphi 2009 and C++Builder 2009 supported

Extended Unicode support for Delphi 2007 added (special Unicode build)

Free Pascal 2.2 supported

Powerful design-time editors implemented in Lazarus

Optimized LOB processing in Direct mode

Completed with more comprehensive structured Help

What's new in Oracle Data Access Components V6.25?

Oracle 11g supported

CodeGear RAD Studio 2007 supported

Added ability to customize whether update SQL statements should be prepared

Added ability to set number of rows to be prefetched by OCI

Added the OnProgress event in TOraLoader

C++Builder 2007 supported

What’s new in V6.0?

New functionality:

Delphi 2007 for Win32 supported

Disconnected model for working offline and automatically connecting and disconnecting supported

Local Failover for detecting connection loss and implicitly re-executing some operations supported

LargeInt fields supported

WideMemo field type in Delphi 2006 supported

New tool for easily managing DataSets added

Integration with OraDeveloper Tools 2.00 added

New component for transferring data between all types of TDataSets descendants added

Data export and import to/from XML supported

Support for sending messages to DBMonitor from any point of your program added

Support for more Oracle server functionality:

Distributed transactions supported

Advanced Queuing support added

Change notifications functionality of Oracle 10g supported

DBMS_TRACE package and SQLTrace functionality supported

OCI Connection Pooling, Statement Caching, and Proxy Session Pooling added

External Procedures support added

Extensions and improvements to existing functionality

General performance improved

Master/Detail functionality extensions:

Local Master/Detail relationship support added

Master/Detail relationship in CachedUpdates mode support added

Connection pool functionality improvements:

Efficiency significantly improved

API for draining the connection pool added

TOraScript component improvements:

Support for executing individual statements in scripts added

Support for executing huge scripts stored in files with dynamic loading added

Ability to use standard SQL*Plus tool syntax added

Greatly increased performance of applying updates in CachedUpdates mode

Working with calculated and lookup fields improvements:

Local sorting and filtering added

Record location speed increased

Improved working with lookup fields

Ability to customize update commands by attaching external components to TOraUpdateSQL objects added

Support for using BeforeFetch and AfterFetch events in NonBlocking mode added

Temporary LOBs for updating LOB fields supported

Support for setting connection timeout values for Direct mode added

Ability to include all fields in automatically generated update SQLs added

Support for default field value expressions added

Usability improvements:

Syntax highlighting in design-time editors added

Demo projects became better organized and clearer

Provide high performance direct access to Oracle databases.

Pricing: Oracle Data Access Components (ODAC) V8.1.6 Standard 1 Developer License - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Standard 4 Developer Team License - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Standard 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Professional 1 Developer License - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Professional 1 Developer License - Upgrade from Standard Edition V5.x - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Professional 1 Developer License - Upgrade from NET Edition V5.x - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Professional 1 Developer License - Upgrade from Standard Edition - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Professional 1 Developer License - Upgrade from Professional Edition V5.x - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Professional 4 Developer Team License - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Professional 4 Developer Team License - Upgrade from Standard - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Professional 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Professional 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from Standard Edition V5.x - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Professional 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from Standard Edition - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Professional with Source code 1 Developer License - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Professional with Source code 4 Developer Team License - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Professional with Source code 4 Developer Team License - Upgrade from Professional Edition - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Professional with Source code 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Developer 1 Developer License - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Developer 1 Developer License - Upgrade from Professional Edition - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Developer 4 Developer Team License - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Developer 4 Developer Team License - Upgrade from Professional Edition - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Developer 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Developer 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from Professional Edition - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Developer with Source code 1 Developer License - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Developer with Source code 1 Developer License - Upgrade from Developer Edition - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Developer with Source code 4 Developer Team License - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Developer with Source code 4 Developer Team License - Upgrade from Developer Edition - with 1 Year Subscription, Oracle Data Access Components (ODAC) V8.1.6 Developer with Source code 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscrip

Evals & Downloads: Read the Oracle Data Access Components help file, Read the Oracle Data Access Components License Agreement, Download the Oracle Data Access Components V8.0.1 evaluation on to your computer - Expires After 60 Days

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

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 2006, C++Builder 6, C++Builder 5, C++Builder 4, Delphi XE, Delphi 2010, Delphi 2009, Delphi 2007 for Win32, Delphi 2006 (10.0), Delphi 2005 (9.0), Delphi 8.0, Delphi 7.0, Delphi 6.0, Delphi 5.0, Delphi 4.0, Kylix 1.0, Kylix 3.0, Oracle Database 9i, Oracle Database 10g

Product Class: Business Components

Keywords: corelab crlab cr lab

crlab corelab

Database DB Connectivity

SQL query language

Part numbers: PC-516271-404130 516271-404130 PC-516271-404134 516271-404134 PC-516271-404136 516271-404136 PC-516271-404132 516271-404132 PC-516271-404140 516271-404140 PC-516271-404142 516271-404142 PC-516271-404196 516271-404196 PC-516271-404200 516271-404200 PC-516271-404138 516271-404138 PC-516271-404162 516271-404162 PC-516271-404128 516271-404128 PC-516271-404194 516271-404194 PC-516271-404198 516271-404198 PC-516271-404144 516271-404144 PC-516271-404146 516271-404146 PC-516271-404202 516271-404202 PC-516271-404148 516271-404148 PC-516271-404150 516271-404150 PC-516271-404204 516271-404204 PC-516271-404152 516271-404152 PC-516271-404206 516271-404206 PC-516271-404154 516271-404154 PC-516271-404208 516271-404208 PC-516271-404156 516271-404156 PC-516271-404210 516271-404210 PC-516271-404158 516271-404158 PC-516271-404212 516271-404212 PC-516271-404160 516271-404160 PC-516271-404214 516271-404214 PC-516271-404164 516271-404164 PC-516271-404166 516271-404166 PC-516271-404168 516271-404168 PC-516271-404170 516271-404170 PC-516271-404172 516271-404172 PC-516271-404174 516271-404174 PC-516271-404176 516271-404176 PC-516271-404178 516271-404178 PC-516271-404180 516271-404180 PC-516271-404182 516271-404182 PC-516271-404184 516271-404184 PC-516271-404186 516271-404186 PC-516271-404188 516271-404188 PC-516271-404190 516271-404190 PC-516271-404192 516271-404192

Quick Links

Publisher

Devart (formerly Core Lab) (36)

Primary Category

Database Connectivity (125)

Oracle Data Access Components (ODAC) - Summary

Summary

in association with

Select Business Solutions Catalog

Product Search

Quick Links