Universal Data Access Component
Universal Data Access Component (UniDAC) is a library of components that can directly access multiple databases from Delphi and C++Builder (including Community Edition), as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android, suitable for 32-bit and 64-bit platforms.
database
- Oracle
- SQL Server
- SQL Azure
- Firebird
- InterBase
- MySQL
- PostgreSQL
- SQLite
- MongoDB
- DBF
Cloud based
- Salesforce
- QuickBooks
- Netsuite
- SugarCRM
- Zoho CRM
Unified connectivity solution
UniDAC provides a transparent interface independent of the server for handling different databases and allows you to change the client engine for a specific server type simply by changing a single connection option. This means that you can easily switch between different database servers in UniDAC based cross database applications.
The advantages of UniDAC technology
UniDAC is easy to set up and use. It provides a transparent interface independent of the server for handling different databases. The selected database provider ensures the best method for performing operations on the server.
Server aware provider
UniDAC selects the server specific best way to perform most operations. Each UniDAC data provider uses server-specific native connections. The provider automatically considers the characteristics of the selected database server and performs all operations on the data.
Cross platform solution for Delphi, C++Builder, and Lazarus
UniDAC is a cross platform solution for developing applications using various IDEs: RAD Studio, Delphi, C++Builder, Lazarus (and FPC) on Windows, macOS, Linux, iOS, and Android, suitable for x86 and x64 platforms. UniDAC also provides support for the FireMonkey platform, which allows you to develop visually appealing high-performance desktop and mobile native applications.
Server independent SQL
One of the key points in developing database applications that allow for the use of multiple databases is to write SQL independent of the server. In UniDAC, server independent SQL support is achieved through a powerful macro engine, which generates dynamic SQL by replacing a portion of a query statement with user-defined code.
Accessing Cloud Services
UniDAC allows the development of applications for use with data stored in the following cloud services: BigCommerce, Dynamics CRM, FreshBooks, Magento, MailChimp, NetSuite, Salesforce, Salesforce MC, SugarCRM, QuickBooks, Zoho CRM. To achieve this, it is sufficient to use the UniDAC ODBC provider in conjunction with any Devart ODBC driver for Cloud.
Secure connection
You can use the SecureBridge component with the data access component to embed SSL, SSH, or HTTP/HTTPS clients into your application to establish a secure connection with the server.
Product Features
Allow you to directly use Oracle, SQL Server, MySQL, PostgreSQL, SQLite, Redshift, ASE, DBF, and NexusDB without the need for the DB Client library, greatly simplifying application deployment and configuration.
The development of iOS and Android mobile devices using UniDAC has become easier, as UniDAC allows your mobile applications to use multiple databases like desktop applications.
Our product supports the latest versions of popular database servers, such as Oracle, SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite, and other databases (using the ODBC provider)
Our product is compatible with the latest IDE versions, including community versions: Embarcadero RAD Studio 10.4 Sydney, Delphi 10.4 Sydney, C++Builder 10.4 Sydney, Lazarus (and FPC).
If you want to customize the mapping between server and Delphi data types, you can use the simple and flexible data type mapping engine provided by UniDAC.
Support all major GUI frameworks: develop VCL applications for Windows or cross platform FMX applications in Delphi, and LCL applications for Windows, macOS, or Linux in Lazarus.
All our components and libraries are designed to help you write a high-performance, lightweight data access layer, so they use advanced data access algorithms and optimization techniques.
Use our freeware dbMonitor tool to monitor and analyze all database calls made by your application using UniDAC. DbMonitor executes SQL statement execution, submission, rollback, and other component based tracking.
Please visit our support page for instant assistance from experienced professionals to quickly resolve your issues and build patches every night.
Universal Data Access Components UniDac Data Access Component Library Tool
