OTBI Agent with SFTP
Summary
Setting up an OTBI agent to invoke a server script
Content
Hello Everyone,
Does anyone have a documentation on how to setup an OTBI Agent to send a report output to another server?
It seems it can be done by invoking a server script in Agent Actions but I am looking for a more formal documentation on this.
I appreciate your help.
Thank you,
Alvaro Couto
Comments
-
This is a current shortcoming with OTBI - you cannot send the files. I ran into this issue last month so now have to use WinSCP for some reports while we decide whether to retrofit to BI. Please add your CSI to the ER - more of us the better!
Need the FTP delivery option when using OTBI Agent (iBot) (Doc ID 2006504.1)
Applies to:
Oracle Fusion Global Human Resources - Version 11.1.8.0.0 and later
Information in this document applies to any platform.Goal
You need to be able to schedule a large custom OTBI report from OBIEE to your FTP server. Currently the sFTP service is available only in BI Publisher.
Solution
An Enhancement Request was raised to enable the FTP feature in OTBI. You may track it using defect id 20990512.
You may use this document for tracking instructions: How to Monitor / Track ER a Bug from My Oracle Support (Doc ID 1298390.1)0 -
Moved to the correct forum.
0 -
Hi Sandra,
Hum...That's the reason I posted my question in this forum and thanks for quickly replying on that.
Please take a look in this solution. I found it on the Internet and I would like to have it a try.
https://wapcobiee.wordpress.com/2015/08/27/obiee-send-content-to-ftp-server-network-folder/
What do you think?
Thank you,
Alvaro Couto
0 -
Hi Sandra,
Just found this and I am posting it to save it: https://docs.oracle.com/cd/E21764_01/doc.1111/e18562/schedjobscripts.htm#BIESJ1471
Thank you,
Alvaro Couto
0 -
Hi Sandra,
I've just found out that VB and Java server scripts are not supported on Linux (or UNIX) environments (which is my case).
Instead, it seems we can use Java method (EJB-based Java action).
Thank you,
Alvaro Couto
0 -
Sandra,
It seems I can use invoke a Java EJB to get that done. This documents explains how to create this process - although the Java code just save the analysis in a file, I believe we can add some more code to do the sftp part.
A final question would be: the examples tells about PDF, HTML outputs but my final transferred file needs to be in Excel (xlsx) format.
I will research more tomorrow. Almost there.
Thank you,
Alvaro Couto
0