Data Abstract for .NET and Delphi

What's New in RemObjects Data Abstract 6?

• New JSON data streamer for both platforms, that - working together with the JSON message in RO will make it easy to access Data Abstract servers from JavaScript.
• Improved the IDE experience for DA LINQ, with new menus and a custom tool in Visual Studio to generate code.
• New LoginEx method in the standard login services will provide new flexibility in implementing authentication where more parameters are needed.
• New DA SQL Browser tool is provided in DA/.NET to explore and query DA SQL based servers.

What's New in Data Abstract 5?

Features in all editions of Data Abstract

• AutoSQL lets Data Abstract generate SELECT statements on the fly, when needed
• Dynamic Select allows clients to retrieve subsets of fields, optimizes network traffic and reduces client side memory load
• Reduced Deltas feature for reducing network bandwidth when applying updates to tables with many fields or large blobs
• Dynamic Where allows clients to supply custom conditions for filtering data server-side, and apply those securely without risk of SQL injection attacks
• New Connection Types provide more flexibility for matching up statements in multi-database scenarios
• New expandable Reconcile Dialog architecture to easily provide end-users with feedback about failed updates
• Transparent support for Data Table Unions to publish combined data from multiple data tables as a single entity
• New Bin2DataStreamer for improved and more efficient streaming of data between client and servers
• Native support has been added for new XML, GUID and Decimal data types.
• New driver support is being provided for the open source SQLite embedded database
• Support for versioning of schema files.
• New Welcome Page displayed after the first install to assist new users with getting acquainted with the product.

Features specific to Data Abstract for .NET

• Database Schemas can now be accessed via the browser when using HTTP Server Channels
• SQL Server Compact Edition driver support
• Experimental support for the upcoming Visual Studio Codename 'Orcas'.

Features specific to Data Abstract for Delphi

• Data Abstract for Delphi now supports Free Pascal, allowing you to compile your applications for 64-bit Windows and the Linux platform
• Easier setup of client-side Master/Detail relationships based on Dynamic Where
• All new TDAMemDataTable component for client-side data storage, providing much more efficient and streamlined data access.
• New TDARemoteCommand component for easier execution of published database commands from the client.
• New Borland Database Engine (BDE) Driver for access to legacy database systems and easer migration from desktop databases such as DBase and Paradox to multi-tier.
• New cross platform ZEOS driver to access a variety of database systems from both Delphi and Free Pascal projects.
• NexusDB drier

Data Abstract for .NET and Delphi is a suite including RemObjects Data Abstract for .NET and Delphi Editions:

Data Abstract allows you to create services that access any database by providing a clear separation between data-access and business-logic. Through the use of schemas and the Schema Modeler utility, it enables you to maintain a unique code base to access multiple database engines at the same time. Cross database systems are now as simple to build as single database ones.

.NET Specific Features

• The unique RemoteDataAdapter allows you to stream and update multiple data tables at once, avoiding redundant network round-trips
• Extendable Data Abstract Remote Service provides you with all the basics to access your databases and start coding your business layer immediately
• Unique and simpler driver architecture controlled by XML configuration files
• Exchange data in an optimized binary format with clients written in .NET, Mono, Delphi or Kylix and running on a large variety of platforms

Core Features

• Build scalable multi-tier cross platform database applications for .NET, Mono and Win32
• Target different database back-ends using a common code base
• Use Schema Modeler to design the interface of your data
• Leverage the new wizards and IDE enhancements to build DA applications even easier than with previous versions
• Support for a wide range of database back-ends, including Microsoft SQL Server, Oracle, DB2, Interbase/Firebird, Sybase, PostgreSQL, MySQL, SQLite, NexusDB and many more

Features

• Complete abstraction of different databases: use the same code for Microsoft SQL Server, InterBase, Oracle, MySQL, DBISAM, DB/2, etc.
• Build your applications with a "stateless" focus for maximum scalability and seamless cluster integration
• Stream data all at once, on demand, paged or any combination of those
• Re-synch fields automatically with the remote data source
• Use update rules to design complex update sequences without a single line of code
• Enhanced Business Processors give you more control on your business updates
• Cross-database autoincrement and generator-based field support
• Work with either auto-generated SQL or proprietary dialects, whenever higher performance or access to RDBMS specific features is required
• Full support for stateless Master/Detail transactional updates
• Update Rules: create complex update sequences without a single line of code
• Design your data-access layer in an innovative RAD way using the Schema Modeler
• Minimize SQL dialect differences using Data Abstract's macro processor
• Easily create your own data access driver to extend the list that comes with the product
• Support for regular expressions for client-side data-validation
• No deployment license costs

Data Abstract Schema Modeler
Data Abstract's use of Schemas enables you to maintain a unique code base to access multiple database engines at the same time, making it easy to build cross database systems.
Schemas shield both the middle-tier business logic and the client applications from the intricacies of the back-end database by defining the proper commands and data tables and mapping these to the physical data sources.
Data Abstract includes the Schema Modeler utility, which is deeply integrated with the supported IDEs, to aid you in designing and maintaining Schema definitions. Schema Modeler includes tools for creating data tables and commands from the underlying database, designing the mappings for individual data sources and defining master/detail and foreign key relationships.

Supported Database Systems

Database systems supported by Data Abstract Delphi includes:

• Microsoft SQL Server 2000 and 2005
• New: Microsoft SQL Server Compact Edition
• Oracle
• DB2
• InterBase/Firebird
• Sybase
• PostgreSQL
• MySQL
• New: SQLite
• NexusDB
• New: Borland Database Engine for dBase, Paradox, etc.

Supported Third Party Data Access Components in Data Abstract for Delphi

• dbGo (ADO Express)
• DBX
• DBX4 (Delphi 2007 and up)
• IBX
• SDAC, ODAC, MyDAC and IBDAC by CoreLabs*
• MySQLDAC and PostresDAC by microOLAP*
• IBObjects*
• DBISAM*
• New: ZEOS

(* Requires a separate license for these commercial data access libraries.)