Overview of the Software

Devart Universal Data Access Components (UniDAC) Pro 12.0.0 for Delphi 13 (D13) is a high-performance library designed to provide direct, native access to multiple database servers from Delphi and C++Builder, including the latest RAD Studio 13 version. This component suite eliminates the need for deploying separate client libraries for each database, offering a unified interface for connecting to major database management systems (DBMS). By abstracting the database-specific nuances, UniDAC allows developers to switch between different database servers seamlessly, significantly accelerating cross-database application development.

Key Features

The Pro version of UniDAC includes advanced features beyond the standard edition, tailored for enterprise-level application development.

• Universal Access: Connect directly to Oracle, Microsoft SQL Server, MySQL, PostgreSQL, InterBase, Firebird, SQLite, and more without changing code.

• Direct Mode: Operate without client software for several databases (including SQL Server, MySQL, and PostgreSQL), simplifying deployment and reducing configuration overhead.

• High Performance: Optimized data fetching and processing algorithms ensure minimal memory footprint and maximum execution speed for complex queries.

• Complete RAD Studio 13 Integration: Fully supports Delphi 13 and C++Builder 13, including 32-bit and 64-bit Windows, macOS, Linux, iOS, and Android targets.

• Advanced Dataset Management: Features TUniQuery, TUniTable, TUniStoredProc, and TUniSQL components that mirror standard VCL/FMX dataset behavior, enabling rapid migration from BDE, ADO, or dbExpress.

• Pro Edition Exclusives: Includes source code for all components, professional technical support, and licensing for multi-tier application server deployment.

What’s New in Version 12.0.0

This release focuses on compatibility and performance enhancements for modern development workflows.

• Official Delphi 13 (RAD Studio 13 Alexandria) support.

• Enhanced Direct Mode for SQL Server 2022 with support for new data types and TDS protocol optimizations.

• Improved macOS ARM64 (Apple Silicon) compatibility for native database applications.

• PostgreSQL 15 and 16 support, including array and JSON data type handling.

• Faster connection pooling to reduce latency in high-concurrency environments.

System Requirements

Before installing Devart UniDAC Pro 12.0.0, ensure your development environment meets the following specifications.

Installation Guide

Follow these steps to install and license the Pro edition correctly. Note that this guide assumes you have a valid commercial license obtained from the official Devart website.

1. Close RAD Studio 13 completely.

2. Run the unidacpro12.0.0_d13.exe installer with administrator privileges.

3. Accept the license agreement and select “Complete” installation type.

4. In the component selection window, ensure “Delphi 13” is checked.

5. Enter your License Key (provided after purchase) when prompted.

6. Click Install and wait for the registration process to complete.

7. Launch RAD Studio 13. UniDAC components will appear on the “UniDAC” tab of the Tool Palette.

How to Use the Software

Using UniDAC involves a few core steps to establish a connection and execute queries.

Connecting to a Database (Example: SQL Server via Direct Mode)

1. Drop a TUniConnection component on your form.

2. Set the ProviderName property to SQL Server.

3. Double-click the connection or set the ConnectString property:
   Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Direct=True

4. Set Connected := True; to open the connection.

Executing a Query

var
  UniQuery: TUniQuery;
begin
  UniQuery := TUniQuery.Create(nil);
  try
    UniQuery.Connection := UniConnection1;
    UniQuery.SQL.Text := 'SELECT * FROM Products WHERE Category = :Category';
    UniQuery.ParamByName('Category').AsString := 'Electronics';
    UniQuery.Open;
    // Process data...
  finally
    UniQuery.Free;
  end;
end;

Best Use Cases

UniDAC Pro excels in scenarios where application flexibility and database migration are priorities.

• Multi-Database Applications: Build one codebase that must support customers using either Oracle, SQL Server, or PostgreSQL.

• Cross-Platform Services: Develop database middleware that runs on Windows servers, Linux containers, or macOS workstations.

• Migration Projects: Move legacy BDE or ADO applications to modern Delphi without rewriting all data access logic.

• Embedded Database Support: Combine SQLite for local storage with a centralized MySQL server for synchronization.

Advantages and Limitations

Advantages

• Single Codebase: Reduces maintenance costs by up to 70% compared to maintaining database-specific components.

• No Client Library Dependency: Direct mode eliminates installation of Oracle Client or SQL Server Native Client.

• Full Source Code (Pro): Allows debugging into component internals and custom modifications.

• Active Support: Devart provides monthly updates and responsive ticket-based support.

Limitations

• Cost: The Pro edition with source code is more expensive than open-source alternatives (e.g., ZeosLib, FireDAC bundled with Delphi).

• Learning Curve for Advanced Features: While basic use is simple, mastering provider-specific options requires reading documentation.

• Direct Mode Limitations: Some advanced features (like SQL Server Always Encrypted with column master keys) require client libraries.

Alternatives to the Software

Recommendation: If you need commercial support and work with 3+ database types, UniDAC Pro is superior. For single-database projects, FireDAC or native drivers may suffice.

Frequently Asked Questions

1. Is Devart UniDAC Pro 12.0.0 compatible with Delphi Community Edition?
No. The Community Edition targets fewer platforms. UniDAC requires the full RAD Studio 13 Professional, Enterprise, or Architect edition.

2. Can I use UniDAC for free for open-source projects?
No. Devart does not offer a free or open-source license. A paid commercial license is required for any use, including evaluation (30-day trial available).

3. How do I legally purchase a license for UniDAC Pro?
Visit the official Devart website, select the UniDAC Pro edition, choose “RAD Studio 13” as the target IDE, and complete checkout. Licenses are perpetual but include 1 year of updates.

4. Does UniDAC support connection pooling across different databases?
Yes. UniDAC implements its own pooling mechanism independent of the database client. Enable it via the Pooling property in TUniConnection.

5. What is the difference between UniDAC Standard and Pro?
The Pro edition includes full source code, a license for multi-tier application servers (DataSnap, REST), and priority technical support.

6. Can I deploy my application using UniDAC to a Linux server without X11?
Yes. UniDAC supports console and service applications on Linux (headless mode). Ensure you use Direct Mode for databases that support it.

7. Does version 12.0.0 support Apple Silicon (M1/M2) natively?
Yes. This version adds native macOS ARM64 support when compiling with Delphi 13 for the macOS target.

Final Thoughts

Devart UniDAC Pro 12.0.0 for Delphi 13 is a robust, production-ready solution for developers who need a unified, high-performance data access layer. While the licensing cost is a consideration for individual developers, the time saved on database migrations, cross-platform builds, and ongoing maintenance typically justifies the investment for professional teams. For new projects starting on RAD Studio 13, UniDAC offers a clear upgrade path from legacy technologies, provided you obtain a legitimate commercial license from Devart.