Oracle Data Access Components

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

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.

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

Oracle Data Access Components V6.70 Standard

Add to Cart	$ 146.95	1 Developer License - Standard Edition - with 1 Year Subscription	Download (45.3 MB)
Add to Cart	$ 342.95	4 Developer Team License - Standard Edition - with 1 Year Subscription	Download (45.3 MB)
Add to Cart	$ 881.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Standard Edition - with 1 Year Subscription	Download (45.3 MB)

Oracle Data Access Components V6.70 Professional

Add to Cart	$ 244.95	1 Developer License - Professional Edition - with 1 Year Subscription		Download (51.3 MB)
Add to Cart	$ 48.95	1 Developer License - Professional Edition Upgrade from Standard Edition V5.x - with 1 Year Subscription	Verify	Download (51.3 MB)
Add to Cart	$ 48.95	1 Developer License - Professional Edition Upgrade from NET Edition V5.x - with 1 Year Subscription	Verify	Download (51.3 MB)
Add to Cart	$ 587.95	4 Developer Team License - Professional Edition - with 1 Year Subscription		Download (51.3 MB)
Add to Cart	$ 244.95	4 Developer Team License - Professional Edition Upgrade from Standard - with 1 Year Subscription	Verify	Download (51.3 MB)
Add to Cart	$ 1,469.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Professional Edition - with 1 Year Subscription		Download (51.3 MB)

Oracle Data Access Components V6.70 Professional with Source code

Add to Cart	$ 440.95	1 Developer License - Professional Edition with Source code - with 1 Year Subscription		Download (58.1 MB)
Add to Cart	$ 146.95	1 Developer License - Professional Edition with Source code - Upgrade from Professional Edition V5.x - with 1 Year Subscription	Verify	Download (58.1 MB)
Add to Cart	$ 1,028.95	4 Developer Team License - Professional Edition with Source code - with 1 Year Subscription		Download (58.1 MB)
Add to Cart	$ 2,400.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Professional Edition with Source code - with 1 Year Subscription		Download (58.1 MB)

Oracle Data Access Components V6.70 Developer

Add to Cart	$ 293.95	1 Developer License - Developer Edition - with 1 Year Subscription	Download (66.5 MB)
Add to Cart	$ 685.95	4 Developer Team License - Developer Edition - with 1 Year Subscription	Download (66.5 MB)
Add to Cart	$ 1,714.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Developer Edition - with 1 Year Subscription	Download (66.5 MB)

Oracle Data Access Components V6.70 Developer with Source code

Add to Cart	$ 489.95	1 Developer License - Developer Edition with Source code - with 1 Year Subscription	Download (73.3 MB)
Add to Cart	$ 1,126.95	4 Developer Team License - Developer Edition with Source code - with 1 Year Subscription	Download (73.3 MB)
Add to Cart	$ 2,645.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Developer Edition with Source code	Download (73.3 MB)

Oracle Data Access Components Standard Subscription Renewals

Add to Cart	$ 48.95	1 Developer License Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 127.35	4 Developer Team License Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 293.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal	Verify	Download (29 KB)

Oracle Data Access Components Professional Subscription Renewals

Add to Cart	$ 88.15	1 Developer License Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 235.15	4 Developer Team License Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 529.15	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal	Verify	Download (29 KB)

Oracle Data Access Components Professional with Source code Subscription Renewals

Add to Cart	$ 166.55	1 Developer License Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 391.95	4 Developer Team License Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 950.55	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal	Verify	Download (29 KB)

Oracle Data Access Components Developer Subscription Renewals

Add to Cart	$ 117.55	1 Developer License Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 284.15	4 Developer Team License Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 685.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal	Verify	Download (29 KB)

Oracle Data Access Components Developer with Source code Subscription Renewals

Add to Cart	$ 186.15	1 Developer License Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 431.15	4 Developer Team License Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 1,019.15	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) 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.

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

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

Base Components - (TOraSession, TOraQuery, TSmartQuery, TOraSQL, TOraTable, TOraStoredProc, TOraUpdateSQL, TOraDataSource, TOraScript, TOraSQLMonitor, TConnectDialog, TVirtualTable, TCRDBGrid, OraDataAdapter)
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

Base Components - (TOraSession, TOraQuery, TSmartQuery, TOraSQL, TOraTable, TOraStoredProc, TOraUpdateSQL, TOraDataSource, TOraScript, TOraSQLMonitor, TConnectDialog, TVirtualTable, TCRDBGrid, OraDataAdapter)
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
OraDeveloper Tools