Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Send/Push BIP Report Extraction file to Oracle Cloud Infrastructure (OCI)
Organization Name
JTI
Description
Hi All,
We need to send/push a Fusion BIP Report using standard scheduler option at Fusion BIP to Oracle Cloud Infrastructure (OCI).
Currently this feature is not present at Fusion BIP delivery options level, please include it in future release.
This feature will be really useful option for the customer where they wanted data extraction from Fusion BIP to Oracle Cloud Infrastructure (OCI).
SR Info: SR 3-22924743141 : How to send/push BIP Extraction file to Oracle Cloud Infrastructure (OCI)
Thanks
With Regards,
Kasinathan.P
Use Case and Business Need
This feature will be really useful option for the customer where they wanted data extraction from Fusion BIP to Oracle Cloud Infrastructure (OCI).
SR Info: SR 3-22924743141 : How to send/push BIP Extraction file to Oracle Cloud Infrastructure (OCI)
Original Idea Number: 3ad11f9839
Comments
-
Did you set Delivery in BIP like below?
You can enable SFTP on OCI, then configure the same SFTP with the SSH private key in BIP Administration. This is the configuration we are using for some customers to export BIP result to OCI SFTP.
0 -
Hi Adam,
Can you please share me step by step doumnet where I can enable the SFTP in OCI? And aslo if any end d to end document for this, this will be really help for me to move forward.Thanks in advance.
With Regards,
Kasinathan.P0 -
Kasinathan,
For Fusion BIP, please refer to these MOS docs,
Fusion Applications BI Publisher : How to request an external SFTP Port in order to deliver BI Publisher reports to an external SFTP server (Doc ID 1924562.1)
Oracle Fusion BI Publisher: How to setup private key authentication with sFTP delivery (Doc ID 2282898.1)
For OCI, please check OCI configuration document.
Thanks,
Adam0 -
Hi Adam,
I tried it, but I am getting the following error:
Fusion BIP FTP Delivery options Could not establish connection. HTTP proxy connection could not be established: 503 Service Unavailable
FYI: We are in SAAS. Do need raise and SR for this activity? I tried but getting above error not sure what am I missing here. please confirm.
Did you faced above error, during your setup at your end?
0 -
It's known issue with whitelisting. Did you deploy IP whitelisting on OCI SFTP? If not, please log a SR to find out your CX pods & proxy server IP addresses, which need to be configured on OCI for whitelisting.
0 -
This is not working for us. So, we are planning to transfer the file through UCM.
1. BIP Report data extraction will be schedule to UCM
2. From, UCM to the file will be moved to object storage.
We are working with the above workaround.
In future, We will hope that object storage will added as delivery option in BIP reports.
0 -
This is required at multiple client location for us.
0