Configure FTP Server and use it in BI Report and Extract
Configure FTP Server and use it in BI Report and Extract

 1,218 total views

In this article we will look into how to setup the FTP (File Transfer Protocol) server and use it in BI Publisher Reports and HCM Extracts.

Want to learn Fusion Technical tools? Checkout this article

Let’s get started.

How to setup FTP server in BI Publisher:

Navigate to Tools > Reports and Analytics
Click on Browse Catalog to navigate to BI Catalog page.

BI Administration work area in fusion hcm oracle hcm cloud bi reports ftp setup
BI Administration > Manage BI Publisher
Click FTP to setup the FTP delivery option for BI Publisher
Click FTP
Click Add Server to add the FTP server
Click Add Server
Add the details and click on Test Connection to test the FTP access
Add the details and click on Test Connection
  • Server Name — example: myFTPserver
  • Host — example: myhost.company.com
  • Port — the default for FTP is 21.The default for Secure FTP (SFTP), is 22. If you wish to use the defaults at run time, you can leave this field empty, BI Publisher automatically uses 21 for FTP and 22 for SFTP. However, if you wish to use the Test Connection option from the UI, you must supply the correct port number in this field 21 for FTP or 22 for SFTP.
  • Use Secure FTP — Select this box to enable Secure FTP (SFTP). Ensure to set the correct Port as described above.
  • Use Passive Mode — Passive mode is recommended when the FTP server is behind a firewall.
  • Enter a username and Password for the server.

Once these details are entered, we can click on “Test Connection” and it will show successful when the username and passwords are correct.

I have setup a Dummy FTP Connection as below:

FTP Connection added successfully in BI Publisher Fusion HCM
FTP Connection added successfully

How to use FTP delivery option for BI Reports:

Navigate to BI Catalog again and let’s see how we can use the FTP option for generating the BI Publisher Output.

Click on More>Schedule to schedule BI Report
Click on More>Schedule
Add Destination as FTP and click Add Destination FTP BI Publisher Fusion HCM
Add Destination as FTP and click Add Destination
Select the FTP from dropdown and provide the file path and name BI Publisher Fusion HCM Oracle HCM Cloud
Select the FTP from dropdown and provide the file path and name

Input the Remote Directory were the file should be placed on the FTP server. And the Remote File Name is the override for the output file name.

After providing this, you can click submit. The report will run and generate the output on the FTP server.

How to use FTP delivery option for HCM Extracts:

We can setup the FTP delivery option in HCM Extracts like below:

FTP delivery option in hcm extract fusion hcm oracle hcm cloud
FTP delivery option in extract

There is no dropdown for server name and we need to type in the exact servername that we have configured in BI Administration area, else the extract will fail.

Also we need to input the Remote Directory and the Remote File Name which are the file path and file name for the output file.

Once the extract is run, the output will be placed on the FTP server.

Tip: Once the FTP server is setup, it is better to test it once by scheduling a BI Report or extract to see if everything is working fine or not.

Join our fastest growing technology social groups to interact with experts in the Fusion space and get your queries resolved – Telegram group, Facebook Page and LinkedIn Group

The following two tabs change content below.
Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.

Leave a Reply