# Universal Data Access Components Reviews **Vendor:** Devart **Category:** [Other IT Infrastructure Software](https://www.g2.com/categories/other-it-infrastructure) **Average Rating:** 4.7/5.0 **Total Reviews:** 19 ## About Universal Data Access Components Universal Data Access Components (UniDAC) is a library of components that provides direct access to multiple databases from Delphi and C++Builder including Community Edition, as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms. One product that provides unified access to multiple databases and cloud applications: Oracle, SQL Server, SQL Azure, Firebird, MySQL, PostgreSQL, SQLite, Salesforce, QuickBooks, etc. UniDAC provides transparent server-independent interfaces for working with different databases and lets you change the client engine for a specific server type just by changing the single connection option. It means that you can easily switch between different database servers in your cross-database UniDAC-based application. ## Universal Data Access Components Reviews ### 1. Fast and stable native level SQL driver. **Rating:** 5.0/5.0 stars **Reviewed by:** Bruce C. | Senior Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** November 23, 2022 **What do you like best about Universal Data Access Components?** Fast and stable native-level SQL driver. We use it for our medical software products to ensure reliability and speed. **What do you dislike about Universal Data Access Components?** Nothing! Works well and as expected and stable. **What problems is Universal Data Access Components solving and how is that benefiting you?** Provided a stable driver to access SQL data over a range of product releases. **Official Response from Jordan Sanders:** > Thank you for your feedback. We really appreciate it! ### 2. My go-to database connectivity toolkit **Rating:** 5.0/5.0 stars **Reviewed by:** James G. | Director, Small-Business (50 or fewer emp.) **Reviewed Date:** February 03, 2022 **What do you like best about Universal Data Access Components?** Ease of use, connection to a wide range of database platforms, a vibrant and active user community and excellent technical support. There are also regular update releases. I have used the product for more years than I care to think about, with virtually every release of Delphi there is, and it has never let me down. **What do you dislike about Universal Data Access Components?** There is little to dislike as compared to all the other equivalent component sets out there, it is the best by a long way, in my opinion of course ;) **What problems is Universal Data Access Components solving and how is that benefiting you?** I have used Unidac in a variety of applications written over the years. Key highlights include a marketing database for a window manufacturer that evolved into a complete manufacturing and quality control system and the upgrade of a systems management application running in an aluminium smelting works. I have used the product running against SQL Server, MySQL, SQLite, Oracle & Progress, and it is straightforward to take a program and reconfigure it to run against a different database platform. **Official Response from Jordan Sanders:** > Thank you so much for your feedback! We do really appreciate it. ### 3. The best Database connection components **Rating:** 5.0/5.0 stars **Reviewed by:** Nikola N. | Senior Software engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** March 05, 2021 **What do you like best about Universal Data Access Components?** First of all, I like that all supported databases work in a universal way. Second, that for each type of database you can work with specific parameters. Third, the freedom and full control by the developer of the requests sent to the database. Fourth, the lack of configurations in strange places and external INI files. Last but not least, a good set of assistants for fast request writing, monitoring and debugging of SQL. **What do you dislike about Universal Data Access Components?** I would like a slightly more detailed help system with more examples of the most common problems when working with different databases with these components. **What problems is Universal Data Access Components solving and how is that benefiting you?** Each client wants a different database by default. These components help me get started on any new project quickly and seamlessly without having to learn how to work with this new database. **Official Response from Jordan Sanders:** > Thank you. We’re glad to hear you had a great experience with us. ### 4. UniDAC to Postgresql **Rating:** 4.5/5.0 stars **Reviewed by:** Nols S. | Remote analist software developer, Small-Business (50 or fewer emp.) **Reviewed Date:** March 04, 2021 **What do you like best about Universal Data Access Components?** I've written a Delphi program, accessing a spatial Posgresql database where all the tables are spatially joined and the look ups are spatial queries using PostGIS sd-functions. With parallel processing on a i7 PC (4 core, 8 threads), I achieved reading 214 000 records per second to process 19 Billion seismic records in 4 hrs and 36 minutes. **What do you dislike about Universal Data Access Components?** I may be forced to use FireDAC. I hope I will achieve the same look up speed. **What problems is Universal Data Access Components solving and how is that benefiting you?** I like the reliability and ease of using UniDAC drivers. **Official Response from Jordan Sanders:** > We are so grateful for your review. ### 5. Excellent alternative to Borlands DAC **Rating:** 5.0/5.0 stars **Reviewed by:** Gord B. | Mid-Market (51-1000 emp.) **Reviewed Date:** November 06, 2020 **What do you like best about Universal Data Access Components?** There are two things that I like the most with UniDAC. The first is the compatibility with the existing controls. Aside from some minor differences that are well documented, using these controls is just as easy as using the existing connectors. I use the Professional Version of Delphi, which doesn't contain connectors to MS-SQL, as that is part of the Enterprise version which is vastly more expensive. The UniDAC components bring that functionality, without the obscene price. **What do you dislike about Universal Data Access Components?** I can honestly say that there isn't anything I really dislike about this product. It does what it says, and does it quickly. **Recommendations to others considering Universal Data Access Components:** They are constantly updating these, and are providing support. I would strongly recommend you get these. **What problems is Universal Data Access Components solving and how is that benefiting you?** I solved the lack of MS-SQL access with this, and the benefit is that my wallet still has money in it! **Official Response from Jordan Sanders:** > Thank you. We’re glad to hear you had a great experience with us. ### 6. Great product with excellent support **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Industrial Automation | Small-Business (50 or fewer emp.) **Reviewed Date:** July 12, 2020 **What do you like best about Universal Data Access Components?** Direct database access without having to install clients or libraries. Very powerful and easy to use. **What do you dislike about Universal Data Access Components?** Would like to see the option to use multiple connections pools and have a lower level layer allowing to retrieve data without being descendant from TDataset **What problems is Universal Data Access Components solving and how is that benefiting you?** It makes it simple connecting to database without spending too much time installing libraries or even figuring out how to connect to database. There is no headache when deploying your application. Many free alternatives require you to spend a good amount of time trying to figure out how to connect to a database. **Official Response from Jordan Sanders:** > We are so grateful for your review. ### 7. Excellent component and trouble free operation **Rating:** 4.0/5.0 stars **Reviewed by:** Torben J. | Mid-Market (51-1000 emp.) **Reviewed Date:** July 10, 2020 **What do you like best about Universal Data Access Components?** The components are very easy to use, and it's simple to get data they way you need it. Once it's clear which elements to add, connecting to database servers is problem free. It's excellent that no external DLLs are needed when connecting to databases. **What do you dislike about Universal Data Access Components?** The documentation could be improved, especially for not-so-experienced programmers. I often missed examples / snippets of how to operate different elements, answers that could be found in various forum posts (good that you have this available!), but snippets from forums should be merged into documentation at relevant places. That would be a great help. Creating documentation takes time, perhaps it would be an idea to create a "bounty" program where good user-created documentation videos could be integrated into the site, and the user (validated) could be offered discounts or "earn" licenses for products. It's probably cheaper to give out licenses than hire people to create documentation. Point 2: it would be great to have a DEMO version of the full UDAC, including data providers. Even if these demo versions would only allow to get 5 records and work 30 days. **Recommendations to others considering Universal Data Access Components:** Consider the time saved looking for various DLLs on open-source options. **What problems is Universal Data Access Components solving and how is that benefiting you?** Connecting to MySQL and SQLite servers. It's much simpler to have ONE component to do it all, and not depend on open-source libraries, where there is a constant search for the just-correct DLL which must be included with the software. Especially MySQL DLLs are hard to find these days. UDAC are much simpler. **Official Response from Jordan Sanders:** > We appreciate you taking the time to let us know about your experience! We are always looking for ways to improve. ### 8. Best for Migration from Legacy **Rating:** 5.0/5.0 stars **Reviewed by:** Sebastian D. | Mid-Market (51-1000 emp.) **Reviewed Date:** November 06, 2020 **What do you like best about Universal Data Access Components?** Most useful Feature is the Migration Assistent **What do you dislike about Universal Data Access Components?** Hard to say, because I didn't got any problems using UNIDAC with Delphi in my projects. **Recommendations to others considering Universal Data Access Components:** Check the trial version and check out the Devart forum. It is very good and you will get insight in the lively community and the great support. **What problems is Universal Data Access Components solving and how is that benefiting you?** Migration of old Delphi 7 Dbase ADO Code to current Version of Delphi with a Database Migration to SQLite, MS Access, SQL Server etc **Official Response from Jordan Sanders:** > Thank you so much for your feedback! ### 9. True native direct DB access component. **Rating:** 4.5/5.0 stars **Reviewed by:** Haizhou T. | Small-Business (50 or fewer emp.) **Reviewed Date:** November 06, 2020 **What do you like best about Universal Data Access Components?** The most important feature of UniDAC is the direct access to several DB without extra supporting files. It is true direct access rather than wrapping or going through .DLL file. It make the final product more efficient and project more economic. **What do you dislike about Universal Data Access Components?** Needs more fine tune with error message catching. **What problems is Universal Data Access Components solving and how is that benefiting you?** I am developing cross platform APPs. It works well on Windows, Mac OS, andriod and iOS. Brill. **Official Response from Jordan Sanders:** > Thanks a lot. Your feedback is valuable to us. ### 10. Easy and powerfull ! **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Government Administration | Small-Business (50 or fewer emp.) **Reviewed Date:** March 03, 2021 **What do you like best about Universal Data Access Components?** The number of database engine supported. The simple way to use the VCL. The fast result. **What do you dislike about Universal Data Access Components?** Nothing ! It's the best DAC library I've bought ! **What problems is Universal Data Access Components solving and how is that benefiting you?** Same code for different database engine : I can change the database engine, without changing my code ! **Official Response from Jordan Sanders:** > Thank you. We’re glad to hear you had a great experience with us. ### 11. A good component set for database connection **Rating:** 4.5/5.0 stars **Reviewed by:** Jesús G. | Small-Business (50 or fewer emp.) **Reviewed Date:** November 06, 2020 **What do you like best about Universal Data Access Components?** Simplicity for connecting to different databases **What do you dislike about Universal Data Access Components?** Sometimes, when I upgrade, the Oracle driver fails working with Oracle RAC, and the resolution takes longer **What problems is Universal Data Access Components solving and how is that benefiting you?** My applicatton can connect to several engines. My main benefit is simplicity to connect to different database engine. **Official Response from Jordan Sanders:** > Thank you so much for your feedback! ### 12. Consistent, reliable DAC year after year **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** July 09, 2020 **What do you like best about Universal Data Access Components?** The reliability and quality of the code. The wide-ranging DBMS support has been great and again consistent throughout the years. **What do you dislike about Universal Data Access Components?** The increase in cost when API providers were added doesn't help my current business but I understand how it could very well be extremely valuable. **What problems is Universal Data Access Components solving and how is that benefiting you?** Delphi Professional database server access. Delphi Professional does not come out of the box with support for anything except locally installed databases like SQLite. UniDAC removes that gap without needing to move up to the Enterprise variant of Delphi. The first code I wrote against UniDAC in 2009 compiles today with the current UniDAC release. That stability has saved a tremendous amount of labor. When leveraging UniDAC, our solutions have fewer bugs as a result of UniDAC's quality. **Official Response from Jordan Sanders:** > Thank you for sharing your experience with us. Your feedback helps us to improve service for everyone. ### 13. The perfect component for those who need to connect to multiple DBMS **Rating:** 5.0/5.0 stars **Reviewed by:** Samuel N. | Small-Business (50 or fewer emp.) **Reviewed Date:** July 09, 2020 **What do you like best about Universal Data Access Components?** Ease of implementation, excellent performance and efficient technical support. Connection almost all DBMS (SQL Server, Oracle, MySQL, Firebird, InterBase, NexusDB, PostgreSQL, SQLIte, etc). Compatibility with Windows, iOS, macOS and Android. When an Embarcadero releases new versions of Delphi, in a few weeks Devart releases a version compatible with the new version. **What do you dislike about Universal Data Access Components?** I can't imagine anything that I dislike about Unidac. **Recommendations to others considering Universal Data Access Components:** Analyze all functionality before starting development, especially macros as they can reduce development time **What problems is Universal Data Access Components solving and how is that benefiting you?** With the UNIDAC I was able to connect my application to several other ERPs, easily and quickly. **Official Response from Jordan Sanders:** > Thank you. We’re glad to hear you had a great experience with us. ### 14. Great components to access DB **Rating:** 4.5/5.0 stars **Reviewed by:** MARCOS G. | Mid-Market (51-1000 emp.) **Reviewed Date:** July 10, 2020 **What do you like best about Universal Data Access Components?** Above all, the frequency of updates, the support and the stability of the product **What do you dislike about Universal Data Access Components?** Nothing remarkable. I use the components and I like develop with them. **Recommendations to others considering Universal Data Access Components:** Great components to work with. **What problems is Universal Data Access Components solving and how is that benefiting you?** Development of database intensive applications in my company **Official Response from Jordan Sanders:** > Thanks a lot. Your feedback is valuable to us. ### 15. Great product **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Banking | Small-Business (50 or fewer emp.) **Reviewed Date:** November 06, 2020 **What do you like best about Universal Data Access Components?** Direct access to various types of databases without having to install additional drivers. **What do you dislike about Universal Data Access Components?** nothing, because the product is simple to use and intuitive in a fast way. **What problems is Universal Data Access Components solving and how is that benefiting you?** direct link to Orcale from SQL Server **Official Response from Jordan Sanders:** > We are so grateful for your review. ### 16. Easy to use **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** July 10, 2020 **What do you like best about Universal Data Access Components?** Reliabylity and speed. This is easy to use and easy to use multiple databases **What do you dislike about Universal Data Access Components?** That it has no component for using UNIDAC with Devexpress VCL in server mode like thease Devexpress have for FireDac build in . **Recommendations to others considering Universal Data Access Components:** Speed - easy to use **What problems is Universal Data Access Components solving and how is that benefiting you?** I can from the same application use multiple databases **Official Response from Jordan Sanders:** > We appreciate you taking the time to let us know about your experience! We are always looking for ways to improve. ### 17. UniDAC makes it easy to access MySQL databases from Delphi apps. **Rating:** 5.0/5.0 stars **Reviewed by:** Matthew V. | Owner, Small-Business (50 or fewer emp.) **Reviewed Date:** November 13, 2019 **What do you like best about Universal Data Access Components?** I really like how UniDAC allows you to access MySQL databases without requiring the MySQL client libraries. This is accomplished using what they call Direct Mode. **What do you dislike about Universal Data Access Components?** I have not encountered anything I dislike about UniDAC. **What problems is Universal Data Access Components solving and how is that benefiting you?** I am using UniDAC to access MySQL (as well as MS SQL Server and Interbase) databases from my Delphi applications. **Official Response from Jordan Sanders:** > Thanks a lot. Your feedback is valuable to us. ### 18. It is to have control of all the BD in one place **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Telecommunications | Enterprise (> 1000 emp.) **Reviewed Date:** December 11, 2018 **What do you like best about Universal Data Access Components?** As a DBA it is important to have access to all the databases that we monitor from one place, this tool facilitates direct access to them and the execution of SQL statements for all the database engines, it has documentation, but it is quite intuitive if you find yourself in the database world **What do you dislike about Universal Data Access Components?** Everything good is expensive, the Express version that is to which I could have access, limits the connection with all the engines, as the products must be acquired for each one **Recommendations to others considering Universal Data Access Components:** It is a matter of investing and you will obtain a quality tool that will make your work productive and effective **What problems is Universal Data Access Components solving and how is that benefiting you?** On your own to try **Official Response from Jordan Sanders:** > Thank you so much for your feedback! We do really appreciate it. ### 19. Universal Data Access Components is a Necessity **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** October 17, 2018 **What do you like best about Universal Data Access Components?** The software allows access to multiple platforms, regardless of the type of computer. **What do you dislike about Universal Data Access Components?** There are other options for this on the market and it's not any superior to the others. **Recommendations to others considering Universal Data Access Components:** This is a good product, though not much differentiated from other products like Anyware. It is practical and necessary when using Macintosh computers and Windows. It is quite fast to download and use. **What problems is Universal Data Access Components solving and how is that benefiting you?** This gives the benefit of all being able to access the same software and apps, no matter what computer they have. **Official Response from Jordan Sanders:** > Thank you for letting us know about your experience. We’ll work on improving to meet our customers’ expectations in the future. ## Universal Data Access Components Discussions - [What is universal data access?](https://www.g2.com/discussions/what-is-universal-data-access) - 1 comment - [View Universal Data Access Components pricing details and edition comparison](https://www.g2.com/products/universal-data-access-components/reviews?section=pricing&secure%5Bexpires_at%5D=2026-06-07+10%3A05%3A52+-0500&secure%5Bsession_id%5D=1ca49d95-e502-4d95-92fe-51985af0dfe2&secure%5Btoken%5D=cf66282bd086626aac2ef53d11b175893e7d66d0296c2c12e757df3938287cb2&format=llm_user) ## Top Universal Data Access Components Alternatives - [AWS Cloud Development Kit (AWS CDK)](https://www.g2.com/products/aws-cloud-development-kit-aws-cdk/reviews) - 4.4/5.0 (128 reviews) - [pgAdmin](https://www.g2.com/products/pgadmin/reviews) - 4.1/5.0 (70 reviews) - [AWS Schema Conversion Tool](https://www.g2.com/products/aws-schema-conversion-tool/reviews) - 4.3/5.0 (54 reviews)