17 years helping British businesses
choose better software
Universal Data Access Components
What is Universal Data Access Components?
Universal Data Access Components (UniDAC) is a powerful library of nonvisual cross-database data access components for Delphi, C++Builder, and Lazarus (Free Pascal). The UniDAC library is designed to help programmers develop faster and cleaner cross-database applications.
UniDAC is very convenient in setup and usage. It provides a transparent server-independent interface for working with different databases. Selecte database provider ensures the best way to perform operations on the server.
Who Uses Universal Data Access Components?
Universal Data Access Components is widely used by software developers and software development companies, that build their applications using Delphi, C++ Builder, and Lazarus.
Not sure about Universal Data Access Components?
Compare with a popular alternative
Universal Data Access Components
Reviews of Universal Data Access Components
One way to differents SGBD
Comments: We appreciate this very good product
Pros:
Easy to use in the Delphi spirit : drag and drop objets, link them and use them
Cons:
Parameters and options on ServerConnection and providers are difficult to understand.Need more exemples.
Devart Response
last year
Thanks a lot. Your feedback is valuable to us.
Complete Solution In A Single Package
Pros:
Having a one-stop, all in one solution that supports a wide variety of data sources makes for a cleaner solution and easier maintenance.
Cons:
Most of the features I need / use are available, so really nothing to say here.
Devart Response
last year
Thank you for your feedback. We really appreciate it!
Easy and fast to use
Pros:
one of the few software solutions on the market that has done what it was designed to do without any problems and without errors right from the start. Microsft should take a look here ;-)
Cons:
TPgDump component does not provide functionality to backup only some columns/datafields of a table (postgres) and then to only restore these values without restoring all the other existing and possible newer and essential content.
Devart Response
2 years ago
Thank you so much for your feedback! We do really appreciate it.
Super good component
Comments: Until this moment great.
Pros:
What I like most about this component is the simplicity and speed it has with the database.
Cons:
At first I can't complain about this component, I'm just starting to use it, so I don't have all the knowledge about it
Devart Response
5 months ago
We are so grateful for your review.
Best DB components every Delphi developer should use!
Pros:
My different DB connectorsComponents in general
Cons:
DB synchronization featuresDemo examples
Devart Response
last year
Thank you for your feedback.
The best component for data access for Delphi
Comments: I have been using UNIDAC for several years and have never had problems.
Pros:
Compatibility with most databases. Excellent performance and features. Fast and efficient user support.
Cons:
It requires adapting the application to proprietary components, but this is an operation that can be performed quickly.
Devart Response
last year
Thank you. We’re glad to hear you had a great experience with us.
Hygeia Unidac
Pros:
Easy Connectivity on diff database Schema
Cons:
Easy on use, very strong stability on connection life
Devart Response
last year
Thank you so much for your feedback!
Using for 10 years and has been the most reliable data tier since BDE.
Comments: We have been able to contact support and gotten a night build change to access Oracle when they changed to allow an off site redundant server configuration.
Pros:
The software has built in code to access database servers directly. For example, you can write a single EXE that can access an Oracle database WITHOUT Oracle intalled. They have the code for OCI built in. Yes, you can use OCI and OLE DB and ODBC and hit 20 other databases with the same code. Of course you can access MsSql the same way. What does this give you?? You can make an Android app that connects direct to a Mssql database over the internet. Maybe you will do REST services later, but quickly make an awesome app.
Cons:
I don't like that they didn't give me a job offer.
Devart Response
2 years ago
Thank you so much for your feedback! We do really appreciate it.
Exellent product
Pros:
access to all DB in one product with native drivers very quick access
Cons:
i have small problems with direct mode to connect with oracle DB
Devart Response
2 years ago
Thank you so much for your feedback!
Everityng ok
Pros:
Use one connection for all databases and use always it
Cons:
Improve a data dictionary and a Er Diagram (like entity dac)
Devart Response
2 years ago
Thank you so much for your feedback!
UNIDac - A component to access all databases
Comments: I use this component in order to connect different databases for transferring data from one to another
Pros:
Easy to use and suitable for many databases
Cons:
Sometimes I've had problems with DB2/400
Devart Response
last year
Thank you for your feedback.
Devart integration w/ Rad Studio 11.3
Pros:
Easy to use, configuration was easier than thought.
Cons:
use of older dbf tech was easy to configure and use.
Devart Response
last year
Thank you for your feedback.
Universal Data Access
Pros:
Pretty easy application development, reliability, excellent functionality.
Cons:
I can't think of anything at the moment.
Devart Response
last year
Thank you so much for your feedback!
I do not understand, what is this field for.
Comments: I't hard for me to admit, that I still do not understand native methods for SQL databases connectivity in Delphi. I'm useing DAC components from very beginning.
Pros:
Very easy to install, easy to use, reliable.
Cons:
Problem with datetime2 field type in MSSQL, it should have automatic conversion to TDateTime. Problem with setting NULL values in INSERT or UPDATE query with params.
Devart Response
last year
We are so grateful for your review.
Unidac Review
Pros:
Direct Acess to databases. Not needing drivers and concentrating all connection demands on the executable is what makes UNIDAC different for me. As far as I've seen, the native options for Delphi and C++ need drivers or libraries to work correctly
Cons:
UNIDAC fully supports me and I would only consider a progressive, more aggressive discount percentage during renewal.
Devart Response
last year
Thank you for your feedback. We really appreciate it!
Comprehensive data access layer for Pascal languages
Comments: UniDAC has consistently allowed us to integrate with light and heavy-duty database engines (from SQLite to MongoDB with most of our usage in the PostgreSQL area). It has greatly reduced the effort to market for our products while also saving money by not needing to purchase Delphi Enterprise, Professional is enough thanks to UniDAC.
Pros:
Compatibility with both Delphi and Lazarus/FreePascal. Super-easy to use installer that seems to 'just work' year after year. Abstraction layer to allow easier swapping between back-end database engines.
Cons:
It is called Universal Data Access Components due to the large number of providers which is both a good thing and a bad thing. The negative for our company is that we only use a few providers regularly so the cost can feel burdensome, most notably when the CRM connectors and such were added a few years back. The positive is that without the bundling, we likely wouldn't have tested out such connectors...
Devart Response
2 years ago
We appreciate you taking the time to let us know about your experience! We are always looking for ways to improve.
Good component set for multiple database connection
Comments: In stable versions my experience it is good and let me connect to Oracle and Firebird with one component set, containing the features I need.
Pros:
Using a common set of components to connect to several databases. Pooling it is also a feature I need.
Cons:
Sometimes bug fixes takes much time. New releases introduce bugs that takes time to solve
Devart Response
2 years ago
Thank you so much for your feedback! We do really appreciate it.
UniDAC the definitive solution to data access in Delphi
Comments: By developing server applications thanks to uniDAC my systems are always very performing and easily adaptable to new specifications
Pros:
I'ts fast, simple and very productive! Is the best in the Delphi world components. I use it for many years
Cons:
only the DBMonitor application which is an excellent analysis and log tool but would need some additional functionality
Devart Response
2 years ago
We are so grateful for your review.
Solid data access components with good support
Comments: Using UniDac makes writing multi-user database applications , across a range of databases, quick and easy without sacrificing performance or usability.
Pros:
It is straightforward to use, reliable, and gives me access to every feature I need when writing database connected applications, large and small. It plays nice with the other 3rd party components we use such as DevExpress and Fast report etc, and it well documented.
Cons:
Some of the dialogues can be a little clunky but the developer is very responsive.
Devart Response
2 years ago
Thanks a lot. Your feedback is valuable to us.
The easy way to program tools for data management
Comments: I make many little helpful tools, for managment database typelabel , create QS-Certificat for my customer my customer use as ERP-system Microsoft Dynamics, all Process which cannot be mapped cost-effectively,That is the point then my programs will be used
Pros:
Programs need not a driverinstallation , the componenten ussing is very easy you have free choise of database like as slq,mysql,access and variable change
Cons:
I missing special fastreport components as 64-bit version,because this I can not change my Programs to 64-Bit, otherwise I am very satisfied
Devart Response
2 years ago
We appreciate you taking the time to let us know about your experience! We are always looking for ways to improve.
Very useful for various DB Architectures
Comments: We were able to easily migrate from our old Data Access software to UniDAC.
Pros:
We especially like the ease of adapting our software to using the different database environments (Interbase/Firebird, Microsoft SQL, etc) that are used by our clients. Also the opportunity to purchase the source code is very helpful .
Cons:
There is nothing I do not like. The Software does everything we need in our development environment.
Devart Response
2 years ago
We are so grateful for your review.
The VCL for several database access
Pros:
Easy to use, look like the BDE ... Several database engine supported.
Cons:
No things wrong in this suite. All is ok... In the future May be a remote database tools for Json could be nice...
Devart Response
2 years ago
Thank you for your feedback. We really appreciate it!
Very good product
Pros:
Ease of use and reliability in operation. Haven't encountered any problems so far
Cons:
I find it difficult to answer. As long as I'm satisfied
Devart Response
2 years ago
Thank you for your feedback. We really appreciate it!
Easy access to all important datasources from Delphi-programs
Comments: Very good performance of the components, support for the current releases of the database software
Pros:
direct access to Oracle and Sqlite and some other databases
Cons:
the only feature i miss at Universal Data Access Components is a provider for Paradox-Tables
Devart Response
2 years ago
Thanks a lot. Your feedback is valuable to us.
Finally a way to properly replace the BDE without relying on shaky OleDB support
Pros:
It's a solution that allows us to connect to many databases without needing to use drivers that may be missing from the end user computer. Anyone who worked with Oracle knows how painful it can be to install their data access layer, Unidac allows us to never bother with this again.
Cons:
It requires replacing existing components, but it's close enough to them that a simple DFM editing is often enough.
Devart Response
2 years ago
Thanks a lot. Your feedback is valuable to us.