The primary users of File Server include:
Oracle Integration administrators, who use File Server to manage server settings and configure users, groups, and folders, including permissions. To administer File Server as described in this guide, you must be assigned the ServiceAdministrator role in Oracle Integration. See Oracle Integration Service Roles in Provisioning and Administering Oracle Integration and Oracle Integration for SaaS, Generation 2.
Oracle Integration developers, who use File Server along with the FTP adapter in integrations to read and write files.
Oracle Integration users, who access File Server using an SFTP client. These users must be configured and enabled as users in File Server. Their access is controlled by their assigned folders and folder permissions.
This use case reads the file from Standalone SFTP server and writes into Oracle Integration(OIC) File Server. As part of this blog, you will also learn how to create a folder, provide permission and get the File Server details.
Let us say I want to implement the above use case, I need Standalone SFTP Server(Source system) details like IP address/Host, Port number, username, password and hope you know how to get all those details. And I also need to get File Server details which is provided as part of Oracle Integration.
Now, we will talk about how to get into the File Server of OIC and get all the details which are required to connect like IP Address, Port. For username and password, you could use your OIC Username and password.
Login to OIC àHomeàSettingsàFile Server àSettings àGeneral Tab
Login to OIC àHome àSettings àFile Server àFolders àClick on home àclick on users àclick on the folder which is created with your name/emailed àclick on Create to create a folder
After creating the folder, you will have to give permissions to that folder, select the folder, on your right hand side, you can see the option called Permissions. Click on the Permissions àClick on Add Permissions àSearch for the user to whom you have to give permission àSelect the user and click on Add àand Select All checkbox if you have to give full access or enable specific permission which you want to give and click on Save.
Go back to Home page, click on Integrations to implement your use case by following the below steps.
Create a connection based on the FTP adapter that points to a standalone SFTP server
Create one more connection based on the FTP adapter that points to File Server..
Create an integration based on the scheduled file transfer pattern that reads files from the standalone SFTP server and writes them to File Server
Invoke SFTP Server to read the file and select the operation and provide Input Directory and File Name
5. Write the file to OIC File Server, while writing, you will have to provide the relative path of your directory starting from the /home directory, screenshot given below.
6. Edit “Map to writeFile” and map the the file reference from source to target as per the screenshot given below and click on Validate and click on Save to save your integration flow.
7. Define Business Identifiers for tracking and click on Save and close the integration
8. Activate the integration and run it by clicking on Submit Now
9. Monitor the instance. If it is successful, you can login to OIC File Server using FileZilla to verify the file. Otherwise, fix the error and execute it again.
10. Install FileZilla client, Open FileZillaàClick on FileàSite Manager àClick on New Site àSelect Protocol as “SFTP” and provide the remaining details like OIC File Server IP, PORT, Username and password and click on Connect
11. Go to the folder which you have specified as part of the Integration and could see the output file generated from OIC.
Learn more about File Server here.