Main > Software Development > Components & Libraries >

Universal Data Access Components 2.70


Universal Data Access Components 2.70

Sponsored Links

Universal Data Access Components 2.70 Ranking & Summary

RankingClick at the star to rank
Ranking Level
User Review: 0 (0 times)
File size: 4.65 MB
Platform: Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,W
License: Commercial
Price: $99.95
Downloads: 31
Date added: 2009-06-06
Publisher: Devart

Universal Data Access Components 2.70 description

Universal Data Access Components 2.70 offers you a handy library of nonvisual cross-database data access components for Delphi, Delphi for .NET, and C++Builder. The producer combined the experience of long-term successful development into one product, which provides unified access to the popular database servers like Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, and SQLite.

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.

Using UniDAC with its server-independent interface is the best way to create cross-database applications. UniDAC gives outstanding flexibility and independence to your projects.

Major Advantages:

  1. Universal Data Access
    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 database servers in your cross-database UniDAC-based application.
  2. 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.
  3. Optimized Code
    The goal of UniDAC is to enable developers to write efficient and flexible database applications. The UniDAC library is implemented using advanced data access algorithms and optimization techniques. Classes and components undergo comprehensive performance tests and are designed to help you write high-performance, lightweight data access layers.
  4. Compatibility with Standard Data Access Components
    The UniDAC interface retains compatibility with the standard VCL data access components like BDE. Existing BDE-based applications can be easily migrated to UniDAC and enhanced to take advantage of the server-specific features.

Major Features:

  1. General usability
    • Direct access to server data. Does not require installation of other data provider layers (such as BDE and ODBC)
    • Access without using client library [ Oracle, MySQL, PostgreSQL ]
    • Interface compatible with standard data access methods, such as BDE and ADO
    • VCL and VCL for .NET versions of library available
    • Separated run-time and GUI specific parts allow you to create pure console applications
  2. Unicode support
    • National charset support [ Oracle, MySQL, InterBase, PostgreSQL ]
    • Unified SQL for writing server-independent queries
    • Network and connectivity
    • Disconnected Model 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 ]
    • Connection timeout management [ Oracle, SQL Server, MySQL, PostgreSQL ]
  3. Compatibility
    • Full support of the latest server versions
    • Support for embedded server versions
    • Compatible with all IDE versions starting with Delphi 5 and C++Builder 5, except Delphi 8, and with Free Pascal [New]
    • 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
  4. Server-specific features
    • Oracle
      • Multiple Oracle Homes support
      • Oracle sequence support
      • Direct LOB access support
      • Temporary LOB management routines
      • Temporary LOBs for updating LOB fields
      • OCI Connection Pooling and Statement Caching
      • Oracle optimizer control
      • CLIENT_IDENTIFIER support
    • SQL Server
      • Possibility to change application name for a connection
      • Possibility to change workstation identifier for a connection
      • Configuration of OEM/ANSI character translation
      • Enhanced support for SQL Server Compact Edition
    • MySQL
      • HANDLER syntax support
      • Possibility to retrieve last auto-incremented value
    • InterBase/Firebird
      • Advanced BLOB support
      • Streaming (non-caching) BLOB access support
      • Advanced generator support
      • Advanced support for the character set OCTETS
      • Support for the Firebird 2 EXECUTE BLOCK syntax
      • Support for the Firebird 2 RETURNING clause
      • Advanced locking for Firebird 2
      • Automatic updates by DB_KEY unique field for Firebird 2
      • Multiple transactions support with the TUniTransaction component
    • PostgreSQL
      • Advanced sequences support
      • Advanced Large Objects support
      • Ability to control Fetch block size
      • Returning result sets from stored procedures
      • SSL support
  5. Performance
    • 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
  6. Local data storage operations
    • 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
  7. Data access and data management automation
    • Automatic data updating with TUniQuery, TUniTable, and TUniStoredProc components
    • Automatic record refreshing and locking
    • Automatic query preparing
    • Support for ftWideMemo field type in Delphi 2006 and higher
  8. Extended data access functionality
    • Separate component for executing SQL statements
    • Simplified access to table data with TUniTable component
    • Ability to retrieve metadata information with TUniMetaData component
    • BLOB compression support
    • Support for using macros in SQL
    • FmtBCD fields support
    • Ability to customize update commands by attaching external components to TUniUpdateSQL objects
    • Deferred detail DataSet refresh in master/detail relationships
    • MIDAS technology support
    • UniDataAdapter component for WinForms and ASP.NET applications
    • Distributed transactions support with the TUniTransaction component [ Oracle, SQL Server ]
    • Default value support for stored procedures
    • RefreshQuick method [ SQL Server, MySQL ]
    • Fast record insertion with TUniLoader component
  9. Data exchange
    • Transferring data between all types of TDataSet descendants with TCRBatchMove component
    • Data export and import to/from XML (ADO format)
    • Ability to synchronize positions in different DataSets
    • Extended data management with TUniDump component
  10. Script execution
    • Advanced script execution features with the TUniScript component
    • Support for executing individual statements in scripts
    • Support for executing huge scripts stored in files with dynamic loading
    • Ability to use standard clients tool syntax in scripts
  11. SQL Execution monitoring
    • Extended SQL tracing capabilities provided by the TUniSQLMonitor component and DBMonitor
    • Borland SQL Monitor support
    • Ability to send messages to DBMonitor from any point in your program
  12. Visual extensions
    • Includes the source code of enhanced TCRDBGrid data-aware grid control
    • Customizable connection dialog
  13. Design-time enhancements
    • DataSet Manager tool to control DataSet instances in the project
    • Advanced design-time component and property editors
    • Automatic design-time component linking
    • Easy migration from BDE and ADO with Migration Wizard
    • More convenient data source setup with the TUniDataSource component
    • Syntax highlighting in the design-time editors
  14. Product clarity
    • Complete documentation sets
    • Printable documentation in PDF format
    • A large amount of helpful demo projects
    • Licensing and support
    • Included annual UniDAC Subscription with Priority Support
    • Licensed royalty-free per developer, per team, or per site


SQLite support added:

  • Support for all commonly used data types
  • Possibility to retrieve last auto-incremented value

Universal Data Access Components 2.70 Screenshot

Universal Data Access Components 2.70 Keywords

Bookmark Universal Data Access Components 2.70

Hyperlink code:
Link for forum:

Universal Data Access Components 2.70 Copyright do not provide cracks, serial numbers etc for Universal Data Access Components 2.70. Any sharing links from, or are also prohibited.

Allok Video Splitter 2.2.0 Review:

Name (Required)
Featured Software

Want to place your software product here?
Please contact us for consideration.

Related Software
IBDAC is a VCL/VCL.NET/CLX component library for fast direct access to InterBase, Firebird, and Yaffil servers from Delphi, C++Builder, and Kylix. Includes full support for server data types and functionality, Disconnected Model and Local failover. Free Download
ODAC is a VCL/VCL.NET/CLX component library for fast direct access to Oracle from Delphi, C++Builder, and Kylix. Includes comprehensive support for Oracle functionality, including Oracle TAF, Advanced Queuing, and distributed transactions. Free Download
SDAC is a VCL/VCL.NET/CLX component library for fast direct access to SQL Server from Delphi and C++Builder. SDAC supports all SQL Server data types and functionality, including MARS, bulk copy operations and reliable messaging. Main advantages include direct access to server data, full support of the latest versions of SQL Server, including Express and Compact editions, advanced local data handling, and optimized code base. Free Download
components for direct connectivity to MySQL. Free Download
.NET Data Access Component will increase your productivity and provide reliability when building your data driven applications Free Download
Microsoft Data Access Components are the key technologies that enable Universal Data Access. They include ActiveX Data Objects (ADO), Remote Data Service (RDS, formerly known as Advanced Data Connecto Free Download
PgDAC is a VCL/VCL.NET component library for fast direct access to PostgreSQL from Delphi, C++Builder, and FreePascal Free Download
Delphis components for access to Oracle 7.3,8 and 8i. Free Download