Oracle Communities

Oracle Analytics and AI

Child Item

Send/Push BIP Report Extraction file to Oracle Cloud Infrastructure (OCI)

Kasinathan Palanikumar - Oracle-Oracle

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

Find more posts tagged with

Submitted

Status: Submitted

Comments

Adam Liu

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.

Kasinathan Palanikumar - Oracle-Oracle

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.P

Adam Liu

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,
Adam

Kasinathan Palanikumar - Oracle-Oracle

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?

Adam Liu

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.

Kasinathan Palanikumar - Oracle-Oracle

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.

Milind Dalvi

This is required at multiple client location for us.