BI Commentary Application - DB and schema?

[victortorreblanca]

Dear all,

I want to explore the Commentary Application for my Webi Reports.

I see per default it's selected the Audit DB as the DB to store comments.

1) Do you know under what schema are these comments stored?

2) If I decided to choose a different DB, like HANA DB...in the options it gives to setup the connection (server, port, user, pwd...) I don't see mention to schema...do you know what schema name will it create in my HANA DB?

Thanks, best regards

Victor Torreblanca

[bernhard_keimel]

I am not sure what exactly you are referring to when you say "schema". I realized that depending on which database you are using, "schema" can have different meanings in the architecture. For Oracle databases, what i am using mostly, the schema is more or less the same as the user you use to connect to the database.

But this may be a help: 

• To find out which schema the Auditing Database is using (and then the default commentary config), just check in CMC - Auditing.
• BO uses JDBC to talk to the commentary database - the "Connection Name" contains the connection string for JDBC that itself also contains the schema name, depending on the underlying database
• BO does not create a schema (in terms of database user for oracle), you need to set that up in the database itself (it must have the rights to create tables) and configure the connection in the CMC
• There is one table COMMENTARY_MASTER that is created by BO when you setup commentary application, nothing to do on your side

My experience is that it is the easiest way to just use the Auditing database for commentary. There is no effort on your side to set it up and when it comes to troubleshooting it is also way easier to manage that.

[victortorreblanca]

Hi Bernhard, thanks for your reply 🙂

yes, I want to use the Audit DB, I just think something has to be done there, to allow the Comments to be stored.

In CMC > Applications > BI Commentary Application I have "Use Audit Database"

I see the Commentary Service in one of my APS servers

But when I try to Save a comment, nothing happens. I never see that comment again.

I had a look at the CMC > Auditing and saw that in the left part, there is nothing active regarding comments.

I imagine I have to activate these checks to make the store of comments available, right?

Thanks, best regards

Victor