About Universal Data Access Components (UniDAC)

A library of components that provides direct access to multiple databases from Delphi and C++Builder.

Universal Data Access Components (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.

Universal Data Access Components (UniDAC) provides unified access to:

Databases

  • Oracle
  • SQL Server
  • SQL Azure
  • Firebird
  • Interbase
  • MySQL
  • PostgreSQL
  • SQLite
  • MongoDB
  • DBF
  • ...and more

Clouds

  • Salesforce
  • QuickBooks
  • Netsuite
  • SugarCRM
  • Zoho CRM
  • ...and more

Features

  • 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.
  • Server-Aware Providers - 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.
  • Server-Independent SQL - 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 Cloud.

Editions

  • The Standard edition includes the UniDAC common engine and data providers.
  • The Professional edition shows off the full power of UniDAC, including: mobile application development, data encryption, and additional components for work with databases, such as TUniAlerter, TUniDump, TUniMetaData, TCRBatchMove, etc. The Proffessional Edition also includes Direct Mode for Oracle, SQL Server, MySQL, PostgreSQL, and Static Library Linking - for SQLite. In addition, UniDAC Professional Edition includes the DataSet Manager tool which is intended to organize datasets in your application.
  • You can get Source Access to the UniDAC Professional Edition by purchasing the special UniDAC Professional Edition with source code. The Professional Edition with source code includes the source code for all component classes. The source codes of DataSet Manager and Migration Wizard are not distributed. The source code of Oracle, SQL Server Direct Mode is distributed obfuscated, and SQLite Direct Mode - as precompiled packages.