#1065 OIC 25.04 New Features - Auto-Retry actions generation

This is a truly cool new feature - close to my heart. The use case is simple, I have an integration with one or more invokes and I want to apply retry functionality to them, e.g. retry on failure up to 3 times etc.

Now you could implement this yourself, but now just let OIC do the work - here is a simple example - 

As you can see, this part of my integration uses the Netsuite connection to create a customer.

I now want to apply Retry Logic to this. It's very simple to do so -  

Let's check out exactly what's been added - 

First let's look at the While loop - 

here I invoke the Netsuite action createCustomer while - 

The main logic is as follows - 

Attempt to create the Netsuite customer; if successful, set the retry variable to false.

The fault handler logic is as follows - 

The Wait - is based on a variable -  

The variables are set in the initial assign action - 

You can of course, set these variables to what suits you.

 

 

#1064 OIC 25.04 New Features - AI Doc Understanding & SELECT AI support

The OIC 25.04 release introduces a new native action for OCI AI Document Understanding -

This makes it very easy to implement scenarios, such as the following - every day, at 5pm, read invoices from our ftp server /inbox directory, extract the salient data and process accordingly.

First stop is my demo invoice - 

Let's test the powers of AI Document Understanding on this - 

Looks good! Now to OIC...

I copy my invoice to my local ftp server - 

Here is my OIC project with my scheduled integration, DailyBatch -

The integration is as follows - also check out the configuration of the Document Understanding native action

Now to the mapping - essentially, I download the document via the ftp connection, this gives me the file reference. I then use the mapping function encodeReferenceToBase64 and map to the target - 

I then activate and run the integration -

Excellent! Here's a screenshot of the Document Understanding response -

Summa

This is the first native action for OCI AI services to appear in the integration design palette.

As you can see, there are other such AI services, so expect more such native actions to appear in future releases!

SELECT AI support in the ATP Adapter

First step is to look at enabling SELECT AI on your ATP instance - 

Btw. my ATP user is RENATEC and I am using Cohere as my AI engine.

GRANT execute on DBMS_CLOUD_AI to RENATEC

BEGIN  

    DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(

         host => 'api.cohere.ai',

         ace  => xs$ace_type(privilege_list => xs$name_list('http'),

                             principal_name => 'RENATEC',

                             principal_type => xs_acl.ptype_db)

   );

END;

/

EXEC DBMS_CLOUD.CREATE_CREDENTIAL(credential_name   => 'COHERE_CRED', username => 'COHERE', password => 'yourCohereAPIKey');

BEGIN

  DBMS_CLOUD_AI.CREATE_PROFILE(

  profile_name   => 'Cohere',

  attributes     =>'{"provider": "cohere",

"credential_name": "COHERE_CRED",

"object_list": [{"owner": "RENATEC", "name": "orders"},

  {"owner": "RENATEC", "name": "countries"}]

       }',

status     => 'enabled',  

          description     => 'AI profile to use Cohere for SQL translation'

     );

END;

/

Note the object_list above - here I am defining which tables can be used in respect of AI generation of SQL. 

EXEC DBMS_CLOUD_AI.set_profile('COHERE');

I now test this in ATP - I want to generate SQL to select all Irish customers from my orders table.

Now to OIC, where I have an integration that invokes ATP via an ATP connection. Here is the configuration -

Summa Summarum

These are really 2 excellent AI driven features in OIC 25.04, and there are many more to come!