DIFM News & Events, RSS Feed
Creating an SDO_GEOMETRY Column from Lat & Long
This article discusses how to convert columns, Latitude & Longitude to Oracle's SDO_Geometry spatial format. This is a necessary skillset when working with tables and geospatial queries involving Latitude and Longitude values, and getting them to work in Orale APEX and display on maps.
Downloading AsApplied Data from the Ag Research Portal
Gathering data from an end-user application integrated with a database should be straight forward and easy. This video demonstrates a feature in the Ag Research Portal that allows an administrator to download As Applied Data using a set of cascading select boxes.
Always Free ADW Does Not Allow Private End Point Networking
When spinning up an Autonomous Data Warehouse in the Oracle Cloud OCI please take note that the always free versions do not allow you to update Network Access and set the database to a private end point in your VCN. This means unless you upgrade to a paid version of the database you cannot incorporate the data as part of a Bastion Server or configure it for TLS access. A potential work around may be to set your ADW database Access Control list to enable, but in doing so, you will be restricted to accessing the database from only Public IP addresses that you configure under Access Control. This may also limit you to accessing your ADW Database with third-party clients using a database wallet.
The Importance of Testing Application Performance For Database Tuning
Software development requires a collaboration between the backend developers (database) and application developers. This article features a recent issue outlining the importance of table indexing during software testing for measuring performance.
Real Application Security Administrator's and Developer's Guide
Real Application Security Administrator's and Developer's Guide:
Real Application Security is designed to:
Manage application security for application users rather than database users
Enable developers to manage security for application level tasks
Enable application user identity to be known during security enforcement
Enable developers to return security to the database layer, either incrementally, or all at once
What is Real Application Security, How to Enable It?
Real Application Security is a database authorization framework that enables application developers to define, provision, and enforce application - level security policies at the database layer. Our APEX Application development uses the IDCS User Group / Roles to define which end-users have access to pages, RAS, defines fine grain row access to data in tables for the end-user.
These Oracle Tools work together to allow our DIFM application developers to construct and define security policies that delineate access between research entity datasets, and farm datasets.
DIFM Ag Portal Now Integrated with Oracle IDCS!
The DIFM Ag Research Portal is now interfaced to the Oracle Cloud Identity Services. (IDCS) Integration allows scientists to spin up data tools in the cloud from the comfort of the end-user application. It also allows Group Roles and Access rights to data through a centralized management platform. The March IT Report will include a detailed video of the application development in progress.