Oracle Data Access Components - VCL - V6.50 - 개요

개요 | 가격 및 라이센스 | 평가판과 다운로드 | 호환성 | 개발처 정보 | 리뷰 | 지원 포럼 | 요약

요약

Oracle Data Access Components by Devart (formerly Core Lab)

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.

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

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

PartNumbers: PC-516271-138280 516271-138280 PC-516271-138282 516271-138282 PC-516271-138283 516271-138283 PC-516271-138281 516271-138281 PC-516271-138285 516271-138285 PC-516271-138286 516271-138286 PC-516271-138284 516271-138284 PC-516271-138296 516271-138296 PC-516271-138279 516271-138279 PC-516271-138287 516271-138287 PC-516271-138297 516271-138297 PC-516271-138288 516271-138288 PC-516271-138289 516271-138289 PC-516271-138290 516271-138290 PC-516271-138291 516271-138291 PC-516271-138292 516271-138292 PC-516271-138293 516271-138293 PC-516271-138294 516271-138294 PC-516271-138295 516271-138295 PC-516271-161874 516271-161874 PC-516271-161875 516271-161875 PC-516271-161876 516271-161876 PC-516271-161877 516271-161877 PC-516271-161878 516271-161878 PC-516271-161879 516271-161879 PC-516271-161880 516271-161880 PC-516271-161881 516271-161881 PC-516271-161882 516271-161882 PC-516271-161883 516271-161883 PC-516271-161884 516271-161884 PC-516271-161885 516271-161885 PC-516271-161886 516271-161886 PC-516271-161887 516271-161887 PC-516271-161888 516271-161888

PurchaseOptions: Oracle Data Access Components V6.50 Standard 1 Developer License - Standard Edition - with 1 Year Subscription , Oracle Data Access Components V6.50 Standard 4 Developer Team License - Standard Edition - with 1 Year Subscription , Oracle Data Access Components V6.50 Standard 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Standard Edition - with 1 Year Subscription , Oracle Data Access Components V6.50 Professional 1 Developer License - Professional Edition - with 1 Year Subscription , Oracle Data Access Components V6.50 Professional 1 Developer License - Professional Edition Upgrade from Standard Edition V5.x - with 1 Year Subscription , Oracle Data Access Components V6.50 Professional 1 Developer License - Professional Edition Upgrade from NET Edition V5.x - with 1 Year Subscription , Oracle Data Access Components V6.50 Professional 4 Developer Team License - Professional Edition - with 1 Year Subscription , Oracle Data Access Components V6.50 Professional 4 Developer Team License - Professional Edition Upgrade from Standard - with 1 Year Subscription , Oracle Data Access Components V6.50 Professional 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Professional Edition - with 1 Year Subscription , Oracle Data Access Components V6.50 Professional with Source code 1 Developer License - Professional Edition with Source code - with 1 Year Subscription , Oracle Data Access Components V6.50 Professional with Source code 1 Developer License - Professional Edition with Source code - Upgrade from Professional Edition V5.x - with 1 Year Subscription , Oracle Data Access Components V6.50 Professional with Source code 4 Developer Team License - Professional Edition with Source code - with 1 Year Subscription , Oracle Data Access Components V6.50 Professional with Source code 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Professional Edition with Source code - with 1 Year Subscription , Oracle Data Access Components V6.50 Developer 1 Developer License - Developer Edition - with 1 Year Subscription , Oracle Data Access Components V6.50 Developer 4 Developer Team License - Developer Edition - with 1 Year Subscription , Oracle Data Access Components V6.50 Developer 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Developer Edition - with 1 Year Subscription , Oracle Data Access Components V6.50 Developer with Source code 1 Developer License - Developer Edition with Source code - with 1 Year Subscription , Oracle Data Access Components V6.50 Developer with Source code 4 Developer Team License - Developer Edition with Source code - with 1 Year Subscription , Oracle Data Access Components V6.50 Developer with Source code 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Developer Edition with Source code , Oracle Data Access Components Standard Subscription Renewals 1 Developer License Subscription Renewal , Oracle Data Access Components Standard Subscription Renewals 4 Developer Team License Subscription Renewal , Oracle Data Access Components Standard Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal , Oracle Data Access Components Professional Subscription Renewals 1 Developer License Subscription Renewal , Oracle Data Access Components Professional Subscription Renewals 4 Developer Team License Subscription Renewal , Oracle Data Access Components Professional Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal , Oracle Data Access Components Professional with Source code Subscription Renewals 1 Developer License Subscription Renewal , Oracle Data Access Components Professional with Source code Subscription Renewals 4 Developer Team License Subscription Renewal , Oracle Data Access Components Professional with Source code Subscription Ren

Resources: Read the Oracle Data Access Components License Agreement

Operating System for Deployment: Windows Vista, Windows XP, Windows Server 2003, Windows ME, Windows 2000, Windows 98, Windows NT 4.0, Windows 95

Architecture of Product: 32Bit

Product Type: Component

Component Type: VCL

Compatible Containers: C++Builder 6, C++Builder 5, C++Builder 4, Delphi 2005 (9.0), Delphi 8.0, Delphi 7.0, Delphi 6.0, Delphi 5.0, Delphi 4.0, Kylix 1.0, Kylix 3.0, Oracle Database 9i, Oracle Database 10g

Product Class: Business Components

Search Items: New Product Aug 05

Keywords: crlab corelab SQL query language Database DB Connectivity Author corelab crlab cr lab