Create agents to send files to FTP/SFTP

Marco Foxx

Hi,

I am fairly new to Oracle Analytics and i wanted to create an agent which can store files (csv,xlsx) to FTP server.

I figure out how i can create an agent to email files which is based on analysis which i have created.

No FTP/SFTP configuration done so far exploring from where i should start to end.

Oracle Analytics 5.9 which is installed in linux server

Gianni Ceresa

Hi,

An agent in OAS can't send to FTP, just like it can't save on the filesystem. You will need to code custom actions if you want to achieve that.

Out of the box, the BI Publisher scheduler can save reports to FTP etc. But BI Publisher is different than analysis in OAS.

Marco Foxx

"You will need to code custom actions if you want to achieve that."

Thanks again

Code custom actions meaning in java ? As i read JS is also not supported to send files from OAS.

" BI Publisher scheduler can save reports to FTP etc"

would love explore this path, as eventually BIP is the way to go, only constraint is how i can i have both at the time, meaning OAS to display reports and BIP to send files ?

Gianni Ceresa

BIP is "inside" OAS, it comes together and so you already have BIP and OAS at the same time. The 2 do not interfere with each other. While BIP can use OAS subject areas as sources, everything else is independent: in BIP you will need to rebuild your reports and everything.

You can also display a BIP report as a "basic" interactive web report inside an OAS dashboard.

The code for the custom actions in OAS is Java, yes. There was VB code supported at some point but it was limited to Windows install if not wrong.

There aren't many examples about these custom codes, in MOS there was some content giving pieces of code, and here again some people did blog posts about it.

Marco Foxx

Can this be a helpful if i want to use javascript ?

https://docs.oracle.com/cd/E23943_01/bi.1111/e16364/actions.htm#BIEIT1728

To be honest i am exploring if there is an option for invoking agent JS on linux why cant we do that? Why oracle makes it so difficult to find content which can help OP to achieve this simple tasks.