Connection for the repository

Support Kitry

Hi,

We have done a migration from OBIEE 12.2.1.4 to OAS with a BAR file.

The connection pool used in that RPD use Session Variables to connect to the database regarding the "User" connected to "Analytics".

So the connection pool in the RPD is using the session variable to connect to the right database with

"Data source name" = "VALUEOF(NQ_SESSION.PROJECT_DSN)"

E.G. : Connection as user "TEST1" ⇒ session variable "PROJECT_DSN" = "DB_TEST1" and the data source name (the schema) used is "DB_TEST1"

With OAS in "Analytics" we are not able to create a analysis on the repository, the connection is not working.

Since in OAS the connections are defined in DV, do we need to create any connection in DV for using the repository ?

Or do we need to configure a tnsnames.ora file in OAS ?

Jean-Pierre