Release Notes: This release adds a module for querying and updating Salesforce.com installations, backed by the Salesforce.com Web services. It adds a module for querying SugarCRM installations, backed by SugarCRM Web services. It optimizes support for DB2 queries with firstRow and maxRows properties set, yielding a ROW_NUMBER query in the background database interaction.
Release Notes: Queries can now be compiled, preparing them for execution with varying parameter values. For JDBC databases, this will provide prepared statement-like functionality. For other datastores, it will simply make query reuse simpler. DataSet index caching has been implemented, making lookup by column or by "select item" faster and constant-time.
Release Notes: This release provided full support for CRUD operations on JDBC databases, CSV files, Excel spreadsheets, and NoSQL stores. CREATE TABLE, DROP TABLE, UPDATE, and DELETE FROM operations were added. Support for LIST and MAP column types (common in NoSQL stores) was added. Awareness of primary key columns was implemented (especially useful for UPDATE operations). Support for plain Java collections as datastores (LINQ style) was added. Full support for CouchDB databases was provided. Several maturing improvements were made in the API's syntax and semantics.
Release Notes: This release introduces an interceptor layer for adapting and monitoring any query or update to your data. It greatly improves JDBC insert performance by using batch inserts instead of regular statements. It sanitizes the type conversion API to use the new interceptor layer.
Release Notes: A significant new release, containing support for MongoDB databases (both read and write) and XPath/SAX-based reading of XML files as tables. It contains a few bugfixes.
Release Notes: New features include an API for performing updates (write operations) on data, the ability to create data in CSV files, Excel spreadsheets, and JDBC databases, support for visual styling metadata, used in spreadsheets and similar data stores, support for the IN operator in queries, and major performance improvements for Excel reading.
Release Notes: A composite DataContext has been added, allowing querying of multiple datastores including transparent client-side joining, filtering, grouping etc. Support has been added for MS Access and dBase databases.