Data Abstract for Delphi

What's New in 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 for Delphi 5?

Features in all editions of Data Abstract

• New AnyDac driver
• 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 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

RemObjects Data Abstract for Delphi is a RAD multi-tier solution that allows you to easily build distributed applications accessing different databases, providing a clear separation between data-access and business-logic.

RemObjects Data Abstract Core Features

• Build scalable multi-tier cross platform database applications.
• 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

RemObjects Data Abstract for Delphi 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

Supported Database Systems

Database systems supported by Data Abstract include:

• Microsoft SQL Server
• 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.)