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.
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!
Connecting To Private Autonomous Database Using OCI Bastion
Oracle recently released OCI Bastion, a fully-managed service providing secure and ephemeral access to private resources in Oracle Cloud Infrastructure (OCI), all at no additional cost. One of the great capabilities of the Bastion service is its ability to connect to different types of resources in OCI, not just compute instances. This includes database PaaS services such as Autonomous Database. In this quick tip, I’m going to walk you through how to set this up, both for SQL connections, as well as to connect to APEX that comes pre-installed with all Oracle Autonomous Databases.