Oracle Data Access Components (ODAC)
by Devart (formerly Core Lab) - Product Type: Component / VCL
Provide high performance direct access to Oracle databases. Oracle Data Access Components (ODAC) is set of VCL native components for Kylix, 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.
Our regular prices are shown below. Please logon to see your discounted prices.
Oracle Data Access Components (ODAC) V8.1.6 Standard
| Add to Cart | $ 146.95 | 1 Developer License - with 1 Year Subscription | Download (54.9 MB) | |
| Add to Cart | $ 342.95 | 4 Developer Team License - with 1 Year Subscription | Download (54.9 MB) | |
| Add to Cart | $ 881.95 | 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription | Download (54.9 MB) |
Oracle Data Access Components (ODAC) V8.1.6 Professional
| Add to Cart | $ 244.95 | 1 Developer License - with 1 Year Subscription | Download (62.9 MB) | |
| Add to Cart | $ 48.95 | 1 Developer License - Upgrade from Standard Edition V5.x - with 1 Year Subscription | Verify | Download (62.9 MB) |
| Add to Cart | $ 48.95 | 1 Developer License - Upgrade from NET Edition V5.x - with 1 Year Subscription | Verify | Download (62.9 MB) |
| Add to Cart | $ 97.95 | 1 Developer License - Upgrade from Standard Edition - with 1 Year Subscription | Verify | Download (62.9 MB) |
| Add to Cart | $ 146.95 | 1 Developer License - Upgrade from Professional Edition V5.x - with 1 Year Subscription | Verify | Download (62.9 MB) |
| Add to Cart | $ 587.95 | 4 Developer Team License - with 1 Year Subscription | Download (62.9 MB) | |
| Add to Cart | $ 244.95 | 4 Developer Team License - Upgrade from Standard - with 1 Year Subscription | Verify | Download (62.9 MB) |
| Add to Cart | $ 1,469.95 | 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription | Download (62.9 MB) | |
| Add to Cart | $ 293.95 | 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from Standard Edition V5.x - with 1 Year Subscription | Verify | Download (54.9 MB) |
| Add to Cart | $ 587.95 | 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from Standard Edition - with 1 Year Subscription | Verify | Download (62.9 MB) |
Oracle Data Access Components (ODAC) V8.1.6 Professional with Source code
| Add to Cart | $ 440.95 | 1 Developer License - with 1 Year Subscription | Download (69.3 MB) | |
| Add to Cart | $ 1,028.95 | 4 Developer Team License - with 1 Year Subscription | Download (69.3 MB) | |
| Add to Cart | $ 440.95 | 4 Developer Team License - Upgrade from Professional Edition - with 1 Year Subscription | Verify | Download (69.3 MB) |
| Add to Cart | $ 2,400.95 | 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription | Download (69.3 MB) |
Oracle Data Access Components (ODAC) V8.1.6 Developer
| Add to Cart | $ 293.95 | 1 Developer License - with 1 Year Subscription | Download (83.5 MB) | |
| Add to Cart | $ 48.95 | 1 Developer License - Upgrade from Professional Edition - with 1 Year Subscription | Verify | Download (83.5 MB) |
| Add to Cart | $ 685.95 | 4 Developer Team License - with 1 Year Subscription | Download (83.5 MB) | |
| Add to Cart | $ 97.95 | 4 Developer Team License - Upgrade from Professional Edition - with 1 Year Subscription | Verify | Download (83.5 MB) |
| Add to Cart | $ 1,714.95 | 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription | Download (83.5 MB) | |
| Add to Cart | $ 244.95 | 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from Professional Edition - with 1 Year Subscription | Verify | Download (83.5 MB) |
Oracle Data Access Components (ODAC) V8.1.6 Developer with Source code
| Add to Cart | $ 489.95 | 1 Developer License - with 1 Year Subscription | Download (89.9 MB) | |
| Add to Cart | $ 195.95 | 1 Developer License - Upgrade from Developer Edition - with 1 Year Subscription | Verify | Download (89.9 MB) |
| Add to Cart | $ 1,126.95 | 4 Developer Team License - with 1 Year Subscription | Download (89.9 MB) | |
| Add to Cart | $ 440.95 | 4 Developer Team License - Upgrade from Developer Edition - with 1 Year Subscription | Verify | Download (89.9 MB) |
| Add to Cart | $ 2,645.95 | 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription | Download (89.9 MB) | |
| Add to Cart | $ 930.95 | 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from Developer Edition - with 1 Year Subscription | Verify | Download (89.9 MB) |
Oracle Data Access Components (ODAC) Standard Subscription Renewals
| Add to Cart | $ 48.95 | 1 Developer License Subscription Renewal | Verify | Download (29 KB) |
| Add to Cart | $ 127.35 | 4 Developer Team License Subscription Renewal | Verify | Download (29 KB) |
| Add to Cart | $ 293.95 | 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal | Verify | Download (29 KB) |
Oracle Data Access Components (ODAC) Professional Subscription Renewals
| Add to Cart | $ 88.15 | 1 Developer License Subscription Renewal | Verify | Download (29 KB) |
| Add to Cart | $ 235.15 | 4 Developer Team License Subscription Renewal | Verify | Download (29 KB) |
| Add to Cart | $ 529.15 | 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal | Verify | Download (29 KB) |
Oracle Data Access Components (ODAC) Professional with Source code Subscription Renewals
| Add to Cart | $ 166.55 | 1 Developer License Subscription Renewal | Verify | Download (29 KB) |
| Add to Cart | $ 391.95 | 4 Developer Team License Subscription Renewal | Verify | Download (29 KB) |
| Add to Cart | $ 950.55 | 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal | Verify | Download (29 KB) |
Oracle Data Access Components (ODAC) Developer Subscription Renewals
| Add to Cart | $ 117.55 | 1 Developer License Subscription Renewal | Verify | Download (29 KB) |
| Add to Cart | $ 284.15 | 4 Developer Team License Subscription Renewal | Verify | Download (29 KB) |
| Add to Cart | $ 685.95 | 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal | Verify | Download (29 KB) |
Oracle Data Access Components (ODAC) Developer with Source code Subscription Renewals
| Add to Cart | $ 186.15 | 1 Developer License Subscription Renewal | Verify | Download (29 KB) |
| Add to Cart | $ 431.15 | 4 Developer Team License Subscription Renewal | Verify | Download (29 KB) |
| Add to Cart | $ 1,019.15 | 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal | Verify | Download (29 KB) |
Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase. All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed, including volume licensing and previous versions.
Our regular prices are shown above. Please logon to see your discounted prices.
;)
What's new in Oracle Data Access Components V8.0.1?
- Embarcadero RAD Studio XE2 now supported
- Application development for 64-bit Windows now supported
- FireMonkey application development platform now supported
- Support of master/detail relationship for TVirtualTable added
- OnProgress event in TVirtualTable added
- TDADataSetOptions.SetEmptyStrToNull property that allows inserting NULL value instead of empty string added
- Bug with LOB parameters fixed
- Bug with OraLoader for Number(1,0) data type fixed
- Bug with Int64 data type for OraLoader fixed
- Bug with filling default values for inactive DataSet in design-time fixed
What's new in Oracle Data Access Components V7.20?
- Lazarus 0.9.30 and Free Pascal 2.4.2 support
- Oracle 9, Oracle 10, and Oracle 11 authentication in Direct mode is now supported
- Case sensitive login and password in Direct mode is now supported
- Unicode login and password in Direct mode is now supported
- Client Identifier in Direct mode is now supported
- Support of BLOB, CLOB, and NCLOB data types in ToraLoader has been improved
- Support of "table of blob/clob" data type has been improved
- Bug with 'SQL statement doesn't return rows' error if previous statement execution failed is fixed
- Bug with invalid update query for Blob fields if the roBeforeEdit option is set has been fixed
- Bug with preparing SQL statements that contain empty table parameters has been fixed
- Bug with error notification on invalid PL/SQL compilation in Direct mode has been fixed
- Bug in bookmark validity check has been fixed
What's new in Oracle Data Access Components V7.10?
- Added support for connections using Service Name in Direct mode.
- Improved returning cursors with different fields from TOraStoredProc
- Fixed Clob parameters reading and writing for charsets with varying character width
- Fixed search for the TNS_ADMIN variable in the Oracle root location in the registry.
- Fixed the GetOrderBy method
- Fixed moving data with the OraNumber data type by the TCRBatchMove component
What's new in Oracle Data Access Components V7.00?
- Embarcadero RAD Studio XE supported
What's new in Oracle Data Access Components V6.90?
- Embarcadero RAD Studio 2010 now suppored
- Now the subdetail is refreshed before the AfterRefresh event of the detail is called
What's new in Oracle Data Access Components V6.80?
- Added support for Free Pascal under Linux
- Added NoPreconnect property to TOraScript for executing CONNECT and CREATE DATABASE commands
- Restored old behaviuor of the Lock method (working without explicit transaction) for compatibility with old ODAC versions
- Bug with DetailDelay and refreshing closed dataset fixed
- Bug with detecting DBMonitor on 64-bit Windows fixed
- Bug with not calling UnregisterClient for internal command of dataset fixed
- Bug with refreshing record when RefreshOptions.roBeforeEdit is set and LockMode = lmImmediate fixed
What's new in Oracle Data Access Components V6.70?
- Delphi 2009 and C++Builder 2009 supported
- Extended Unicode support for Delphi 2007 added (special Unicode build)
- Free Pascal 2.2 supported
- Powerful design-time editors implemented in Lazarus
- Optimized LOB processing in Direct mode
- Completed with more comprehensive structured Help
What's new in Oracle Data Access Components V6.25?
- Oracle 11g supported
- CodeGear RAD Studio 2007 supported
- Added ability to customize whether update SQL statements should be prepared
- Added ability to set number of rows to be prefetched by OCI
- Added the OnProgress event in TOraLoader
- C++Builder 2007 supported
What’s new in V6.0?
New functionality:
- Delphi 2007 for Win32 supported
- Disconnected model for working offline and automatically connecting and disconnecting supported
- Local Failover for detecting connection loss and implicitly re-executing some operations supported
- LargeInt fields supported
- WideMemo field type in Delphi 2006 supported
- New tool for easily managing DataSets added
- Integration with OraDeveloper Tools 2.00 added
- New component for transferring data between all types of TDataSets descendants added
- Data export and import to/from XML supported
- Support for sending messages to DBMonitor from any point of your program added
Support for more Oracle server functionality:
- Distributed transactions supported
- Advanced Queuing support added
- Change notifications functionality of Oracle 10g supported
- DBMS_TRACE package and SQLTrace functionality supported
- OCI Connection Pooling, Statement Caching, and Proxy Session Pooling added
External Procedures support added
- Extensions and improvements to existing functionality
- General performance improved
- Master/Detail functionality extensions:
- Local Master/Detail relationship support added
- Master/Detail relationship in CachedUpdates mode support added
- Connection pool functionality improvements:
- Efficiency significantly improved
- API for draining the connection pool added
- TOraScript component improvements:
- Support for executing individual statements in scripts added
- Support for executing huge scripts stored in files with dynamic loading added
- Ability to use standard SQL*Plus tool syntax added
- Greatly increased performance of applying updates in CachedUpdates mode
- Working with calculated and lookup fields improvements:
- Local sorting and filtering added
- Record location speed increased
- Improved working with lookup fields
- Ability to customize update commands by attaching external components to TOraUpdateSQL objects added
- Support for using BeforeFetch and AfterFetch events in NonBlocking mode added
- Temporary LOBs for updating LOB fields supported
- Support for setting connection timeout values for Direct mode added
- Ability to include all fields in automatically generated update SQLs added
- Support for default field value expressions added
Usability improvements:
- Syntax highlighting in design-time editors added
- Demo projects became better organized and clearer
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
Developer
- 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
- OraDeveloper Tools
Quick Links
Publisher
Primary Category
- Database Connectivity (125)
Related Products
- dotConnect for Oracle
- dbExpress Driver for Oracle
- Universal Data Access Components (UniDAC)
- dbForge Compare Bundle for Oracle
- Entity Developer
Related Categories
- SQL (140)
