Oracle Data Access Components

RATING:

4.7

(11)

About Oracle Data Access Components

ODAC is an Oracle connectivity solution that has been actively developed and supported since 1998. ODAC comes with full documentation, demo projects, and fast technical support by the ODAC development team. The goal of ODAC is to enable developers to write efficient and flexible database applications. The ODAC library is implemented using optimized code and advanced data access algorithms. Component interfaces undergo comprehensive performance tests and are designed to help you write thin and efficient product data access layers. Key Features include: - Direct access to server data. Does not require the 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, LCL...

Oracle Data Access Components Pricing

Now three pricing plans Standard, Professional, and Professional with Source Code are available. Initial purchase includes an annual subscription. When purchasing a subscription, you immediately get a perpetual license for the version available at the time of the subscription expiration. Your purchase is risk-free as includes a 60-day money-back guarantee. If you are not satisfied with the product, we will give you your money back.

Starting price: 

$199.95 one time

Free trial: 

Available

Free version: 

Not Available

Oracle Data Access Components dataset manager

Oracle Data Access Components Reviews

Overall Rating

4.7

Ratings Breakdown

Secondary Ratings

Ease-of-use

5

Customer Support

4.5

Value for money

4.5

Functionality

4.5

Most Helpful Reviews for Oracle Data Access Components

1 - 5 of 11 Reviews

Michael

Computer Software, 1 employee

Used monthly for more than 2 years

Review Source: Capterra

OVERALL RATING:

5

EASE OF USE

5

VALUE FOR MONEY

5

CUSTOMER SUPPORT

5

FUNCTIONALITY

5

Reviewed October 2023

Howdy from AdaRocks

The components work well for me.

PROS

Connection without client libraries for prototyping purposes. Help included.

CONS

Honestly, no idea. The components work well.

Reason for choosing Oracle Data Access Components

Since the main focus is still prototyping Delphi is still preferred but not a must. Compared to other Oracle data access component packages or libraries ODAC is very complete. But depending on the Delphi version installed I still use Allround Automations DOA as a gotten to love relic from the past originally introduced to figure out connection issues with PL/SQL Developer and kept for very much the same reason with SQL Detective and in both cases to investigate loading masses of data into a TDataset descendent plus grids & co. Rewriting existing tools is rather useless but making them work and offering a well educated guess concerning the reason or finding the real cause in advance helped these days, because most tools didn't provide precise environment reports (long long time ago). ODAC is ok and SmartyQuery and such things I still love to a certain degree and the dialog boxes for queries on datasets is good and last but not least the DataSet Manager. In my area Delphi was never an option for developments in industries or similar scenarios and Oracle Java connectors or the .net Connector was required. More relaxed scenarios didn't exist or were already covered by so called standard software.

Vendor Response

Thanks a lot. Your feedback is valuable to us.

Replied January 2024

Milton

Information Technology and Services, 2-10 employees

Used weekly for more than 2 years

Review Source: Capterra

OVERALL RATING:

5

EASE OF USE

4

VALUE FOR MONEY

4

CUSTOMER SUPPORT

5

FUNCTIONALITY

5

Reviewed October 2023

ODAC Evaluation - Excellent

Very challenging to switch from FireDAC due to lack of full compatibility.

PROS

Direct access without the need for OCI and SSH tunnel connection

CONS

t's not entirely compatible with FireDAC, requiring adaptation and even preventing any migration of existing Delphi software already created using FireDAC. Apparently, it does not provide a means to connect to Oracle Autonomous Database (security/tls) in the form of direct access.

Reason for choosing Oracle Data Access Components

I chose ODAC because it seems to be more robust and eliminates OCI and the tunnel, which are not available in FireDAC, for small applications, due to ODAC's incompatibility with FireDAC.

Reasons for switching to Oracle Data Access Components

I attempted to migrate from FireDAC, but it was laborious and encountered many errors due to incompatibility.

Vendor Response

We appreciate you taking the time to let us know about your experience!

Replied January 2024

Wassim

Computer & Network Security, 501-1,000 employees

Used daily for more than 2 years

Review Source: Capterra
This review was submitted organically. No incentive was offered

OVERALL RATING:

3

EASE OF USE

4

VALUE FOR MONEY

4

CUSTOMER SUPPORT

3

FUNCTIONALITY

4

Reviewed May 2022

Oracle Data Access Components: A flexible API for programmatically accessing the Oracle Database

PROS

It features easy API calls for creating, managing, and querying Oracle database objects from several programming platforms. I used it with PHP and C#.Net but can also be used in Java, C++, and Python.

CONS

It takes some time to grasp the concepts so the steep learning curve is a bit restrictive for students and beginners.

Vendor Response

Thank you for your feedback. We really appreciate it!

Replied January 2023

Vanderlei

Computer Software, 1 employee

Used daily for more than 2 years

Review Source: Capterra

OVERALL RATING:

5

EASE OF USE

5

VALUE FOR MONEY

5

CUSTOMER SUPPORT

5

FUNCTIONALITY

5

Reviewed October 2023

Odac is excelent!!! Perfect!! The best!!

Easy to use, functional, many features, excellent component

PROS

Easy, functional, never disappoints me, everything has been thought of

CONS

Nothing, the component is perfect, excelent!!

Reason for choosing Oracle Data Access Components

I had contact for many years, and since then I never thought about changing because it suits me 100%

Vendor Response

Thank you. We’re glad to hear you had a great experience with us.

Replied January 2024

Valgardur

Information Technology and Services, 1 employee

Used daily for more than 2 years

Review Source: Capterra

OVERALL RATING:

5

EASE OF USE

5

VALUE FOR MONEY

5

CUSTOMER SUPPORT

5

FUNCTIONALITY

5

Reviewed October 2023

Simple, fast and easy deployment

PROS

Very simple to use, similar MSSQL components, fast, reliable, excellent support - and no Oracle client / setup necessary.

CONS

There are Android language features unresolved for over a year

Reason for choosing Oracle Data Access Components

Direct Access without Oracle Client, fast, similar SDAC

Vendor Response

Thank you for your feedback.

Replied January 2024