OAS DV Auto Reload Data from Excel

Question

Hello,

Please let me know if i made this post in the wrong group. I tried searching for OAS Group but didn't find any.

We are currently testing OAS 5.5.0.

One of our requirements is to directly import data from BI Publisher into DV and create visualizations on op of it. I tried searching on ways to do that but didnt find much so ended up creating python script to extract data from report and put it in shared folder.

For next step i uploaded that file in OAS DV as dataset.

I want to know is their an auto reload process for dataset created from excel which i can use to automatically reload the data from that file.

Thank You.

Gianni Ceresa · Answer

As said, an Excel file isn't a "shared" storage by default. It's a file coming from a user and loaded "one-shot" on the server. You can update it, but the action is you reloading the Excel file. You can't expect OAS to be able to come and read your file automatically all the time, because OAS isn't allowed to read things on a user laptop for example.

In the UI you can reload the file to refresh it's content stored in OAS, you would need to do that. There is a webservice call doing the same, that's maybe something to explore for your case.

Shams Abbasi · Answer

I am sorry i was not able to frame the question right.

Following is the scenario which we are trying to produce.

We have a dataflow which is using data from 2 connections and one excel file(The excel file gets generated from Bi Publisher).

When i run the data flow it reloads data from the sources but not the excel file, so i wanted to know if their is a way to reload that data from excel file automatically as well so we can have a completely seamless dataflow.

Thanks.

Gianni Ceresa · Answer

Hi,

Oracle planned to cover OAS in the same place as OAC, in the other "forum" : https://cloudcustomerconnect.oracle.com/resources/0591c7239f/summary

It sounds strange the requirement of "import data from BI Publisher into DV" mainly because Publisher doesn't store data but, just like DV, supports connecting to various sources to have data for the reports built on top. Therefore you could create the same connections in DV and go with that directly.

As an Excel file source is something a user is supposed to own, there isn't an automated reload because it's the user who can re-upload the same file to refresh data. You will have to explore that approach.

You are just doing things like if all you have is Excel files, therefore you must keep going like that: if you open the datasource being your Excel you can re-upload a file to refresh the content.