Oracle Data Access Components (ODAC) is a library of components that
provides native connectivity to Oracle from Delphi, C++Builder, Lazarus
(and Free Pascal) on Windows, Mac OS X, iOS, Android, Linux, and FreeBSD
for both 32-bit and 64-bit platforms. The ODAC library is designed
to help programmers develop faster and more native Oracle database applications.
ODAC, a high-performance and feature-rich Oracle connectivity solution, is an efficient
native alternative to the Borland Database Engine (BDE) and standard dbExpress driver.
It provides both possibility of connection to Oracle by means of native Oracle data
access and direct access to Oracle without Oracle Client.
ODAC-based DB applications are easy to deploy, do not require installation of other
data provider layers (such as BDE or ODBC), and that's why they can work faster
than the ones based on standard Delphi data connectivity solutions. Moreover, ODAC
provides an additional opportunity to work with Oracle directly via TCP/IP without
involving Oracle Client.
ODAC supports a wide range of Oracle-specific features, such as DML Arrays, REF
cursors, Objects, Packages, Direct Path Loading, Alerts, Pipes, Change notifications,
Advanced Queuing, Transparent Application Failover, and others.
ODAC is a cross-platform solution for developing applications using various IDEs:
RAD Studio, Delphi, C++Builder, Lazarus (and FPC) on Windows, Mac OS X, iOS, Android,
Linux, 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.
We provide various GUI tools that will increase your productivity: dbMonitor allows
monitoring activity of your DB applications, Dataset Manager simplifies DataSet
and DB controls tweaking, OraDeveloper Tools provides an easier way to explore and
maintain existing DBs, design compound SQL statements and queries, as well as manipulate
Allows your application to work with Oracle directly via TCP/IP without involving
Oracle Client, thus significantly facilitating deployment and configuration of your
Develompent for iOS and Android mobile devices using ODAC becomes still easier,
as ODAC allows your mobile applications to work with Oracle database as simply as
desktop applications do.
Our product supports Oracle servers 12c, 11g, 10g, 9i, 8i, 8.0, and 7.3, including
Oracle Express Edition 11g and 10g.
If you want to make custom correspondence between Oralce and Delphi data types,
you can use a simple and flexible Data Type Mapping engine provided by ODAC.
Our product is compatible with the latest IDE versions: Embarcadero RAD Studio 10 Seattle,
Delphi 10 Seattle, C++Builder 10 Seattle, Lazarus (and FPC). It is also compatible with the previous
IDE versions since Delphi 5 and C++Builder 6.
Now you can develop not only VCL-based applications in Delphi and LCL-based ones
in Lazarus, but also use the newest FireMonkey application development
All our components and libraries are designed to help you write high-performance,
lightweight data access layers, therefore they use advanced data access algorithms
and techniques of optimization.
Use our freeware dbMonitor tool to monitor
and analyze all the DB calls made by your application using ODAC. dbMonitor performs
percomponent tracing of SQL statement execution, commits, rollbacks,
Visit our Support page to get instant
support from experienced professionals, fast and detailed responses, user engagement
and interaction, frequent builds with bug fixes, and much more.
DAC Team's Blog
You might be also interested in:
ORM solution for Delphi:
Oracle management tools:
Delphi data access components for:
Universal Delphi data access components for any databases:
Oracle data access in other technologies:
We have developed a client server application using Oracle 11.g in a biggest Hospital
in Greece about 400 users (Delphi5 and ODAC 6.9) this is working fantastic...
Evangelos Bekyros, Executive Manager of Pefki Software Company
I'am using the Devart (Core
lab's) products (Mydac, Odac, Unidac) since the year 2004.
And I always be very satisfied with the Devart's products and technical support.
Stéphane Deriaz, Managing director, Bluelib Sàrl, Switzerland