Oracle Data Access Components (ODAC) is a component library that provides local connections from Delphi and C++Builder to Oracle, 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. The ODAC library is designed to assist programmers in developing faster and more local Oracle database applications.

ODAC is a high-performance and feature rich Oracle connectivity solution that serves as an effective native replacement for Borland Database Engine (BDE) and standard dbExpress drivers. It provides both the possibility of connecting to Oracle through native Oracle data access and the possibility of directly accessing Oracle from Delphi without an Oracle client.

Local connection with Oracle

ODAC based database applications are easy to deploy and do not require the installation of other data provider layers (such as BDE or ODBC), which is why they can be faster than applications based on standard Delphi data connectivity solutions. In addition, ODAC provides an additional opportunity to work directly with Oracle through TCP/IP without involving the Oracle client.

Extensive Oracle features

ODAC supports multiple Oracle specific features, such as:

1. DML array
2. REF cursor
3. object
4. Supporting facilities
5. Direct path loading
6. news flash
7. pipe
8. Change Notice
9. Advanced queuing
10. Transparent application failover
11. 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, Lazarus (and FPC) for x86 and x64 platforms on Delphi, C++Builder, Windows, Linux, macOS, iOS, Android, and FreeBSD. ODAC also provides support for the FireMonkey application development platform, which enables you to develop visually striking high-performance desktop and mobile native applications.

Secure Connection

You can use the SecureBridge component together with the data access component to embed SSL, SSH, or HTTP/HTTPS clients into your application to establish a secure connection with the server.

Product Features

1. Direct mode

Allow your application to be used directly with Oracle via TCP/IP without involving Oracle clients, greatly simplifying application deployment and configuration.

1. Mobile development

It has become easier to develop iOS and Android mobile devices using ODAC, as it allows your mobile applications to use Oracle databases just like desktop applications.

1. Database compatibility

Our product supports Oracle servers 21 с, 19c, 18c, 12c, 11g, 10g, 9i, 8i, 8.0, including Oracle Express Edition 11g and 10g.

1. IDE compatibility

Our product is compatible with the latest IDE versions, including the Community Edition: Embarcadero RAD Studio 10.4 Sydney, Delphi 10.4 Sydney, C++Builder 10.4 Sydney, Lazarus (and FPC). It is also compatible with early IDE versions starting from Delphi 6 and C++Builder 6.

1. Data type mapping

If you want to customize the correspondence between Oracle and Delphi data types, you can use the simple and flexible data type mapping engine provided by ODAC.

1. Development Platform

Support all major GUI frameworks: Develop VCL applications for Windows or cross platform FMX applications in Delphi, and LCL applications for Windows, macOS, or Linux in Lazarus.

1. performance

All of our components and libraries are designed to help you write high-performance, lightweight data access layers, utilizing advanced data access algorithms and optimization techniques.

1. Monitoring method

Use our free software dbMonitor tool to monitor and analyze all database calls made by the application using ODAC. DbMonitor tracks SQL statement execution, commit, rollback, and other operations by component.

1. support

Please visit our support page for instant assistance from experienced professionals to quickly resolve your issues and build patches every night.