About Oracle Data Access Components (ODAC)

Provide high performance direct access to Oracle databases.

Oracle Data Access Components (ODAC) is set of VCL native components for Delphi and C++ Builder. It supports many Oracle specific features and simplifies developing of client/server applications. With Net option ODAC works directly through TCP/IP and doesn't require Oracle's software on client side. ODAC can work in managed environment and provides extended Oracle data types support including XML types, LOB's, objects, nested tables, references, timestamps and intervals.

Oracle Data Access Components (ODAC) library offers some nonvisual components for Borland Delphi, C++ Builder and Kylix. They serve for access to Oracle RDBMS. ODAC is an alternative to standard way processing data by Borland Database Engine (BDE).

ODAC uses Oracle Call Interface (OCI) directly. Also with Net option ODAC allows to connect without Oracle client software installed on workstation. In such cases ODAC requires only TCP/IP protocol and allows you to build really thin database applications.

Key features:

  • Direct access to Oracle data. No distributing, installing and configuring the BDE and ODBC
  • Doesn't require Oracle's software on client side with Net option and works directly through TCP/IP
  • Extended Oracle data types support including XML types, LOB's, objects, nested tables, references, timestamps and intervals
  • High performance controlled fetch of large data blocks
  • Optimized string and raw data storing
  • Easy work with Unicode data
  • Automatic data updating with TSmartQuery and TOraTable components
  • Automatic record locking and refreshing
  • NonBlocking mode allows to run long lasting background queries in separate threads
  • Oracle 9i scrollable cursors support
  • Transparent Application Failover support
  • Supports many Oracle specific features such as alerts, pipes and Direct Path interface
  • Separated run-time and GUI specific parts allow to create pure console applications such as CGI
  • SmartRefresh option allows two or more datasets to be synchronized automatically
  • Local sorting
  • Advanced design-time editors
  • OraTools Add-in extending design-time capabilities by set of tools to build and check queries, design and debug PL/SQL blocks and explore database schemas
  • Extended SQL tracing capabilities provided by TOraSQLMonitor component and DBMonitor application
  • Includes source code of TCRDBGrid enhanced data-aware grid control
  • Wide data-aware and reporting components support, including InfoPower, ReportBuilder, FastReport
  • Easy migration from BDE
  • Allows to use Professional Edition of Delphi, C++ Builder or Kylix to develop client/server applications
  • ODAC supports Oracle 10g, 9i, 8i, 8.0 and 7.3 including Personal and Lite

The following IDEs are supported by ODAC: Borland Delphi 2007, 2006, 2005, 8, 7, 6 and 5, C++ Builder 6 and 5, Kylix 3 and 2. Turbo Delphi, Turbo Delphi for .NET and Turbo C++ 

ODAC Editions

Oracle Data Access Components comes in three editions: ODAC Standard Edition and ODAC Professional Edition. ODAC Standard Edition includes the ODAC basic connectivity components and the ODAC Migration Wizard. ODAC Professional Edition includes additional components, access to Direct mode for connecting to the Oracle server directly over TCP/IP, and some advanced connection management features. ODAC Developer Edition is a bundle package of ODAC Professional Edition with OraDeveloper Tools, an advanced add-in for Oracle database development and administration.

Standard

  • Base Components - (TOraSession, TOraQuery, TSmartQuery, TOraSQL, TOraTable, TOraStoredProc, TOraUpdateSQL, TOraDataSource, TOraScript, TOraSQLMonitor, TConnectDialog, TVirtualTable, TCRDBGrid, OraDataAdapter)
  • Design-time features, including component editors and property editors
  • Migration Wizard

Professional

  • Base Components - (TOraSession, TOraQuery, TSmartQuery, TOraSQL, TOraTable, TOraStoredProc, TOraUpdateSQL, TOraDataSource, TOraScript, TOraSQLMonitor, TConnectDialog, TVirtualTable, TCRDBGrid, OraDataAdapter)
  • Additional Components - (TOraNestedTable, TOraPackage, TOraAlerter, TOraLoader, TOraTransaction, TOraQueue, TOraQueueTable, TOraQueueAdmin, TOraChangeNotification, TOraTrace, TOraErrorHandler, TOraProvider, TBDESession, TCRBatchMove)
  • Direct connectivity (connection without Oracle client)
  • Design-time features, including component editors and property editors
  • DataSet Manager
  • Migration Wizard
  • Smart Refresh in TSmartQuery component