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