Oracle Data Access Components

Category: ASP.NET - Miscellaneous

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. ODAC is a complete replacement for standard Oracle connectivity solutions and presents an efficient native alternative to the Borland Database Engine and dbExpress for access to Oracle. Advantages:ODAC is a direct connectivity database wrapper built specifically for the Oracle server. ODAC offers wide coverage of the Oracle feature set, supports both Client and Direct connection modes, and emphasizes optimized data access strategies. Wide Coverage of Oracle Features By providing access to the most advanced database functionality, ODAC allows developers to harness the full capabilities of the Oracle server and optimize their database applications. ODAC stands out as the set of components with the widest support of Oracle functionality. It is the only component library to support Oracle distributed transactions and implements support for controlling statement caching, OCI pooling, and Oracle Advanced Queuing. Native Connection Options ODAC offers two connection modes to the Oracle server: connection through the Oracle Call Interface in Client mode and direct connection over TCP/IP in Direct mode. ODAC-based database applications are easy to deploy, do not require installation of other data provider layers (such as BDE), and tend to be faster than those that use standard data connectivity solutions. Optimized Code The goal of ODAC is to enable developers to write efficient and flexible database applications. The ODAC library is implemented using advanced data access algorithms and optimization techniques. Classes and components undergo comprehensive performance tests and are designed to help you write high-performance, lightweight data access layers. To see results of ODAC performance tests, visit the ODAC performance page. Compatibility with Standard Data Access Components The ODAC interface retains compatibility with standard VCL data access components like BDE. Existing BDE-based applications can be easily migrated to ODAC and enhanced to take advantage of Oracle-specific features like alerts, pipes, and the direct-path interface. Project migration can be automated with the BDE Migration Wizard. How Does ODAC Work? ODAC allows you to connect to Oracle in two ways: in Client mode, using Oracle client software, or in Direct mode, over TCP/IP. In Client mode, ODAC connects to Oracle through the Oracle Call Interface (OCI). OCI is an application programming interface that allows an application developer to use a third-generation language's native procedure or function calls to access the Oracle database server and control all phases of SQL statement execution. OCI is a library of standard database access and retrieval functions in the form of a dynamic-link library. In Direct mode, ODAC connects to Oracle directly without using Oracle client software. In this mode, ODAC requires only TCP/IP support, and lets you build really thin database applications. In comparison, the Borland Database Engine (BDE) uses several layers to access Oracle, and requires additional data access software to be installed on client machines. Key Features:- 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 Date: 21 January, 2012


Data Access - Oracle Data - Database Tool - Developer - Tool - Asp Net

Homepage: http://www.devart.com/

Developer: devart.com

License: Freeware

Operating System: All

Add a Comment

all are required fields

     
What do you think of this resource?

Select Your Rate:

Votes:0

 

Related Scripts Download

A superset of C compatible and platform independant scripting language.

developer Developer: Mr. Cheng
license License: Freeware
operating systems Operating System: Linux, Unix, Windows


Universal Data Access Components (UniDAC) is a powerful library of nonvisual cross-database data access components for Delphi, Delphi for.

developer Developer: devart.com
license License: Freeware
operating systems Operating System: All


Allows decorating and caching expensive data consuming tasks.

developer Developer: Eugene Mirotin
license License: Freeware
operating systems Operating System: Windows


neo_my2pg is a Python script for migration from mysql to postgresql.

developer Developer: SourceForge.net
license License: Artistic License, GNU General Public License (GPL)
operating systems Operating System: Windows, Linux, Mac OS, BSD, Solaris


sqlWebArchitect is a Web-Based Open Source SQL Server and MSDE Database Administration tool.

developer Developer: SourceForge.net
license License: Artistic License, GNU General Public License (GPL)
operating systems Operating System: Windows


SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

developer Developer: SourceForge.net
license License: Artistic License, GNU General Public License (GPL)
operating systems Operating System: Windows, Linux, Mac OS, BSD, Solaris


Download Trakker masks the true address of a URL.

developer Developer: scriptsforyou.net
license License: Freeware
operating systems Operating System: All


Zend Framework is based on simplicity, object-oriented best practices, corporate friendly licensing, and a rigorously tested agile codebase.

developer Developer: framework.zend.com
license License: Freeware
operating systems Operating System: All


This is a HTML viewer activeX control for Content Management System developers.

developer Developer: nbit.net.au
license License: Freeware
operating systems Operating System: All