A directory of data access products for Delphi

Product: Oracle Data Access Components (ODAC)
Vendor: DevArt
Version: 7.00 Data Aware Controls: TDataSet
Web Site: http://www.devart.com/odac/ Support Delphi Vers: 5 6 7 2005 2006 2007 2009 2010 XE
Source Available: Yes Supports C++B Vers: 5 6 2006 2007 2009 2010 XE

Description: ODAC is a complete replacement for standard Oracle connectivity solutions.
Deployment: Oracle client software is required
Modes of

Check indicates
primary intended
Multiuser File Server:
Multiuser Client/Server: Yes
Web Server: Yes

Package(s) Available: Price:
Standard Edition (Single) $149.95
Standard Edition (Team) $349.95
Standard Edition (Site) $649.95
Professional Edition (Single) $199.95
Professional Edition (Team) $499.95
Professional Edition (Site) $899.95
Professional Edition with source code (Single) $349.95
Professional Edition with source code (Team) $849.95
Professional Edition with source code (Site) $1499.95

Database/File Format Supported Native? Via Notes
Oracle Yes

Third Party Tool Compatibility: Compatible?
(Delphi) Database Explorer Unknown
Ace Reporter Unknown
InfoPower Yes
Orpheus (TurboPower) Unknown
QuickReports Yes
RAVE Reports Unknown
ReportBuilder Pro Yes

Vendor's Description (from Readme files, web site, etc.):

Oracle Data Access Components (ODAC) is a library of components that provides native connectivity to Oracle from Delphi, Delphi for .NET, C++Builder, Kylix, and Free Pascal. The ODAC library is designed to help programmers develop faster and cleaner Oracle database applications.
ODAC is a complete replacement for standard Oracle connectivity solutions and presents an efficient native alternative to the Borland Database Engine and dbExpress for access to Oracle.

Advantages of ODAC Technology

  • Wide Coverage of Oracle Features
  • Native Connection Options
  • Optimized Code
  • Compatibility with Standard Data Access Components

Key Features

  • Direct access to server data. Does not require installation of other data provider layers (such as BDE and ODBC);
  • In Direct mode does not require Oracle client software and works directly through TCP/IP;
  • VCL, VCL.NET, and CLX versions of library available;
  • Full support of the latest versions of Oracle;
  • Support for all Oracle data types;
  • Disconnected Model with automatic connection control for working with data offline;
  • Local Failover for detecting connection loss and implicitly re-executing certain operations;
  • Oracle Transparent Application Failover support;
  • All types of local sorting and filtering, including by calculated and lookup fields;
  • Automatic data updating with TOraQuery, TSmartQuery, and TOraTable components;
  • Unicode and national charsets support;
  • Distributed transaction support;
  • Oracle Advanced Queuing support;
  • Support for many Oracle-specific features, such as alerts, pipes and direct path interface;
  • Advanced script execution functionality with TOraScript component;
  • Support for using Macros in SQL;
  • Integration with OraDeveloper Tools for performing advanced database development and administration tasks;
  • Easy migration from BDE with Migration Wizard;
  • Lets you use Professional Edition of Delphi, C++Builder, and Kylix to develop client/server applications;
  • Includes annual ODAC Subscription with Priority Support;
  • Licensed royalty-free per developer, per team, or per site.

Is this data old or incomplete? Visit the How To Contribute page.