Code-Innovate-Project

DIFM, Oracle Code-Innovate Project Collaboration. Includes reference materials, instructions and training material.

Oracle Code-Innovate Website

This project has been temporarily cancelled due to poor grant leadership and a lack of qualified software developers. We will be remediating this situation by hiring several software developers at the University of Connecticut, and hosting the project in the near future, entirely with UConn developers. --Keith Curran 2023.02.27

Oracle's Code-Innovate is a collaborative development project, which in the context of DIFM development intends to hold two sessions.  (1) The first is set to begin March 06, 2023 and aims to build Trial Design End-User Software using Oracle APEX, Oracle Spatial Studio, and is driven by Oracle's Autonomous Transactional Database in the Cloud.  The session will last one week where a DIFM team of developers will work directly with an Oracle Development team to build a basic but functional trial design application.  Following a successful completion, Keith Curran will present the results of the project to Oracle and DIFM Grant Administrators.   (2)  The second session (date undetermined) will expound upon the skillsets of the first session and will tackle Yield Prediction Modelling and Trial Optimization.   

In advance of these sessions; a select group of DIFM Developers are working towards gaining knowledge of Cloud Tools, Apex, and Oracle Spatial Studio.  The learning curve is large and all of February has been allocated towards expediting knowledge and working with Oracle to train on these systems.

I have been following the development of Oracle Apex for three years.  In my opinion, it is a mature product that will serve the need for a DIFM front end-User-Interface that meshes with Oracles IDCS, Roles and Group Security.    

If you have a DIFM developer you feel would like to participate in the training.  Please contact Keith Curran.  

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. 

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. 

Creating a 3-legged OAuth Application in IDCS

Where is the simple "shake 'n' bake" / step by step guide to creating a 3-legged, Authorization Code flow OAuth client in IDCS?

Right here!

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!

GDAL documentation » Vector drivers » Oracle Spatial

This driver supports reading and writing data in Oracle Spatial (8.1.7 or later) Object-Relational format. The Oracle Spatial driver is not normally built into OGR, but may be built in on platforms where the Oracle client libraries are available.

APEX DOCUMENTATION

You can click here to access the online Oracle Apex Documentation for Application Developers.  

Enabling Oracle JVM for Oracle Autonomous Database SDO_Geometry

Autonomous Database supports Oracle JVM. Oracle JVM is a standard, Java-compatible environment that runs any pure Java application.

Oracle JVM is compatible with the standard JLS and the JVM specifications. It supports the standard Java binary format and the standard Java APIs. In addition, Oracle Database adheres to standard Java language semantics, including dynamic class loading at run time.

Create Dynamic Drop Box Actions in Apex

This tutorial is for Oracle Apex Developers working on the Code-Innovate Project and reviews the process of creating dynamic drop down boxes useful for preserving the continuity of data in a process flow eminating from a database driven form. 

Oracle Code-Innovate Website

Click here to learn more!

Oracle Code Innovate Home Page
Louisiana State University Logo

March 07, 2023

Integration with Oracle IDCS Complete!

The DIFM Ag Research Portal and Farmers Portal is now integrated with Oracle IDCS and there is self-registration for farmers and research scientists.   Both applications remain under development but the underlying scaffolding is built and being tested.

Ag Research Portal:  Is an end-user application under development designed for PI's and Stakeholders to access, review, edit migrated data residing in DIFM's Autonomous Data Warehouse in the Oracle Cloud.  

Farm Portal: Is an end-user application allowing farmers to register for OFPE Trials, upload necessary data for implementing those trials.  

Integrating user registration with IDCS and managing application & data access with IDCS satisfies essential requirements of Phase I of the software development plan.