Universal Data Access Components Universal Data Access Components

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提供程序)。

UniDAC提供統一的數據庫相關應用程式開發流程。這意味著您可以輕鬆地在項目中的不同數據庫之間進行切換,而無需深入了解它們的具體情況,以及與服務器無關的接口而建立跨數據庫應用程式。


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 operations
  • 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, FastReport
  • 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 applications


表現


  • 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