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 |
|||
| Connection without Oracle client |
|
|
|
Desktop Application Development |
|||
| Windows |
|
|
|
| macOS |
|
|
|
| Linux |
|
|
|
Mobile Application Development |
|||
| iOS |
|
|
|
| Android |
|
|
|
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 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 |
|
|
|
| Single License Price | $209.95 | $329.95 | |
1 Available only in editions with source code.