Oracle Data Access Components Editions

Oracle Data Access Components comes in three editions: Developer, Professional, and Standard.

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 overall high-performance connectivity to Oracle.

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.

The Developer edition is a bundle package of ODAC Professional Edition with OraDeveloper Tools, an advanced add-in for managing Oracle databases.

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. The source code of DataSet Manager is not distributed. The source code of Oracle Direct mode is supplied as precompiled packages.

The matrix below compares features of ODAC editions. The detailed list of all ODAC features you can find at the ODAC features page.

Features Developer Professional Standard
Direct Connectivity

Direct Connectivity

Connection without Oracle client Yes Yes No
DAC

Mobile Development

iOS application development Yes Yes Yes
DAC

Data Access Components

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

Advanced Query Component

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

Oracle Specific Components

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

Database Activity Monitoring

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

Additional Components

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

Design-Time Features

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

Cross IDE Support

Lazarus and Free Pascal support Click to view restrictions Click to view restrictions No
Tools

Tools

  OraDeveloper Tools Yes No No
Single License Price $299.95 $249.95 $149.95

1 Available only in editions with source code.


Oracle Data Access Components