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 here.

Features Developer Professional Standard
Direct Connectivity
Connection without Oracle client
Data Access Components
Base components
TOraSession
TOraQuery
TOraTable
TOraStoredProc
TOraUpdateSQL
TOraSQL
TOraDataSource
Script executing
TOraScript
Transactions managing
TOraTransaction
Fast data loading into the server
TOraLoader
Advanced Query Component
Expanded field representation
TSmartQuery
Smart refresh in TSmartQuery component
Oracle Specific Components
Oracle packages
TOraPackage
Oracle nested tables
TOraNestedTable
Messaging between sessions and applications
TOraAlerter
Reaction on server side changes on-the-fly
TOraChangeNotification
Oracle advanced queuing
TOraQueue
TOraQueueAdmin
TOraQueueTable
PL/SQL tracing
TOraTrace
Obtaining metainformation about database objects
TOraMetaData
Oracle errors handling
TOraErrorHandler
Database Activity Monitoring
Monitoring of per-component SQL execution
TOraSQLMonitor
Additional Components
Advanced connection dialog
TConnectDialog
Advanced DataSet provider
TOraProvider
Data storing in memory table
TVirtualTable
Advanced DBGrid with extended functionality
TCRDBGrid
Records transferring between datasets
TCRBatchMove
Design-Time Features
Enhanced component and property editors
Migration Wizard
DataSet Manager
Cross IDE Support
Lazarus and Free Pascal support Click to view restrictions Click to view restrictions
Tools
OraDeveloper Tools
Single License Price $299.95 $249.95 $149.95

1 Available only in editions with source code.