Improvement Suggestion for Oracle Analytics Governance Plugin

Question

Good morning everyone!

I am using the new update of the Oracle Analytics Governance plug-in.

https://www.youtube.com/watch?v=oPQy1SezpRw

However, I see that we have two very important pieces of information that are not currently being returned and that would be essential for the traceability of workbook versions.

1. In the generated object SYS.DATASOURCES we have the column "description". It would be very interesting if we had this same column in the object SYS.WORKBOOKS. Because it is there that we inform the User History of the work and the versioning.

2. In the SYS.WORKBOOKS object we only have one row per workbook with the columns "created time" and "last modified". It would be important to have a separate file that returns all workbook updates so that we can have all the versions of the product that have been uploaded to the environment. If possible, it would add a lot of value to the governance of our workbooks/datasources.

Raphael Gonçalves Silva · Answer

Good morning everyone!

I have two questions for possible improvements to the Governance Plugin.

* Is it possible to bring the workbook description field to the API that generates the SYS_WORKBOOKS file?

* Regarding the SYS_DATASOURCES file, is it possible to bring data access?

Gianni Ceresa · Answer

As Philippe said, the catalog doesn't have any versioning logic in place, therefore it can't provide information about previous versions. There is a temporary "content versioning" because one of the table keeps the content of the object (workbook in this case) till a scheduled task clean up the un-linked rows. But those temporary versions aren't accessible by any API as they officially do not exist.

In OAC you can't do much other than running the extraction often, but even in this case you have no way to be sure that more than 1 change happened between the 2 executions.

In OAS, because you have access to BIPLATFORM schema, you could configure a trigger to keep old records when updates happen, but this is beyond the scope of this question.

Philippe Lions-Oracle · Answer

Thanks @Raphael Gonçalves Silva ,

The custom extension typically exports what the APIs exposes from the OA catalog. Unfortunately, I am pretty sure that API does not expose the history of workbook modifications - I suspect that information is probably not even stored in the webcat, probably only the last modif date is there. However for the workbook descriptions, let us double check if that data is available via the API. @Aravindan Thoppe Santharam-Oracle , @Prasenjit_Thakur-Oracle , would you know on top of your mind ?

+ @Lalitha Venkataraman-Oracle FYI