Universal Data Access Components (UniDAC) is a library of components that provides direct access to multiple databases from Delphi, C++Builder, Lazarus (and Free Pascal) on Windows, macOS, Linux, iOS, and Android for both 32-bit and 64-bit platforms. We have combined the experience of long-term successful development into one product, which provides unified access to multiple database servers like Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite, DB2, Microsoft Access, SAP Sybase Advantage Database Server, SAP Sybase Adaptive Server Enterprise, Amazon Redshift, and others (using ODBC provider), as well as various Cloud services.
UniDAC offers unified approach to the database-related applications development process. That means you can switch easily between different databases in your projects without going deep into their specifics as well as create cross-database applications due to server-independent interface.
Unified Connectivity Solution
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 single connection option. It means that you can easily switch between different database servers in your cross-database UniDAC-based application.
Advantages of UniDAC Technology
UniDAC is easy to setup and use. It provides transparent server-independent interface for working with different databases. Selected database provider ensures the best way to perform operations on the server.
UniDAC chooses the best way specific to the server to perform most operations. Every UniDAC data provider uses server-specific native connectivity. All operations with data are performed by providers automatically considering the selected database server peculiarities.
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, Android, and FreeBSD for both x86 and x64 platforms. UniDAC also provides support for the FireMonkey platform, which allows you to develop visually spectacular high-performance desktop and mobile native applications.
When developing database applications that allow working with several databases, one of the key points is writing of server-independent SQL. In UniDAC, the server-independent SQL support is implemented by means of the powerful macros engine, producing dynamic SQL by replacing parts of the query statements with user-defined code.
Access Cloud Services
UniDAC allows developing applications that work with data stored in such Cloud services as: BigCommerce, Dynamics CRM, FreshBooks, Magento, MailChimp, NetSuite, Salesforce, Salesforce MC, SugarCRM, QuickBooks, Zoho CRM. For this, it is enough to use UniDAC ODBC provider with any Devart ODBC drivers for Clouds.