Oracle Data Access Components(ODAC) (6.90)


Product Type:VCL Function Type:DataBase Develop Language:C++ Builder,Delphi


1 submitted comments View Comment | Add Comment

Oracle Data Access Components (ODAC) is a library of components that provides native connectivity to Oracle from Delphi, Delphi for .NET, C++Builder and Kylix. The ODAC library is designed to help programmers develop faster and cleaner Oracle database applications.


Current Release on 2009-12-24    42 people download

Pricing & Licensing

$149     

for one developer

$249     

for one developer

$299     

for one developer

$449     

for one developer

$499     

for one developer

$349     

for up to four developers

$599     

for up to four developers

$699     

for up to four developers

$1049     

for up to four developers

$1149     

for up to four developers

$899     

for an unlimited number of developers in a single company.

$1499     

for an unlimited number of developers in a single company.

$1749     

for an unlimited number of developers in a single company.

$2449     

for an unlimited number of developers in a single company.

$2699     

for an unlimited number of developers in a single company.

Overview

General usability

  • Direct access to server data. Does not require installation of other data provider layers (such as BDE and ODBC)
  • Interface compatible with standard data access methods, such as BDE and ADO
  • VCL, VCL for .NET, and CLX versions of library available
  • Separated run-time and GUI specific parts allow you to create pure console applications such as CGI
  • Unicode and national charset support


Network and connectivity

  • In Direct mode does not require Oracle client software and works directly through TCP/IP
  • Disconnected Model with automatic connection control for working with data offline
  • Local Failover for detecting connection loss and implicitly reexecuting certain operations
  • Support for setting connection timeout values for Direct mode


Compatibility

  • Full support of the latest versions of Oracle
  • Support for all Oracle data types
  • Compatible with Delphi 5 through 8, BDS 2005, BDS 2006, Delphi 2007 for Win32, C++Builder 5, 6, and 2007, Kylix, Turbo Delphi, Turbo Delphi for .NET, and Turbo C++
  • Wide reporting component support, including support for InfoPower, ReportBuilder, FastReport
  • Support of all standard and third-party visual data-aware controls
  • Allows you to use Professional Edition of Delphi and C++Builder to develop client/server applications.


Oracle technology support

  • Oracle Advanced Queuing support
  • Distributed transactions support with TOraTransaction component
  • Oracle package support
  • Support for Oracle alerts and pipes with TOraAlerter component
  • Support for Direct Path interface with TOraLoader component
  • Support for DBMS_TRACE package and SQLTrace functionality with TOraTrace
  • Support for Oracle Change notifications functionality of Oracle 10g with TOraChangeNotification component
  • Oracle Transparent Application Failover support
  • Oracle 9i scrollable cursor support
  • Multiple Oracle Homes support
  • Oracle sequence support
  • DML array operations support
  • Direct lob access support
  • Temporary LOB management routines
  • Temporary LOBs for updating LOB fields
  • OCI Connection Pooling, Proxy Session Pooling, and Statement Caching
  • Oracle optimizer control
  • ProxySession support
  • External Procedure support
  • CLIENT_IDENTIFIER support


Oracle data types

  • Oracle Object (including NOT FINAL objects) types support
  • Nested table support
  • PL/SQL table support
  • XMLTYPE datatype support
  • Oracle 9i TIMESTAMP and INTERVAL data types support


Performance

  • High overall performance
  • Fast controlled fetch of large data blocks
  • Optimized string data storing
  • Advanced connection pooling
  • High performance applying of cached updates with batches
  • Caching of calculated and lookup fields
  • Expanded fields in TSmartQuery
  • Fast Locate in a sorted DataSet
  • Preparing of user-defined update statements


Local data storage operations

  • Database-independent data storage with TVirtualTable component
  • CachedUpdates operation mode
  • Local sorting and filtering, including by calculated and lookup fields
  • Local master/detail relationship
  • Master/detail relationship in CachedUpdates mode


Data access and data management automation

  • Automatic data updating with TOraQuery, TSmartQuery and TOraTable components
  • Automatic record refreshing and locking
  • Automatic query preparing
  • SmartRefresh option allows you to synchronize two or more datasets automatically
  • Support for ftWideMemo field type in Delphi 2006 and higher


Extended data access functionality

  • Separate component for executing SQL and PL/SQL blocks
  • Simplified access to table data with TOraTable component
  • BLOB compression support
  • Support for using macros in SQL
  • NonBlocking mode allows background executing and fetching data in separate threads
  • Ability to customize update commands by attaching external components to TOraUpdateSQL objects
  • Deferred detail DataSet refresh in master/detail relationships
  • LargeInt fields support
  • MIDAS technology support
  • OraDataAdapter component for WinForms and ASP.NET applications
  • Ability to customize Oracle error messages with TOraErrorHandler


Data exchange

  • Transferring data between all types of TDataSet descendants with TCRBatchMove component
  • Data export and import to/from XML (ADO format)
  • Ability to synchronize positions in different DataSets


Script execution

  • Advanced script execution features with TOraScript component
  • Support for executing individual statements in scripts
  • Support for executing huge scripts stored in files with dynamic loading
  • Ability to use standard SQL*Plus tool syntax in scripts


SQL Execution monitoring

  • Extended SQL tracing capabilities provided by TOraSQLMonitor component and DBMonitor
  • Borland SQL Monitor support
  • Ability to send messages to DBMonitor from any point in your program


Visual extensions

  • Includes source code of enhanced TCRDBGrid data-aware grid control
  • Customizable connection dialog
  • Cursor changes during non-blocking execution


Design-time enhancements

  • DataSet Manager tool to control DataSet instances in the project
  • Oracle Package Wizard that simplifies working with PL/SQL Packages
  • Advanced design-time component and property editors
  • Integration with OraDeveloper Tools for browsing database schemas, manipulating database objects and visual building of queries
  • Automatic design-time component linking
  • OraTools Add-in extends design-time capabilities and lets you build and test queries, design and debug PL/SQL blocks and explore database schemas
  • Easy migration from BDE with Migration Wizard
  • More convenient data source setup with the TOraDataSource component
  • Syntax highlighting in design-time editors


Product clarity

  • Complete documentation sets
  • Printable documentation in PDF format
  • A large amount of helpful demo projects

Evals & Downloads

download counts: 10

ODAC for RAD Studio 2010

download counts: 7

ODAC for Delphi and C++Builder 2009

download counts: 6

ODAC for C++Builder 6

download counts: 5

ODAC for Delphi, C++Builder, and RAD Studio 2007

download counts: 5

ODAC Unicode for Delphi, C++Builder, and RAD Studio 2007

download counts: 4

ODAC for BDS 2006 and Turbos

download counts: 5

ODAC for FreePascal, Linux version

Send a question to Vendor