本地連接Oracle

基于ODAC的數(shù)據(jù)庫部署簡單，無需安裝其他數(shù)據(jù)提供層（如BDE或ODBC）。因此，它比基于standard Delphi data 的連接方案要快。此外，ODAC可以直接通過TCP/ IP與Oeacle協(xié)作，不用經(jīng)過Oracle客戶端。

支持大部分Oracle功能

ODAC支持大部分的Oracle功能，如DML矩陣、REF游標(biāo)、對(duì)象、包、直接加載路徑、提示、Pipes、高級(jí)矩陣、 透明應(yīng)用故障切換，等等。

Delphi、C++Builder和Lazarus的跨平臺(tái)解決方案

ODAC是一個(gè)跨平臺(tái)的解決方案，用于各種集成開發(fā)環(huán)境：RAD Studio、 Delphi,、C++Builder、 Lazarus (and FPC) on Windows、Mac OS X、iOS、 Android、 Linux和FreeBSD（x86、x64）。ODAC還支持FireMonkey應(yīng)用開發(fā)平臺(tái)，可以開發(fā)可視化高性能的臺(tái)式機(jī)和移動(dòng)原生應(yīng)用程序。

高效率開發(fā)

ODAC提供了很多GUI工具，大大提高您的工作效率。dbMonitor可以監(jiān)測(cè)數(shù)據(jù)庫應(yīng)用程序的活動(dòng)；Dataset Manager簡化了數(shù)據(jù)集和DB控制調(diào)整；OraDeveloper工具簡化了探索和維護(hù)現(xiàn)有的數(shù)據(jù)塊，設(shè)計(jì)和查詢SQL復(fù)合語句以及處理數(shù)據(jù)。

關(guān)鍵特性

直接模式

移動(dòng)開發(fā)

DB兼容性

數(shù)據(jù)類型映射

IDE兼容性

開發(fā)平臺(tái)

性能

監(jiān)控

支持

Components
All editions of ODAC include the following basic components:

• TOraSession - lets you set up and control connections to Oracle
• TOraQuery - executes queries, operates record set, provides flexible way updating database tables with automatically building INSERT, DELETE, UPDATE statements
• TSmartQuery - easy in using traffic-efficient alternative to TOraQuery for working with large tables with lots of fields, includes Smart Refresh functionality in Professional and Developer Editions
• TOraTable - lets you retrieve and update data in a single table without writing SQL statements
• TOraStoredProc - executes stored procedures and functions, allows to edit cursor data returned as parameter
• TOraSQL - executes SQL statements, PL/SQL blocks, stored procedures
• TOraScript - executes sequences of SQL and PL/SQL statements
• TOraUpdateSQL - lets you tune update operations for a DataSet component
• TOraNestedTable - controls nested table's data
• TOraDataSource - provides an interface for connecting data-aware controls on a form and ODAC dataset components
• TOraSQLMonitor - allows to monitor dynamic SQL executing in ODAC based applications
• TConnectDialog - allows you to build custom prompts for usernames, passwords, and server names
• TVirtualTable - provides dataset functionality for data that has no real database connection
• OraDataAdapter - .NET component, uses TDataSet as data source for retrieving and saving data to System.Data.DataSet

ODAC Professional Edition and ODAC Developer Edition include the following additional components:

• TOraPackage - provides a straightforward way to access Oracle packages
• TOraLoader - allows you to quickly load data into Oracle databases
• TOraAlerter - allows you to transfer messages between sessions
• TOraTransaction - provides discrete transaction control over sessions, can be used to manipulate both simple and distributed transactions
• TOraQueue - lets you monitor the message queue, provides an interface for enqueuing and dequeuing messages
• TOraQueueTable - manages queue tables
• TOraQueueAdmin - manages Oracle queues
• TOraChangeNotification - allows you to use Oracle Database Change Notifications
• TOraTrace - allows you to start and stop the SQL trace for a specified session
• TOraErrorHandler - translates error messages
• TBDESession - allows to integrate ODAC components into BDE based application
• TOraMetaData - retrieves metadata on specified SQL object
• TOraProvider - provides data to and applies updates from a client dataset
• TCRBatchMove - transfers data between all types of TDataSet descendants

Key Features
 The following list describes the main features of Oracle Data Access Components.

• Direct access to server data. Does not require installation of other data provider layers (such as BDE and ODBC)
• In Direct mode does not require Oracle client software and works directly through TCP/IP
• VCL, VCL.NET, and CLX versions of library available
• Full support of the latest versions of Oracle
• Support for all Oracle data types
• Disconnected Model with automatic connection control for working with data offline
• Local Failover for detecting connection loss and implicitly re-executing certain operations
• Oracle Transparent Application Failover support
• All types of local sorting and filtering, including by calculated and lookup fields
• Automatic data updating with TOraQuery, TSmartQuery, and TOraTable components
• Unicode and national charsets support
• Distributed transaction support
• Oracle Advanced Queuing support
• Support for many Oracle-specific features, such as alerts, pipes and direct path interface
• Advanced script execution functionality with TOraScript component
• Support for using Macros in SQL
• Integration with OraDeveloper Tools for performing advanced database development and administration tasks
• Easy migration from BDE with Migration Wizard
• Lets you use Professional Edition of Delphi, C++Builder, and Kylix to develop client/server applications
• Includes annual ODAC Subscription with Priority Support
• Licensed royalty-free per developer, per team, or per site