Oracle Data Access Components (ODAC) is a library of components that provides native connectivity to Oracle from Delphi, Delphi for .NET, C++Builder and Kylix. 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. Related Products Advantages of ODAC Technology ODAC is a direct connectivity database wrapper built specifically for the Oracle server. ODAC offers wide coverage of the Oracle feature set, supports both Client and Direct connection modes, and emphasizes optimized data access strategies. Wide Coverage of Oracle Features By providing access to the most advanced database functionality, ODAC allows developers to harness the full capabilities of the Oracle server and optimize their database applications. ODAC stands out as the set of components with the widest support of Oracle functionality. It is the only component library to support Oracle distributed transactions and implements support for controlling statement caching, OCI pooling, and Oracle Advanced Queuing. Native Connection Options ODAC offers two connection modes to the Oracle server: connection through the Oracle Call Interface in Client mode and direct connection over TCP/IP in Direct mode. ODAC-based database applications are easy to deploy, do not require installation of other data provider layers (such as BDE), and tend to be faster than those that use standard data connectivity solutions.

Optimized Code
The goal of ODAC is to enable developers to write efficient and flexible database applications. The ODAC library is implemented using advanced data access algorithms and optimization techniques. Classes and components undergo comprehensive performance tests and are designed to help you write high-performance, lightweight data access layers. To see results of ODAC performance tests, visit the ODAC performance page.

Compatibility with Standard Data Access Components
The ODAC interface retains compatibility with standard VCL data access components like BDE. Existing BDE-based applications can be easily migrated to ODAC and enhanced to take advantage of Oracle-specific features like alerts, pipes, and the direct-path interface. Project migration can be automated with the BDE Migration Wizard.

How Does ODAC Work?

ODAC allows you to connect to Oracle in two ways: in Client mode, using Oracle client software, or in Direct mode, over TCP/IP.

In Client mode, ODAC connects to Oracle through the Oracle Call Interface (OCI). OCI is an application programming interface that allows an application developer to use a third-generation language's native procedure or function calls to access the Oracle database server and control all phases of SQL statement execution. OCI is a library of standard database access and retrieval functions in the form of a dynamic-link library.

In Direct mode, ODAC connects to Oracle directly without using Oracle client software. In this mode, ODAC requires only TCP/IP support, and lets you build really thin database applications.

In comparison, the Borland Database Engine (BDE) uses several layers to access Oracle, and requires additional data access software to be installed on client machines.

The BDE data transfer protocol is shown below.

BDE Connection Protocol

Using ODAC in Client mode allows your application to connect to OCI directly.

ODAC Connection Flow [Client Mode]

Using ODAC in Direct mode provides the optimal transfer route.

ODAC Connection Flow [Direct Mode]

Components

All editions of ODAC include the following basic components:

• TOraSession - lets you set up and control connections to Oracle
• TOraQuery - executes queries, operates record set, provides flexible way updating database tables with automatically building INSERT, DELETE, UPDATE statements
• TSmartQuery - easy in using traffic-efficient alternative to TOraQuery for working with large tables with lots of fields, includes Smart Refresh functionality in Professional and Developer Editions
• TOraTable - lets you retrieve and update data in a single table without writing SQL statements
• TOraStoredProc - executes stored procedures and functions, allows to edit cursor data returned as parameter
• TOraSQL - executes SQL statements, PL/SQL blocks, stored procedures
• TOraScript - executes sequences of SQL and PL/SQL statements
• TOraUpdateSQL - lets you tune update operations for a DataSet component
• TOraNestedTable - controls nested table's data
• TOraDataSource - provides an interface for connecting data-aware controls on a form and ODAC dataset components
• TOraSQLMonitor - allows to monitor dynamic SQL executing in ODAC based applications
• TConnectDialog - allows you to build custom prompts for usernames, passwords, and server names
• TVirtualTable - provides dataset functionality for data that has no real database connection
• OraDataAdapter - .NET component, uses TDataSet as data source for retrieving and saving data to System.Data.DataSet

ODAC Professional Edition and ODAC Developer Edition include the following additional components:

• TOraPackage - provides a straightforward way to access Oracle packages
• TOraLoader - allows you to quickly load data into Oracle databases
• TOraAlerter - allows you to transfer messages between sessions
• TOraTransaction - provides discrete transaction control over sessions, can be used to manipulate both simple and distributed transactions
• TOraQueue - lets you monitor the message queue, provides an interface for enqueuing and dequeuing messages
• TOraQueueTable - manages queue tables
• TOraQueueAdmin - manages Oracle queues
• TOraChangeNotification - allows you to use Oracle Database Change Notifications
• TOraTrace - allows you to start and stop the SQL trace for a specified session
• TOraErrorHandler - translates error messages
• TBDESession - allows to integrate ODAC components into BDE based application
• TOraProvider - provides data to and applies updates from a client dataset
• TCRBatchMove - transfers data between all types of TDataSet descendants

Key Features

The following list describes the main features of Oracle Data Access Components.

• 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

Detailed list »

ODAC Editions

Oracle Data Access Components comes in four editions: ODAC Standard Edition, ODAC Professional Edition, ODAC Developer Edition, and ODAC Trial Edition.

ODAC Standard Edition includes the ODAC basic connectivity components and the ODAC Migration Wizard. ODAC Standard Edition is a cost-effective solution for database application developers who are looking for overall high-performance connectivity to Oracle.

ODAC Professional Edition shows off the full power of ODAC, enhancing ODAC Standard Edition with support for Oracle-specific functionality, 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 working with Oracle databases.

ODAC Trial Edition is the evaluation version of ODAC. It includes all the functionality of ODAC Professional Edition with a trial limitation of 60 days. Kylix, C++Builder, and supported .NET IDEs have additional trial limitations.

You can get Source Access to the Client mode implementation of all the component classes in ODAC by purchasing the special ODAC Professional Edition with Source Code or ODAC Developer Edition with Source Code.

Connecting in Direct Mode

By default, ODAC, like most applications that work with Oracle, uses the Oracle Call Interface (OCI) to connect to the Oracle database server. This is referred to as connecting in Client mode, and it is the usual way to develop Oracle applications with a third-generation language. All OCI routines are stored in external libraries, so the executables for applications that work through OCI are small. However, working through OCI requires Oracle client software to be installed on target workstations. This is an inconvenience and causes additional installation and administration expenses. Furthermore, there are some situations in which installation of Oracle client is not advisable or may even be impossible; for example, when deploying an application to remote machines which do not have qualified administration.

To overcome these problems, ODAC Developer Edition and ODAC Professional Edition include an option to connect to Oracle directly over the network using the TCP/IP protocol. This is referred to as connecting in Direct mode. Connecting in Direct mode does not require Oracle client software to be installed on target machines. The only requirement for running an ODAC-based application that uses the Direct mode is that the operating system must have TCP/IP support.

Compatibility

ODAC supports Oracle servers 11g, 10g, 9i, 8i, 8.0, and 7.3, including Oracle 10g Express, Oracle 8i Personal, and Lite editions.
ODAC supports x86 versions of the following Oracle clients: 11g, 10g, 9i, 8i, 8.0, and 7.3.

ODAC is compatible with the following IDEs:

CodeGear RAD Studio 2007 CodeGear C++Builder 2007 CodeGear Delphi 2007 for Win32 Turbo Delphi Professional Turbo Delphi for .NET Professional Turbo C++ Professional Borland Developer Studio 2006 including support of Delphi for Win32, Delphi for .NET and C++Builder Personality Borland Delphi 2005 Borland Delphi 8 Borland Delphi 7 Borland Delphi 6 Borland Delphi 5 Borland C++Builder 6 Borland C++Builder 5 Borland Kylix 3 Borland Kylix 2

Only Architect, Enterprise, and Professional editions are supported. ODAC does not support Kylix Open Edition.

ODAC Design-Time View

Related Products

You might be also interested in:

• VCL components for other databases:
  MySQL, SQL Server, InterBase, Firebird, universal components
  
  
• Oracle data access in other technologies:
  ADO.NET data providers, BDP.NET providers, dbExpress drivers, C++ class library
  
  
• Oracle development environment:
  OraDeveloper Studio, a standalone IDE for Oracle development
  
  
• Integrated development solution for working with Oracle:
  OraDeveloper Tools, a set of add-ins for Visual Studio and Borland Delphi