ORDS

ORDS

Let’s talk about ORDS IX

TweetShareSharePin0 SharesThis post is part of a series that starts with this post. Withy having looked at a bunch of things we can do with something as simple as an Auto-REST enabled view up to and including adding security, I just want to finish off with showing that having a view in the first place is not needed If all you want is a GET-service for a SQL. AUTO-Rest gives you many more things automatically, both like all forms of […]

ORDS

Let’s talk about ORDS VIII

TweetShareSharePin0 SharesThis post is part of a series that starts with this post. In the last post we made the service secure beyond all recognition (sebar 🙂 ) or maybe better expressed as so secure that nobody has access. In this post we’ll look at how to set up access to it to allow just those we have given credentials to to have access. To access a protected service one need to use a client-definition. id + secret, pretty much […]

ORDS

Let’s talk about ORDS VII

TweetShareSharePin0 SharesThis post is part of a series that starts with this post. Having gone through much of what can be done with a basic REST-service earlier in this series, it is time to look at securing the service. When you can access a service with noting noire than just the URL, then so can anyone else that has access to sen toe ORDS-server the URL. Not only can they read, but if the view allows writing then they can […]

ORDS

Let’s talk about ORDS VI

TweetShareSharePin0 SharesThis post is part of a series that starts with this post. It is time to turn to query parameters. It expands on the end point to allow slicing and dicing what we get back. Or in other words it allows projection. Or in layman terms, you can supply a where-clause expressed in jSON. You can also define sorting and much more. query parameters are basically key-value pairs with an equal sign as the separator. THis sounds much more […]

ORDS

Let’s talk about ORDS V

TweetShareSharePin0 SharesThis post is part of a series that starts with this post. In the last post we covered how to get the JSON-data returned from a REST-call converted back over to be represented as the rows and columns we are used to work with in the database. We’ll now take a look at how paging works and how we work with it to get a view to read all the rows. Let us first revisit how one reads one […]

ORDS

Lets talk about ORDS IV

TweetShareSharePin0 SharesThis post is part of a series that starts with this post. Having seen REST-calls from the database to get the raw JSON-response it is time to look at how it can be transformed into separate columns. This is the SQL we use to get data split up. OBJECT_ID OWNER OBJECT_NAME ——— —— ———————– 134 SYS ORA$BASE 143 SYS DUAL 144 PUBLIC DUAL 441 PUBLIC MAP_OBJECT 543 SYS SYSTEM_PRIVILEGE_MAP 544 SYS I_SYSTEM_PRIVILEGE_MAP 545 PUBLIC SYSTEM_PRIVILEGE_MAP 546 SYS TABLE_PRIVILEGE_MAP 547 […]

ORDS

Let’s talk about ORDS III

TweetShareSharePin0 SharesThis post is part of a series that starts with this post. Now that we have seen various ways to get data and validate the REST-service working we can move on to implement access from within an Oracle database. I find validating outside the database as the first step to be very valuable. If you have one database that has the rest enabled view, the rest service and then a view in another database reading from that view setup […]

ORDS

Let’s talk about ORDS II

TweetShareSharePin0 SharesThis post is part of a series that starts with this post. Now that we have a restenabled view and we can get data from ut with a basic cURL call, let’s look at more ways to make that call and view the response. But before those calls, lets look at what data we actually get from the REST-call. If we format the output from the cURL-call it looks something like this. {“items”:[……] ,”hasMore”:true ,”limit”:25 ,”offset”:0 ,”count”:25 ,”links”: [{“rel”:”self”. […]

ORDS

Let’s talk about ORDS I

TweetShareSharePin0 SharesI recently started looking into a problem at work with getting security added to our setup with views making REST-calls to work as if they were served with a database link. In that work I started from scratch adding one piece at a time to make sure I could troubleshoot it. In doing so I realised that we often talk about the amazing magic of ORDS, but how does one break it down to understand and troubleshoot the smoke […]

ORDS, Database

When TNS does not work in ORDS

TweetShareSharePin0 SharesThis is probably a short lived blog post. If you are using ORDS 22.4 (the current version as of this writing) you may encounter problems with the TNS-support for setting up connections. I believe they manifest when your TNS-entry has multiple hosts in them as you would if you have a setup with one or more standby databases. In such cases it looks something like this. I believe this is due to the parsing of the file not taking […]