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. See Features for the detailed list of ODAC features.
Feature | Standard | Professional | |
---|---|---|---|
Direct Connectivity |
|||
Connection without Oracle client | |||
Desktop Application Development |
|||
Windows | |||
macOS | |||
Linux | |||
Mobile Application Development |
|||
iOS | |||
Android | |||
Data Access Components |
|||
TOraSession | |||
TOraQuery | |||
TOraTable | |||
TOraStoredProc | |||
TOraUpdateSQL | |||
TOraSQL | |||
TOraDataSource | |||
Script executing
TOraScript |
|||
Transactions managing
TOraTransaction | |||
Fast data loading into the server
TOraLoader |
|||
Advanced Query Components |
|||
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 queing
TOraQueue TOraQueueAdmin TOraQueueTable |
|||
PL/SQL tracing
TOraTrace |
|||
Obtaining metadata about database objects
TOraMetaData |
|||
Oracle errors handling
TOraErrorHandler |
|||
DataBase Activity Monitoring |
|||
Monitoring of per-component SQL execution
TOraSQLMonitor |
|||
Additional Components |
|||
Advanced connection dialog
TConnectDialog |
|||
Data encryption and decryption
TOraEncryptor |
|||
Advanced DataSet provider
TOraProvider |
|||
Data storing in memory table
TVirtualTable |
|||
Dataset that wraps arbitrary non-tabular data
TVirtualDataSet |
|||
Advanced DBGrid with extended functionality
TCRDBGrid |
|||
Records transferring between datasets
TCRBatchMove |
|||
Design-Time Features |
|||
Enhanced component and property editors | |||
Migration Wizard | |||
DataSet Manager | |||
Oracle Package Wizard | |||
Cross IDE Support |
|||
Lazarus and Free Pascal Support |
1 Available only in Professional Edition with Source Code.