Oracle Data Access Component (ODAC) is a component library that provides local connectivity 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 32-bit and 64-bit platforms. The ODAC library is designed to help programmers develop faster and more local Oracle Database applications.
ODAC is a high-performance and feature rich Oracle connectivity solution that is an effective native alternative to 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 accessing Oracle directly from Delphi without an Oracle client.
Native connection to 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 additional opportunities to work directly with Oracle through TCP/IP without involving the Oracle client.
Extensive Oracle functionality
ODAC supports multiple Oracle specific features, such as:
- DML array
- REF cursor
- object
- Supporting facilities
- Direct path loading
- news flash
- pipe
- Change Notice
- 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) for x86 and x64 platforms on Windows, Linux, macOS, iOS, Android, and FreeBSD. ODAC also provides support for the FireMonkey application development platform, which enables you to develop visually appealing high-performance desktop and mobile native applications.
Secure connection
You can use the SecureBridge component 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
Allowing your application to be used directly with Oracle through TCP/IP without involving Oracle clients greatly simplifies application deployment and configuration.
It is easier to use ODAC to develop iOS and Android mobile devices, because ODAC allows your mobile applications to use Oracle Database like desktop applications.
Our product supports Oracle server 21 с， 19c, 18c, 12c, 11g, 10g, 9i, 8i, 8.0, including Oracle Express Edition 11g and 10g.
Our product is compatible with the latest IDE versions, including community versions: 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.
If you want to customize the mapping between Oracle and Delphi data types, you can use the simple and flexible data type mapping engine provided by ODAC.
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.
All our components and libraries are designed to help you write a high-performance, lightweight data access layer, so they use advanced data access algorithms and optimization techniques.
Use our freeware dbMonitor tool to monitor and analyze all database calls made by applications using ODAC. DbMonitor executes SQL statement execution, submission, rollback, and other component based tracking.
Please visit our support page for instant assistance from experienced professionals to quickly resolve your issues and build patches every night.
