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.
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.
Apex Authentication & Authorization with Identity Cloud Service
Having visibility into who can access your application is critical in the application development process. Apex is built with the ability to create roles and permissions, but this video takes it one step further through the integration with Oracle Identity Cloud Service (IDCS). Users will be able to login to APEX applications with their own IDCS credentials based on an authentication scheme linked with IDCS. The access can be even more granular through group authorization schemes by only allowing certain IDCS users or groups to have visibility into distinct pages or data within your application.
Connecting Oracle APEX to IDCS
Integrating our APEX DIFM Ag Portal Application to Oracle IDCS is essential for managing all types of users, be they farmers, scientists, consultants or curious public internet traffic. It also allows centralized management through the IDCS Administrators. Users with proper access can spin up cloud resources on demand to accomplish scientific analysis.
In all, this entire setup from start to finish should only take about 30 minutes or less. So let’s hit that timer and get started!