ODAC

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. See Features for the detailed list of ODAC features.

ODAC Edition Matrix

Feature Standard Professional

Direct Connectivity

Connection without Oracle client No Yes

Desktop Application Development

Windows Yes Yes
macOS No Yes
Linux No Yes

Mobile Application Development

iOS No Yes
Android No Yes

Data Access Components

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

Advanced Query Components

Expanded field representation
TSmartQuery
Yes Yes
Smart refresh in TSmartQuery component No Yes

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

Monitoring of per-component SQL execution
TOraSQLMonitor
Yes Yes

Additional Components

Advanced connection dialog
TConnectDialog
No 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

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

Cross IDE Support

Lazarus and Free Pascal Support No Click to view restrictions

1 Available only in Professional Edition with Source Code.

© 1997-2022 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback