Introduction
In modern Oracle Cloud implementations, integrations often require secure file exchange between systems. Organizations frequently need to transfer files such as employee data, supplier information, payroll extracts, or transaction reports between cloud applications and external systems. One feature that simplifies this process in Oracle Integration Cloud (OIC) is the Embedded File Server.
The Use Embedded File Server in OIC capability allows organizations to securely store, retrieve, and exchange files within Oracle Integration Cloud without requiring an external SFTP server. This feature is extremely useful for projects where organizations want a fully managed file repository integrated directly with OIC.
From an implementation perspective, consultants frequently use the Embedded File Server to:
Receive inbound files from external systems
Store integration output files
Share files with third-party systems through SFTP
Simplify architecture by avoiding additional infrastructure
In this article, we will explore how the Embedded File Server in Oracle Integration Cloud works, how to configure it, and how Oracle consultants use it in real-world integrations.
What is Embedded File Server in Oracle Integration Cloud?
The Embedded File Server is a secure SFTP-based file storage service built directly into Oracle Integration Cloud. It allows integrations and external applications to upload, download, and manage files using standard SFTP protocols.
Unlike traditional approaches where a separate SFTP server must be provisioned on infrastructure platforms such as OCI or on-premise servers, the Embedded File Server is fully managed within OIC.
Key characteristics include:
| Feature | Description |
|---|---|
| Managed SFTP server | Hosted directly within Oracle Integration Cloud |
| Secure authentication | Uses SSH keys and user authentication |
| Folder-level permissions | Supports multiple directories for different integrations |
| Accessible from integrations | OIC integrations can read/write files |
| External access | External systems can connect through SFTP |
This capability is particularly valuable in projects where file-based integrations remain critical, such as payroll processing, batch data transfers, and legacy system integration.
Key Features of Embedded File Server in OIC
The Embedded File Server provides several features that make it suitable for enterprise integration scenarios.
1. Built-in Secure SFTP Access
The file server uses SFTP protocol, ensuring encrypted communication between external systems and Oracle Integration Cloud.
2. Multiple User Accounts
Administrators can create multiple users, each with different folder permissions.
This enables separation between:
HR integrations
Finance integrations
Supplier file uploads
Payroll batch processing
3. Folder-Level Security
Users can be assigned specific directories such as:
/outbound
/archive
/hr_files
/finance_files
Each integration or external system can access only its permitted folders.
4. Integration Connectivity
OIC integrations can easily interact with the embedded file server using the FTP Adapter.
Typical operations include:
Read file
Write file
List files
Move files
Delete files
5. No Additional Infrastructure
Since the service is embedded within OIC:
No OCI compute instance required
No server maintenance
No patching or monitoring required
This significantly simplifies integration architecture.
Real-World Integration Use Cases
Use Case 1: HR System Sending Employee Files to OIC
A company receives daily employee data files from an external HR system.
Process flow:
External HR system uploads file to OIC Embedded File Server
OIC integration reads file using FTP Adapter
Integration processes employee data
Data is sent to Oracle HCM Cloud using REST APIs
Example file:
Benefits:
Secure file transfer
Automated processing
Reduced manual intervention
Use Case 2: Supplier Invoice File Processing
A supplier uploads invoice files to OIC.
Process flow:
Supplier uploads invoice XML files to
/supplier_invoicesOIC integration polls folder every hour
Integration validates file format
Data is sent to Oracle ERP Cloud Payables
Benefits:
Automated invoice ingestion
Integration monitoring
File validation before processing
Use Case 3: Outbound Payroll Files
Payroll results need to be shared with a third-party payroll provider.
Process flow:
Oracle HCM Cloud generates payroll extract
OIC integration processes data
Integration writes output file to Embedded File Server
Payroll provider downloads file via SFTP
Benefits:
Secure data sharing
No dependency on external file servers
Architecture and Technical Flow
A typical Embedded File Server integration architecture looks like this:
|
| (SFTP Upload)
|
Embedded File Server (OIC)
|
| FTP Adapter
|
OIC Integration Flow
|
| REST/SOAP/ERP Adapter
|
Oracle Fusion Applications
Steps involved:
External system uploads file
Integration polls folder
File is processed
Data is transformed
Data is sent to target system
File is archived or deleted
This architecture supports both inbound and outbound file integrations.
Prerequisites
Before using the Embedded File Server in OIC, the following prerequisites must be completed.
1. Oracle Integration Cloud Access
Users must have roles such as:
Service Administrator
Integration Developer
2. FTP Adapter Enabled
Ensure the FTP Adapter is available in the integration instance.
3. SSH Key Pair
For secure authentication, create an SSH public-private key pair.
Example command:
The public key will be uploaded to OIC.
4. Network Connectivity
External systems must allow outbound connection to the OIC SFTP endpoint.
Step-by-Step Configuration of Embedded File Server
Step 1 – Navigate to File Server Settings
Navigation:
Here you can manage:
Users
Directories
SSH keys
Step 2 – Create a New File Server User
Click Create User.
Provide the following details:
| Field | Example Value |
|---|---|
| Username | hr_file_user |
| Description | HR file upload user |
| Authentication | SSH Public Key |
Upload the public key generated earlier.
Save the configuration.
Step 3 – Create Directories
Next, create directories for file storage.
Example:
| Directory | Purpose |
|---|---|
| /hr_inbound | HR files uploaded by external systems |
| /hr_archive | Processed files |
| /payroll_outbound | Files generated by OIC |
Directories help organize file-based integrations.
Step 4 – Assign Folder Permissions
Assign directory access to the user created earlier.
Example:
Access: /hr_inbound
Permission: Read / Write
Save configuration.
Step 5 – Retrieve SFTP Connection Details
OIC provides the SFTP endpoint.
Example:
External systems will use:
Username
Private key
Port 22
Step 6 – Create FTP Adapter Connection in OIC
Navigation:
Select FTP Adapter.
Provide details:
| Field | Example |
|---|---|
| Connection Name | Embedded_File_Server |
| Host | file.integration.oraclecloud.com |
| Port | 22 |
| Security | SFTP |
Upload private key if required.
Test the connection and activate it.
Step 7 – Build Integration
Create a scheduled integration that reads files.
Navigation:
Choose:
Add FTP Adapter as trigger.
Configure:
Operation: Read File
Directory:
/hr_inboundFile pattern:
*.csv
Process the file and send data to the target system.
Testing the Integration
Once the configuration is completed, perform testing.
Test Scenario
Upload a sample employee file.
Example file:
Upload using SFTP client:
Examples:
WinSCP
FileZilla
Command-line SFTP
Example command:
Upload file:
Expected Results
File appears in
/hr_inboundScheduled integration detects the file
Integration processes the file
File moves to archive folder
Validation Checks
Consultants should verify:
File processed successfully
No integration errors
Target system received data
File archived after processing
Common Errors and Troubleshooting
Error 1: Authentication Failed
Cause:
Incorrect SSH key
Wrong username
Solution:
Verify SSH public key uploaded in OIC
Error 2: Permission Denied
Cause:
User does not have directory access
Solution:
Assign correct folder permissions
Error 3: FTP Adapter Cannot Connect
Cause:
Incorrect host configuration
Solution:
Verify:
Port
Authentication method
Error 4: Integration Cannot Find File
Cause:
Incorrect file pattern
Example:
File name matching is case-sensitive.
Best Practices Used by Oracle Integration Consultants
1. Use Separate Directories for Each Integration
Example:
/erp
/scm
/payroll
This avoids file conflicts.
2. Archive Processed Files
Always move processed files to archive directories.
Example:
This prevents duplicate processing.
3. Implement File Naming Standards
Example:
PAYROLL_RUN_001.xml
Consistent naming simplifies automation.
4. Use PGP Encryption for Sensitive Files
For payroll or financial data, use PGP encryption before transferring files.
5. Monitor Integrations
Use OIC Integration Monitoring Dashboard to track file processing.
Navigation:
Summary
The Embedded File Server in Oracle Integration Cloud is a powerful feature that simplifies file-based integrations without requiring external infrastructure. It provides a secure and scalable way to exchange files between Oracle Cloud applications and external systems.
By using the Embedded File Server, organizations can:
Reduce infrastructure dependencies
Securely exchange files using SFTP
Automate batch integrations
Simplify integration architecture
In real-world projects, Oracle integration consultants frequently use this capability for HR data transfers, supplier invoice processing, payroll file exchange, and batch ERP integrations.
When implemented with proper folder structures, security controls, and integration monitoring, the Embedded File Server becomes a reliable foundation for enterprise file integrations.
For additional technical details, refer to the official Oracle documentation:
https://docs.oracle.com/en/cloud/paas/integration-cloud/file-server/index.html
Frequently Asked Questions
1. What is the purpose of the Embedded File Server in Oracle Integration Cloud?
The Embedded File Server provides a secure SFTP-based file repository within Oracle Integration Cloud, enabling integrations and external systems to exchange files without requiring external infrastructure.
2. Which adapter is used to interact with the Embedded File Server?
The FTP Adapter is used within Oracle Integration Cloud integrations to read, write, list, and manage files stored in the Embedded File Server.
3. Is the Embedded File Server secure for enterprise integrations?
Yes. It supports secure SFTP connections, SSH key authentication, and directory-level access control, making it suitable for enterprise file transfer scenarios.