Jarvis Pizzeria: ORDS-CRUD Generator

The Auto REST feature allows you to quickly set up REST services on your ORDS enabled database. This feature allows users wanting to quickly enable database objects and run basic queries. Users wanting more complex operations will need the Full REST development setup.

In order to use the Auto REST functionality, only a few actions are required. Although the amount of work when using the Full REST option is not too bad, it is still considerably more than with Auto REST.

To reduce the effort difference between Auto REST and Full REST, fellow Jarvis owner Rick has developed an ORDS-CRUD generator. With the help of this tool it is possible to generate CRUD templates for REST enabled resources (e.g. an address table).

The tool is available in a VBCS and a JSFiddle variant.

Remark: the tool only just exists, and new functionalities / possibilities are added regularly. So keep following the development.

Click here to read the complete post.

Jarvis Pizzeria: How to manage Masterdata of a DM (part 1)

This blog is a follow up of Using a DM in ICS, but can also be read as a separate item.

We have implemented the decision table below in a Decision Model (see Using a DM in PCS) and we have made the Decision Model accessible through an integration (see Using a DM in ICS). But now let’s look at the data in this table.

Suppose that it turns out that deliveries by scooter at distances above 5 Km turn out to be faster than expected (because this is usually outside built-up areas, where there is less traffic).

For this we have to adjust the CalculateDeliveryTime in line 6 of the table from 20 to e.g. 18. Once this is done we must activate a new snapshot. Because the integration of the previous blog refers to the LATEST snaphot version, no further adjustments are needed. The Decision integration can be used unchanged.

Continue reading

Jarvis Pizzeria: Using a DM in ICS

This blog is a follow up of Using a DM in PCS, but can also be read as a separate item.

In the previous blog we showed how to embed a Decision in PCS. We described how the hard-coded relationship between a Decision and Process (PCS) can be prevented by using an ICS integration. In this blog we describe step by step how this integration can be developed.

ICS Integration

The integration can be divided into the following steps:

  1. Get the endpoint of the Decision Service
  2. Create the invoke Connector
  3. Create the Integration
  4. Activate the Integration
  5. Test the Integration (using postman)
  6. PCS adjustment to invoke the Integration

Continue reading

Jarvis Pizzeria: Using a DM in PCS (how to manage versions …)

In this blog we show two different ways to embed a Decision in PCS. This with special attention to version control.

In PCS (OIC component) it is possible to use a Decision Model Activity directly from a process. See the image below.

This process uses a Decision to calculate how much time it takes to deliver an order. To not make this all too complex, the Decision takes into account a limited number of factors, namely distance and means of transport. Continue reading