1: What does the registration key mean?
A registration key is a one-of-a-kind ID generated by the FME Licensing Assistant from system data. It's Safe's way of limiting a single fixed license to a single computer.
2: What is a registration key number?
A registration key is a code of letters and numbers that allows access to one of the many Thomson Reuters products, such as Westlaw, CLEAR, Firm Central, and more.
3: What is the registration key?
Each person will create an individual user account by entering the customer's account number, an online registration key (available from your local dealer), and basic billing and shipping address information. The account administrator will be the first account created.
By Devart
Universal Data Access Components (UniDAC) is a library of non-visual cross-database data access components for Embarcadero RAD Studio XE, Embarcadero RAD Studio 2010, CodeGear Delphi 2009, C++Builder 2009, CodeGear RAD Studio 2007, Delphi 2007 for Win32, C++Builder 2007, Borland Developer Studio 2006, Delphi 2005, Turbo Delphi, Turbo Delphi for .NET, Turbo C++, Delphi 7,6, C++Builder 6, Lazarus and FreePascal for Win32 and Linux. We combined experience of long-term successful development into one great product, which provides unified access to the popular database servers like Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite and others. Using UniDAC with its server-independent interface is the best way to create cross-database applications. UniDAC brings outstanding flexibility and independence to your projects
Universal Data Access Components
Universal Data Access Components (UniDAC) is a library of components that provides direct access to multiple databases from Delphi and C++Builder including Community Edition, as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms.
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, and Android, 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.
General usability
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
Network and connectivity
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]
Support for Delphi 6, C++ Builder 6, and later versions up to RAD Studio 11 Alexandria
Support for Lazarus 2.0.12 and Free Pascal 3.2.0
Support for reporting components, including InfoPower, ReportBuilder, FastReport
Support for all standard and third-party visual data-aware controls
Support for Professional Edition of Delphi and C++Builder for developing client/server applications
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, proxy session pooling, and statement caching
Oracle optimizer control
CLIENT_IDENTIFIER support
DBMS_ALERT support with the TUniAlerter component
Secure connections with SSL, SSH, and HTTP tunneling
Oracle package support
Oracle 9i scrollable cursor support
DML array operations support
ProxySession support
External Procedure support
ROWID values retrieval
Overloaded stored procedures support
Support for WITH FUNCTION clause
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
Enhanced support for User-defined Types of SQL Server
Ability to lock records and tables
MySQL
HANDLER syntax support
Transaction isolation level support
Possibility to retrieve last auto-incremented value
Session identifer retrieval
Server object information retrieval
Row-level and table-level locking support
Secure connections with SSL, SSH, and HTTP tunneling
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
InterBase events support with the TUniAlerter component
Comprehensive array data type support
Default value support for stored procedures
InterBase services components for configuring server parameters and security
Support for the Firebird 3 BOOLEAN datatype
Support for the Firebird 2.1 trusted authentication
Support for InterBase OTW encryption
PostgreSQL
Advanced sequences support
Advanced Large Objects support
Ability to control Fetch block size
Returning result sets from stored procedures
Secure connections with SSL, SSH, and HTTP tunneling
Notifications support with the TUniAlerter component
Support for PostgreSQL Asynchronous Notification with the TUniAlerter component
Supports the possibility of retrieving last inserted OID value
Advanced errors support
Support for the PostgreSQL notices
SQLite
Support for all commonly used data types
Support for autoincrement fields
Possibility to retrieve last auto-incremented value
SQLite database encryption in Direct mode using different encryption algorithms
Data Type Mapping
Support for automatic database creation on connect
Support for Shared-Cache mode
Support for SQLite user-defined functions
Support for SQLite user-defined collations
Support for SQLite extensions loading
Support for SQLite R*Tree module
Support for SQLite FTS3 and FTS4 extensions
Support for multi-SQL statements executing
MongoDB
Support for all commonly used data types
Support for native MongoDB query and update commands syntax
Support for displaying/modifying documents using regular data-aware controls like TDBGrid
Support for simply modifying documents in code using “fluent” interface
Support for reading/writing documents in the Extended JSON format
Support for working with collections via regular SQL using VirtualDAC
DB2
Advanced sequences support
Schema and function path support
DBF
Support for a variety of database formats: dBaseIII-dBase10, dBase for Windows, HiPer-Six, FoxPro 2, Visual FoxPro
Support for all native data types
Support for native dBase functions
Support for autoincrement fields
Support for .dbt (dBase), .fpt (FoxPro) and .smt (HiPer-Six) MEMOs
Support for .mdx (dBaseIV+) and .cdx (Visual FoxPro) indexes
Support for table management commands: CREATE/DROP/PACK/ZAP/REINDEX TABLE, ALTER TABLE ADD/DROP/ALTER COLUMN
Support for index management commands: CREATE/DROP INDEX
Universal Data Access Components 9.1.1 Full Description
Universal Data Access Components (UniDAC) is a library of components that provides direct access to multiple databases from Delphi and C++Builder including Community Edition, as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms. Key features: * Data access to all most popular databases * Direct MySQL and PostgreSQL connectivity * Support for Windows, macOS and Linux development * Support for all IDEs, from Delphi 6 up to latest RAD Studio * Best performance and memory management * Timely and professional customer support * On-demand night builds with fixes * Mobile application development * Direct connection in Oracle, SQL Server, ASE, SQLite, and DBF * Data encryption and decryption * DataSet Manager * Source code * Lazarus and Free Pascal support You can always find the latest version of the product on the official Devart website.
Use this library of components in order to access multiple databases directly, from Delphi, C++ Builder, Lazarus and Free Pascal programming environments
What’s new in Universal Data Access Components 9.1.1:
The PoolId connection pool option is added
Fixed bug with freezing multiply connection pools in threads
Fixed bug with leading spaces getting trimmed in strings loaded from XML in VirtualTable
Fixed bug with using the AsDate property when working with fields of the ftDate type
READ THE FULL CHANGELOG
Developers who base their work on the Delphi, C++ Builder, Lazarus or Free Pascal programming environments, might, at some point, require to establish a connection to multiple databases.
Relying with databases such as Oracle, Microsoft SQL Server, MySQL, PostgreSQL and others, could be difficult to achieve without a centralized access platform.
Universal Data Access Components was designed precisely with this purpose in mind and it will provide people a way of accessing the aforementioned databases from their preferred programming environment, regardless of their choice.
Developed as a library of components, UniDAC will function on both 32 and 64-bit platforms and it will enable users with universal access to multiple databases.
Offering this unified approach to the database-related applications in the development process, Universal Data Access Components will therefore allow users to easily switch between the different databases when specific characteristics are required.
Featuring a server-independent interface, it will provide people with an efficient way of creating cross-database applications, with outstanding flexibility and independence in their projects.
Being easy to set up, it provides a transparent, server-independent interface that is fully-compatible with the required databases. Choosing the appropriate way of performing server operations, Universal Data Access Components will enable each data provider with server-specific native connectivity.
All the data operations are performed automatically, in accordance with the different database characteristics and particularities.
System requirements
RAD STUDIO.
LAZARUS.
FREE PASCAL.
EMBARCADERO DELPHI.
EMBARCADERO C++ BUILDER.
Limitations in the unregistered version
60-day trial
Install a license key using a registration key file?
1: Click Install Key after navigating to Tools & Settings > License Management > Plesk License Key.
2: Choose Upload a licence key file.
3: Click OK after providing the path to the key file you downloaded from the email.