issues faster

Database Tools

Must-have SQL Server tools and tools for MySQL, Oracle, and PostgreSQL database development, management and administration

Data Connectivity

The most trusted solutions for your data connectivity needs: ADO.NET, ODBC, SSIS, Excel, dbExpress, Delphi Components

Productivity Tools

Write code, create reviews, compare sources, track the working hours with the web app, utilize the power of ORM Solutions

Data Services

Data integration, online backup, web-based SQL tools, cloud connectivity solution

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

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. The source codes of DataSet Manager and Migration Wizard are not distributed. The source code of Oracle Direct Mode is supplied obfuscated.

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

Features Standard Professional
Direct Connectivity

Direct Connectivity

Connection without Oracle client No Yes

Desktop Application Development

Windows Yes Yes
macOS Yes Yes
Linux No Yes

Mobile Application Development

iOS No Yes
Android No Yes

Data Access Components

Base components
Yes Yes
Script executing
Yes Yes
Transactions managing
No Yes
Fast data loading into the server
No Yes
Advanced Query Component

Advanced Query Component

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

Oracle Specific Components

Oracle packages
No Yes
Oracle nested tables
Yes Yes
Messaging between sessions and applications
No Yes
Reaction on server side changes on-the-fly
No Yes
Oracle advanced queing
No Yes
PL/SQL tracing
No Yes
Obtaining metainformation about database objects
No Yes
Oracle errors handling
No Yes
DataBase Activity Monitoring

Database Activity Monitoring

Monitoring of per-component SQL execution
Yes Yes
Additional Components

Additional Components

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

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

Cross IDE Support

Lazarus and Free Pascal support No Click to view restrictions
Single License Price $199.95 $299.95

1 Available only in editions with source code.