File Library

CodeTalk 2018 - REST Database Links: Access Oracle Databases in The Cloud Using ORDS, REST, and JSON
Topic: Webinars
Owner: Chris Saxon
Date: 2018-05-17

Chris SaxonOracle Corporation and Robert Marz, its-people

The 2018 CodeTalk Series webinars are co-sponsored by ODTUG and IOUG.

This talk covers a real-world solution that recreates database links using ORDS, REST, and JSON. It breaks the limits of database links by loosely coupling two databases. The complexity is completely hidden from users and developers. Modern technologies such as REST and JSON offer elegant ways to couple databases without fixed dependencies. The protocol http(s) is able to surmount the corporate firewall and query databases in the cloud. A transparent layer made of table functions, views, and instead-of triggers can be placed over the connection.

This talk introduces REST, JSON, and ORDS very briefly. After the stage is set, we explore how to query auto-rest enabled tables from PL/SQL and process the JSON documents. Finally a view with an instead-of trigger is built that can be used by the application developers. A generator that produces all necessary objects will be shown. The generator can integrate into SQL Developer.

The presentation includes a live demo.

Download File   REST Database Links Access Oracle Databases in The Cloud Using ORDS REST and JSON.mp4

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database