Oracle Data Access Components
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, 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.
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), 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.
Wide Coverage of Oracle Features
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.
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, Mac OS X, iOS, 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 native applications for Windows and Mac OS X.
High Development Productivity with ODAC
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
data.
Quotes
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
Key Features
Direct Mode
Allows your application to work with Oracle directly via TCP/IP without involving
Oracle Client, thus significantly facilitating deployment and configuration of your
applications.
DB Compatibility
Our product supports Oracle servers 11g, 10g, 9i, 8i, 8.0, and 7.3, including Oracle
Express Edition 11g and 10g.
64-bit Development
ODAC doesn't limit your choice of the development platform. Now you can develop
for 32-bit and 64-bit platforms with Delphi, Lazarus (and FPC).
Data Type Mapping
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.
IDE Compatibility
Our product is compatible with the latest IDE versions: Embarcadero RAD Studio XE4,
Delphi XE4, C++Builder XE4, Lazarus (and FPC). It is also compatible with the previous
IDE versions since Delphi 5 and C++Builder 5.
Development Platforms
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
platform.
Performance
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.
Monitoring
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,
etc.
Support
Visit our Support page to get nimble
support from cognizant professionals, fast and detailed responses, user engagement
and interaction, frequent builds with bug fixes, and much more.