Universal Data Access Components 資料庫開發工具

Universal Data Access Components是一套群昱公司代理的資料庫開發工具,提供開發者可在Windows,Mac OS X,iOS,Android上從Delphi,C ++ Builder,Lazarus(和Free Pascal)直接訪問多個數據庫。

Universal Data Access Components

Universal Data Access Components (UniDAC)是一個元件庫,提供從Windows,Mac OS X,iOS,Android,Linux和FreeBSD上的Delphi,C ++ Builder,Lazarus(和Free Pascal)直接存取多個數據庫的32位和64位平台。我們將長期成功開發的經驗整合到一個產品中,提供對Oracle,Microsoft SQL Server,MySQL,InterBase,Firebird,PostgreSQL,SQLite,DB2,Microsoft Access,SAP Sybase Advantage數據庫伺服器等多種數據庫伺服器的統一存取。SAP Sybase Adaptive Server Enterprise和其他(使用ODBC提供程序)。


Unified Connectivity Solution

UniDAC為不同的數據庫提供透明的獨立於伺服器的接口,並且可以通過更改單個連接選項來更改特定伺服器類型的客戶端引擎 這意味著您可以在跨數據庫基於UniDAC的應用程式中輕鬆切換不同的數據庫伺服器。

Universal Data Access Components.png

Universal Data Access Components Features


  • Direct access to server data. Does not require installation of other data provider
    layers (such as BDE)
  • Access without using client library [ Oracle, SQL Server, MySQL, PostgreSQL, SQLite, DBF ]
  • Interface compatible with standard data access methods, such as BDE and ADO
  • VCL, LCL and FMX versions of library available

  • Separated run-time and GUI specific parts allow you to create pure console applications
    such as CGI
  • Unicode support
  • National charset support [ Oracle, MySQL, InterBase, PostgreSQL ]
  • Unified SQL for writing server-independent queries
  • Highly usable design time support
  • Easy to deploy


  • Disconnected Mode with automatic connection control for working with data offline

  • Local Failover for detecting connection loss and implicitly reexecuting certain

  • Ability to search for installed servers in a local network

    [ SQL
    Server, MySQL, PostgreSQL ]

  • Connection timeout management

    [ Oracle, SQL Server, MySQL,
    PostgreSQL, ODBC  ]

  • Support for OS authentication
  • Support for Proxy Authentication
  • Support for the change expired password
  • Support for both IPv6 and Ipv4 protocol


  • Full support of the latest server versions
  • Support for embedded server versions
  • Compatible with Delphi 6, 7, C++Builder
    6, Borland Delphi Studio 2006, Code Gear RAD Studio 2007, 2009,
    Embarcadero RAD Studio 2010, XE, XE2, XE3, XE4, XE5, XE6, XE7, XE8,
    Seattle, Berlin, Tokyo
  • Support for Lazarus 1.6.4 and FPC 3.0.2 for Windows, MacOS and Unix

  • Wide reporting component support, including support for InfoPower, ReportBuilder,
  • Support for all standard and third-party visual data-aware controls

  • Allows you to use Professional Edition of Delphi and C++Builder to develop client/server


  • High overall performance
  • Fast controlled fetch of large data blocks
  • Optimized string data storing
  • Advanced connection pooling
  • High performance of applying cached updates with batches
  • Caching of calculated and lookup fields
  • Fast Locate in a sorted DataSet
  • Preparing of user-defined update statements

  • High performance batch processing

  • Intelligent fetch block size control

  • Advanced connection pooling

  • SmartFetch Mode enabling fast bi-directional navigation through large datasets


  • Database-independent data storage with TVirtualTable component
  • CachedUpdates operation mode
  • Local sorting and filtering, including by calculated and lookup fields
  • Local master/detail relationship
  • Master/detail relationship in CachedUpdates mode

Supported Target Platforms

  • Windows, 32-bit and 64-bit

  • MacOS

  • iOS, 32-bit and 64-bit

  • Android

  • Linux, 32-bit and 64-bit

  • FreeBSD, 32-bit and 64-bit