Resolve

issues faster

Database Tools

Must-have SQL Server tools and tools for MySQL, Oracle, and PostgreSQL database development, management and administration

Data Connectivity

The most trusted solutions for your data connectivity needs: ADO.NET, ODBC, SSIS, Excel, dbExpress, Delphi Components

Productivity Tools

Write code, create reviews, compare sources, track the working hours with the web app, utilize the power of ORM Solutions

Data Services

Data integration, online backup, web-based SQL tools, cloud connectivity solution

New Components and Unified SQL Support in UniDAC 2.50 Beta!

March 05, 2009

Devart is glad to present the new Beta of UniDAC with a bundle of new components that make UniDAC more effective and really universal.

We have added many significant improvements such as:

  • Unified SQL support

    Unified SQL is a language extension that has different constructions and allows to write truly database-independent SQL code. Unified SQL includes:

    Macro - in Unified SQL macros can evaluate to a different value depending on the provider used by the TUniConnection component.

    IF directive - for the purpose of extra flexibility Unified SQL supports conditional inclusion of SQL code into resulting statements using {if} directive. This allows to set different SQL for different DBMS.

    SQL Function - introduce standard for calling common SQL functions. In run time function is transformed either to the corresponding native function, or to an equivalent expression.

    Literal - provides universal syntax for date, time, and timestamp literals.

  • TUniLoader component

    serves for fast loading of data to the database. For each type of database server TUniLoader uses its specific interfaces for loading with maximum speed. For example, Oracle Direct Path Load interface is used for Oracle.

  • TUniDump component

    serves to store data from tables or editable views as a script and to restore data from a received script.

  • TUniConnection.AssignConnect method

    shares physical connection between several TUniConnection components

Try out Universal Data Access Components on its download page.

If you have any suggestions or questions concerning UniDAC, feel free to contact us by e-mail or through the forum.