Connection to Oracle Database From Delphi, C++Builder, and Lazarus

Q: How do I download ODAC for a free trial?

Click the Download button at the top of the page, select the component that matches your environment, and click Get trial . If you are not signed in, sign in to your Devart account or sign up if you don't have one yet. Then proceed with downloading ODAC for a free, fully-functional 60-day trial.

Oracle Data Access Components (ODAC) is a library of components that provides native connectivity to Oracle from Delphi and C++Builder (including Community Edition), as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms. ODAC is an efficient native alternative to the Borland Database Engine (BDE) and the standard dbExpress driver, designed to help develop Oracle-based applications faster.

Direct access to data with no need for Oracle Client
Full compatibility with BDE and ADO data access methods
Native libraries available for VCL, LCL, and FMX
Comprehensive support for Oracle-specific data types and PL/SQL

Native connectivity to Oracle

ODAC-based DB applications are easy to deploy, do not require installation of other data provider layers (such as BDE or ODBC). This makes them faster than those based on standard Delphi data connectivity solutions. Moreover, ODAC provides an additional opportunity to work directly with Oracle via TCP/IP without involving the Oracle Client.

ODAC supports the following Oracle versions:

Oracle Server: 26ai, 23c, 21c, 19c, 18c, 12c, 11g, 10g, 9i, 8i, 8.0, including the Express Editions of 11g and 10g
Oracle Client: 23c, 21c, 19c, 18c, 12c, 11g, 10g, 9i, 8i, 8.0, Oracle Instant Client
Oracle Cloud

Features

Secure connection

You can use ODAC with SecureBridge components to embed SSL, SSH, or HTTP/HTTPS protocols into your application developed in Delphi, C++Builder, Lazarus, and Free Pascal for establishing a secure Oracle database connection.

IDE compatibility

ODAC is compatible with the latest IDE versions, including Community editions: Embarcadero RAD Studio 13 Florence, Delphi 13 Florence, C++Builder 13 Florence, Lazarus (and FPC), as well as with previous IDE versions since Delphi 6 and C++Builder 6.

Development platforms

ODAC supports all major GUI frameworks, providing you with all the capabilities you need to develop VCL applications for Windows or cross-platform FMX applications in Delphi, as well as LCL applications for Windows, macOS, or Linux in Lazarus.

Mobile development support

Our Oracle Data Access Components facilitate and expedite application development for iOS and Android devices by enabling your mobile applications to access and query Oracle databases as easily and efficiently as desktop applications do.

Performance

All our Oracle-optimized components and libraries use advanced data access algorithms and engineering best practices to assist you with writing high-performance, lightweight data access layers.

Data type mapping

If your application requires establishing custom alignment between Oracle and Delphi data types, you can achieve it by using the straightforward and flexible Data Type Mapping engine available in ODAC.

Monitoring

Use our freeware dbMonitor to monitor and analyze all the database calls made by your application using ODAC. dbMonitor performs per-component tracing of SQL statement execution, commits, rollbacks, etc.

Support

Whenever you need assistance, you can visit our Support page to get instant help from knowledgeable and experienced professionals, a quick resolution of your problems, and nightly builds with hotfixes.

ODAC supports a wide range of Oracle-specific features

DML arrays
REF cursors
Objects

Packages
Direct path loading
Alerts

Pipes
Change notifications
Advanced queuing

Transparent application failover
and more...

Cross-platform solution for Delphi, C++Builder, and Lazarus

ODAC is a cross-platform solution for developing applications using various IDEs: RAD Studio, Delphi, C++Builder, Lazarus (and FPC) on Windows, Linux, macOS, iOS, Android, and FreeBSD for both x86 and x64 platforms. ODAC also provides support for the FireMonkey application development platform, which allows you to develop visually spectacular, high-performance desktop- and mobile-native applications.

ODAC supports various application development platforms and IDEs

Pricing

Oracle Data Access Components

Starts from

$229_.95

Try the Oracle Components

Key features:

Direct mode without Oracle client
VCL, LCL, FMX support
Standard data access compatibility
Full Oracle technology support
Design-time productivity tools
Disconnected model capabilities

Universal Data Access Components

Starts from

$349_.95

Try the Universal Components

Key features:

Universal access to multiple databases
Direct mode without client libraries
VCL, LCL, FMX support
Disconnected mode with failover
Unified database-independent queries
Design-time productivity tools

Advanced ORM support

Entity Developer and EntityDAC enhance ODAC by adding ORM capabilities on top of its direct Oracle connectivity. EntityDAC uses ODAC as its underlying data access layer for native, direct Oracle connections without client software. Entity Developer provides a visual designer to create ORM models, generate Delphi entity classes, and support LINQ queries mapped to Oracle via ODAC.

Key benefits for ODAC users

Visual ORM modeling: Design database schemas into Delphi classes with inheritance and encapsulation.
LINQ for Oracle queries: Write server-agnostic queries that ODAC executes efficiently.
Code-first flexibility: Generate or hand-edit entities, leveraging ODAC's performance features like caching.
Seamless integration: No extra providers needed; ODAC handles TCP/IP access while EntityDAC abstracts data into objects.

Other Data Access Components for databases

SQL Server

Ready to get started?

Get a free 60-day trial now

Download ODAC for a FREE 60-day trial and enjoy the high performance and new possibilities when working with Oracle.

Get a free trial now

Enjoy bulk discounts

We offer flexible options to meet your budget in the optimal way. You can get bulk discounts for multiple purchases.

Discover now

Need a hand?

If you need any help or have questions about our connectivity solutions or purchasing options, feel free to get in touch.

Contact us

FAQ

What is ODAC?

ODAC (Oracle Data Access Components) is a set of data access libraries designed for building applications that connect to Oracle databases from Delphi, C++Builder, Lazarus (Free Pascal), and other RAD Studio environments.

How do I download ODAC for a free trial?

Click the Download button at the top of the page, select the component that matches your environment, and click Get trial. If you are not signed in, sign in to your Devart account or sign up, if you don't have one yet. Then proceed with downloading ODAC for a free, fully-functional 60-day trial.

Is a registration or email required to download ODAC?

Yes. To download ODAC, you need to sign in to your Devart account or sign up to create one.

Where do I find the documentation for ODAC?

You can find the ODAC documentation at Devart's documentation portal.

Can I download and use ODAC without installing Oracle Client?

Absolutely. In Direct mode, you can connect and use ODAC through TCP/IP without installing Oracle client software.

How do I install ODAC on Windows?

To install ODAC on Windows, run the installer you downloaded and follow the instructions in the wizard. Note that installing ODAC requires changes to your environment. For more details, see the documentation.