Tag: OCI

  • Configuring OCI IAM Domain JWTs to use with ORDS OAuth2.0 protected APIs

    , , ,

    Table of Contents Intended Audience/Purpose Does this describe you? Creating a Domain Configure Client Access Adding an Integrated Application to the Domain Adding the application Configuring OAuth Resource server configuration Client Configuration Issuing a POST request to obtain a JWT Gathering the required values for the request Setting up Postman Requesting the JWT ORDS configuration…

  • ORDS 24.3 Release Highlights

    , ,

    Overview There’s plenty to talk about in this release. However, I’m most excited about the performance improvements, ORDS sample applications, and documentation changes. Read on to get the whole story. Enhancements API Performance REST API responses from either AutoREST or customer based modules could see as much as a 30% improvement in response times. About…

  • Extending ORDS with a Java plugin

    ,

    About this article This article is a walkthrough and overview of setting up the example Java plugin that ships with ORDS. These plugins allow you to add functionalities and capabilities above what is possible with a standard ORDS configuration. In this example, the plugin allows you to use a name as a query parameter in an HTTP…

  • Setting up SSH to GitHub git clone into your Oracle Cloud Linux Ubuntu VM with VNC

    ,

    I’m trying to be as succinct as possible. I just accomplished this but couldn’t find anything that explicitly walked me through how to do it. Here are some assumptions: REMINDER: You are signed in to a Linux machine! The commands you will follow (in GitHub or here) WILL NEED TO BE FOR LINUX! What happened?…

  • Python script to retrieve objects from Oracle Cloud Bucket

    , , ,

    For…reasons, I needed a way to retrieve all the .CSV files in a regional bucket in Oracle Cloud Object Storage, located at this address: https://objectstorage.us-phoenix-1.oraclecloud.com/n/dwcsprod/b/moviestream_data_load_workshop_20210709/o You can visit it; we use it for one of our LiveLabs (this one), so I’m sure it will stay live for a while 😘. Once there, you’ll see all…

  • Create a view from a JSON Collection and REST-enable it with ORDS

    , , ,

    The DBMS_CLOUD PL/SQL Package You can use this PL/SQL procedure (in the DBMS_CLOUD package) along with the file_uri_list URL (seen in the code below) to create and then add JSON documents to a JSON Collection (good info on JSON Collections in the Oracle database). In this example, we call this collection Movie_Collection. 👆🏻 This is…

  • ORDS, SQLcl, APEX via YUM and DNF

    , , , ,

    TL;DR BREAKING NEWS!! APEX packages with ORDS and SQLcl now available in Oracle Linux YUM servers and through ULN The deets Here is what you need to know. We are releasing three new APEX (a.k.a. “The Artist formerly known as Oracle Application Express”) packages for the following repositories: NoARCH RPMs One more update! These RPMs…

  • Python and the Oracle Autonomous Database: Three Ways to Connect

    , , , ,

    Watch the deep dive videos: Part I Part II Part III Welcome back I finally had a break in my PM duties to share a small afternoon project [I started a few weeks ago]. I challenged myself to a brief Python coding exercise. I wanted to develop some code that allowed me to connect to…

    summary-outut-from-sql-query-in-test1-python-file-chris-hoina-senior-product-manager-ords-oracle-rest-apis-autonomous-database-database-actions
  • More fun with Medium story stats, JSON, Python, Pandas, and Oracle SQL Developer Web

    ,

    That’s right; I’m back again for yet another installment of this ongoing series dedicated to working with Medium.com story stats. I first introduced this topic in a previous post. Maybe you saw it. If not, you can find it here. Recap My end goal was to gather all story stats from my Medium account and…

    completed-csv-ready-for-oracle-autonomous-database-chris-hoina-senior-product-manager-oracle-rest-apis-database-tools-autonomous-database
  • Oracle REST APIs: A LiveLabs review

    ,

    Recently Jeff and I were invited by the Oracle Developers and Developer Relations teams to do a walkthrough of a LiveLabs workshop, “How to Build Powerful and Secure REST APIs for Your Oracle Autonomous Database.” We spent about 90 minutes moving through selected labs in the workshop. Luckily they recorded it for us; you can…

    Two-approaches-to-Oracle-REST-APIs-Chris-Hoina-Senior-Product-Manager-ORDS-Database-Tools-1