Tag: OPA DB Connector

Mantis Solutions OPA DB Connector : Part Two : Linked Tables, Bind URL variables and more

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.

Mantis Solutions OPA DB Connector : First Looks

Mantis Solutions OPA DB Connector

Mantis SolutionsThis week I was treated to a walk-through and initial demonstration by the Mantis Solutions team in Perth, Australia. Our virtual meetup spanned a large number of timezones and I am very grateful to Kris and the team for putting it together. I thought I would give you all some first thoughts before diving into a hands-on test with the environment they kindly put at my disposal.

Firstly my thoughts on the concept. For some time, the focus of Oracle Policy Automation has been in providing either specific connectors (as in, those supplied with Oracle Policy Automation version 10) or generic Web Service connectors (in the case of Oracle Policy Automation version 12) plus a few outliers like the In-Memory Analysis engineered solution which pretty much uses two connections.

But the Snap Poll survey we ran a few weeks ago highlighted something that I have been aware of, both in the field and the classroom :- there are plenty of Oracle Policy Automation customers out there who use, or intend to use, a database (Oracle, MySQL or whatever) as the source and target for their Connections, not necessarily an application. Sure, they could build their own connection – and that is of course supported – but there are plenty of situations where that is either out of scope, out of cost or simply not reasonable within the timeframe usually associated with a Cloud solution.

So, enter Mantis Solutions with their lightweight OPA DB Connector (link to product PDF) platform to create, map and manage connections to databases – any database that JDBC will support – that allows customers to get up and running with a Connection in no time at all. Their solution allows for centralized management of Database connections, as a Cloud service or On Premise application,  to get you operational faster and to help you keep your integration up to date easily.

For this first video, I focused just on showcasing the application and the ease with which you can build a Connection and have it operational in minutes. This is very appealing for all the reasons I listed above, but also for people like me who are called upon to do Proof of Concepts or prototypes and who need a very flexible solution.

You can contact Mantis Solutions for more information on their website. In the meantime here is the first of the videos:


Logo by Southpaw Projects LLC