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


No comments: