Monday, March 30, 2020

#777 - OIC --> File Server Feature

As usual, quotes from the Oracle docs in italics.

We have just added File Server capabilities to the OIC toolkit.

What is it?

Your own SFTP conform file server in your OIC Gen2 environment.
It is available with OIC Standard and Enterprise Editions and, of course, OIC for Oracle SaaS.

Current File Server availability is detailed here

There is no extra cost associated with File Server.

While using to FTP adapter to read/write files from/to OIC File Server, the standard pricing applicable to FTP adapter applies. Any file read or write over 50kb will be a considered a message. Example : 130KB file will be considered 3 messages (50kb each).

The full documentation is available here

Is it Enabled Out of the Box?

To begin using File Server in Oracle Integration, it must first be enabled for the Oracle Integration instance in the Oracle Cloud Infrastructure Console
Enabling File Server is a one time action.

Check out the steps to do so here

What does it look like?

Well here are some screenshots from the management UI -

Note the IP and Port entries above.
Yes, I have obfuscated them.
Net, net, you will leverage these to create the ftp connection in OIC and
also to access the file server from any ftp client, such as FileZilla.

Users/Groups -

Here you can configure existing OIC/IDCS users as File Server users -

Folders - 

I can set Permissions on these folders -

I can connect to the file server as one of the users, via FileZilla -

So now let's move the Invoice xml file to HCM_OUT.

Connecting to File Server from an Integration

I create a standard FTP connection in OIC, specifying the
File Server's ip address and port number  -

Remember that user you specify when creating the FTP connection has to have permissions to the File server directories being accessed in your integration.

Now we are ready to go - just create an integration that reads the input file and writes the output file leveraging the FTP connection we just created.

File Server REST API

File Server also comes with a rich REST API.

check out the REST API doc here

Another excellent resource is the File Server FAQ, available here

Wednesday, March 25, 2020

#760 - OIC - FastConnect & VPN --> compelling post from Jack Desai

read all about what is possible today here

go raibh mile maith agat, Jack!

Thursday, March 19, 2020

#759 OIC -->Processing an Incident in ServiceNow

One thing that hit me on logging in to ServiceNow was the plethora of functionality on offer.

Introduction to the ServiceNow adapter

ServiceNow provides platform-as-a-service (PaaS) enterprise service management
software for human resources, law, facilities management, finance, marketing, and
field operations. ServiceNow specializes in IT service management (ITSM)
applications and automates common business processes. ServiceNow contains a
number of modular applications that can vary by instance and user.

ServiceNow contains many modules/plugins and our adapter gives you access to the following -

However, I have no time for delving into its intricacies. I need to provide my mobile developer with an easy way to create/update an Incident in ServiceNow.

And, being the Irishman that I am, that I will do.

As usual, quotes from the OraDocs in italics.

First step - create a ServiceNow connection in OIC.

Create ServiceNow Connection

... is again the best approach here.

There are pre-requisites one needs to complete on the ServiceNow side for this to work.

The ServiceNow adapter doc is here

So which pre-reqs are we talking about?

1. a ServiceNow user, I will leverage the admin user here. However, you can, of course, create a dedicated integration user.

2. this user needs to have the default SOAP role assigned.
This role has access to the following - 

ServiceNow can can either be a trigger or an invoke from an OIC perspective.

For invoke, one needs to do the following -

This is easy to do in ServiceNow -

So I do this for all of the aforementioned tables.

For the Trigger -

same modus operandi.

Now I need to -

Create or modify the access control list to assign permissions for the preceding tables.

The admin user must have security_admin privileges to modify the
access control lists.

I now search for Access Control and then create the required ACLs -

Again, we differentiate between the Invoke and Trigger tables -

The Invoke Tables are -

For each of the above - create a new ACL for each table, specifying the read operation.
You can also assign a role - in my case, admin.

Note - one sets the field value to *

Now to the Trigger tables -

Essentially the same modus operandi, bu this time I select the create operation.

Now to the actual OIC connection -

OIC Integration - Create Incident

A very simple example here - I create an integration with a REST Trigger.
The Request has 1 field - incidentDescription 

Now to the ServiceNow Invoke -

The Invoke Request mapping -

The Integration Response mapping -

I activate the integration and then test it, via Postman -

I check out the Incident in ServiceNow -

The following is an excellent feature in ServiceNow -

The Incident Id is sys_id.

OIC Integration - Update Incident

Now let's use this for updating an integration -

Now I want to update my Incident, adding details such as setting -

Urgency = high
State = In Progress

Again I use the Show xml functionality to work out what to enter here -

The State value is now = 2

New = 1 etc.

Urgency = 1, 2 or 3.

Now to the Caller -

thanks to the ServiceNow Community website for the above description.

I created a user for myself and got the caller_id from the Show xml function.

I map as follows - note, I am only showing the mapped fields at the target.

I activate the "update" integration and then test -

Firstly, create the Incident -

I check it out in ServiceNow -

I test the "update" integration -

I return to ServiceNow -

OIC Integration - Delete Incident

Integration Response mapping -

Test -

That's one way of solving the Riot in the Hare of the Dog Reading Room!

OIC - THE Cloud Integration Platform