Mantis Solutions OPA DB Connector : Part Two : Linked Tables, Bind URL variables and more
Readers will recall that last week I provided a quick run-through of the capabilities of the Mantis Solutions OPA DB Connector. Simple to use and lightweight, I see it as a great way to open up legacy data sources easily to Oracle Policy Automation for rapid exploitation.
In this second short video, I wanted to keep going in the same direction as last time :
- In the first part I decided to highlight a couple of neat features, the dashboard page which provides some neat and simple dynamic graphics for viewing calls to the connector
- Secondly, the ability to quickly to create bindings to URL variables, for example a row_id (in my case) to load a set of data into the Web Interview. Although I didn’t look at it this time, there is also the ability to create bind mappings which I will investigate in the next video
- Finally, the creation of a second, linked, table and how to add the necessary foreign key and so forth to be able to refresh the Connection in Oracle Policy Modeling and add a child entity and load that data. You’ll see it didn’t take me very long at all.
My apologies for the very croaky and quiet voice-over on this video, since the last one was recorded I have changed timezone which meant I brought back a cold as a souvenir of Canada. Hopefully by the next video in the series I will be back to full strength. Once again, many thanks to the Mantis Solutions team for putting the environment at my disposal. If you would like to reach out to them (and they would be delighted to chat with you I am quite sure!) then just head on over to their website at Mantis Solutions.com.au.