Oracle Data Access Components Editions

Oracle Data Access Components comes in two editions: Standard and Professional.

The Standard edition includes the ODAC basic connectivity components and ODAC Migration Wizard. ODAC Standard Edition is a cost-effective solution for database application developers who are looking for high-performance connectivity to Oracle for secure, reliable, and high-speed data transmission.

The Professional edition shows off the full power of ODAC, enhancing ODAC Standard Edition with support for Oracle-specific functionality, access to the Direct mode for connecting to the Oracle server directly via TCP/IP, and some advanced dataset management features.

You can get Source Access to the Client mode implementation of all the component classes in ODAC by purchasing a special ODAC Professional Edition with Source Code. The source code of DataSet Manager and Migration Wizard is not distributed. The source code of the Direct mode for Oracle is distributed obfuscated.

The matrix below compares the features of ODAC editions. The detailed list of all ODAC features can be found on the features page.

Features Standard Professional
Direct Connectivity

Direct Connectivity

Connection without Oracle client No Yes
DAC

Desktop Application Development

Windows Yes Yes
macOS No Yes
Linux No Yes
DAC

Mobile Application Development

iOS No Yes
Android No Yes
DAC

Data Access Components

Base components
  TOraSession
  TOraQuery
  TOraTable
  TOraStoredProc
  TOraUpdateSQL
  TOraSQL
  TOraDataSource
Yes Yes
Script executing
  TOraScript
Yes Yes
Transactions managing
  TOraTransaction
No Yes
Fast data loading into the server
  TOraLoader
No Yes
Advanced Query Component

Advanced Query Component

Expanded field representation
  TSmartQuery
Yes Yes
Smart refresh in TSmartQuery component No Yes
Oracle Specific Components

Oracle Specific Components

Oracle packages
  TOraPackage
No Yes
Oracle nested tables
  TOraNestedTable
Yes Yes
Messaging between sessions and applications
  TOraAlerter
No Yes
Reaction on server side changes on-the-fly
  TOraChangeNotification
No Yes
Oracle advanced queing
  TOraQueue
  TOraQueueAdmin
  TOraQueueTable
No Yes
PL/SQL tracing
  TOraTrace
No Yes
Obtaining metadata about database objects
  TOraMetaData
No Yes
Oracle errors handling
  TOraErrorHandler
No Yes
DataBase Activity Monitoring

Database Activity Monitoring

Monitoring of per-component SQL execution
  TOraSQLMonitor
Yes Yes
Additional Components

Additional Components

Advanced connection dialog
  TConnectDialog
Yes Yes
Data encryption and decryption
  TOraEncryptor
No Yes
Advanced DataSet provider
  TOraProvider
No Yes
Data storing in memory table
  TVirtualTable
Yes Yes
Dataset that wraps arbitrary non-tabular data
  TVirtualDataSet
Yes Yes
Advanced DBGrid with extended functionality
  TCRDBGrid
Yes Yes
Records transferring between datasets
  TCRBatchMove
No Yes
Design-Time Features

Design-Time Features

Enhanced component and property editors Yes Yes
Migration Wizard Yes Yes
DataSet Manager No Yes
Oracle Package Wizard No Yes
Cross IDE Support

Cross IDE Support

Lazarus and Free Pascal support No Click to view restrictions
Single License Price $209.95 $329.95

1 Available only in editions with source code.