Meeting Details:

March 26, 2019

Creating REST API's with Oracle REST Data Services (ORDS) and OAUTH - Blaine Carter, Oracle

Most of you have heard about REST (REsource State Transfer) as a method used by web applications to communicate with each other, but did you know that you can also use REST to communicate with your Oracle database? Using nothing more than a typical HTTP URL and GET/PUT/POST/etc. methods, you can interact with your Oracle database to perform SELECTs, INSERTs, UPDATEs, etc. via your web browser. Sounds great from an ease of use standpoint. No more need to install SQL clients on customer machines. All they need is their favorite web browser and they are in business. But if you're a DBA like me, you quickly get to worrying about security. If I'm opening my database to anyone with a web browser, how do I control access? That's where OAUTH comes in. It provides the authentication to insure only approved users are accessing your REST-enabled database.

Creating REST APIs is Fast, Easy and Secure with Oracle REST Data Services (ORDS) and OAUTH. This month Oracle's Blaine Carter will join us to bring us up to speed on just how it all works.

In his session, Blaine will demonstrate how to REST enable your database using ORDS. He will demonstrate how to use SQL Developer to create and deploy REST services in ORDS.

First, Blaine will "Auto REST" enable a table and a PL/SQL package. Then he will secure the API and create an OAuth2 client that can be used to access the service. Next he will walk through the steps of creating a custom REST API using the REST Data Services wizard. This API will be used to POST image files into a BLOB column in the database and the GET handler will serve the image directly in a web page. You will leave this session with an understanding of how you could go back to the office tomorrow and quickly create REST services on your own database.

Blaine Carter hails from Utah and has over 20 years experience in various software development roles. Four years ago, Blaine joined Oracle Corp. as the Oracle Developer Advocate for Open Source. He applies his exploratory eye and tinkering inclinations to the intersection of Open Source and Oracle Database. He helps database developers improve their workflow using Open Source tools and promotes the use of Open Source inside and outside of Oracle.

Blaine is a firm believer in learning by doing, failing, figuring it out and then sharing.

For information on usual meeting locations and times as well as previous meeting minutes and presentations please refer to the meetings page.

For further information or enquiries regarding meetings please contact the SOUG meeting coordinator.

Contact Webmaster for Website Issues