Oracle NoSQL Database Version 18.3 Now Available

#ICYDK:  

We are pleased to announce the release of Oracle NoSQL Database Version 18.3. This release contains the following new features :

* Querying GeoJSON Data: Introducing support for spatial queries on RFC7946 compliant GeoJSON standard data.  A number of spatial functions, as well as indexing for GeoJSON data, have been added.
* IDENTITY column: Tables can now specify the IDENTITY type, unburdening the application developer from having to generate unique primary keys.
* Namespace: A convenience container for easing the administration of authorization, import/export, and application development for applications that must manage their own tenants.
* Admin Web Service: The Oracle NoSQL Admin service can now be accessed as a web service over the standard HTTP/S ports (80/443).  This new access paradigm exposes RESTful interfaces easing the task of operational automation.
* SQL for NoSQL Enhancements: Oracle NoSQL Database continues to power applications that require very fast access to data and flexible data models with enhanced SQL functionality to include INSERT and UPSERT.

Oracle continues to enhance Oracle NoSQL Database to meet customer requirements.

To download – Visit Here

To read about the new features – Visit Here

The Release Notes can be found Here.

Join our mailing list – NoSQL-Database@oss.oracle.com

Visit our LinkedIn page http://bit.ly/2DKHBCL

Access NetSuite RESTlets as Views

The CData Drivers (JDBC, ODBC, API Server, ADO.NET, SSIS, BizTalk, and Excel) implement standards-based SQL access to various data sources, enabling third-party tools to interoperate. You can use CData Drivers to create reports on NetSuite data, and you can also access existing reports. This article shows how to query a RESTlet in NetSuite.

SQL Access to NetSuite Saved Searches

NetSuite RESTlets are server-side scripts that interact with NetSuite data following RESTful principles. With the added support for RESTlets in the CData Drivers, users get SQL access to their NetSuite saved searches, exactly as they appear within the NetSuite UI. Users can quickly and easily see the results of saved searches, regardless of any complexities in the report, whether those are JOINs with other tables, formulas on fields, summaries, and more. The screenshot below showcases a saved search in the NetSuite UI (left) and the same results in Visual Studio Server Explorer using the CData ADO.NET Provider (right). https://goo.gl/6KMqp7