SQL Authenticator Configuration for OBIEE 12.2.1.0.0

Sunny86

Dear All,

configuring sql authenticator in weblogic

We are trying to configure sql authenticator to authenticate from a db table

for that we have completed below steps.

1)Created a datasource to oracle db

a)connection tested and succeeded and deployed it to the admin server and BI server as target

2)Created a readonlysqlauthenticator and wrote the queries for

  a)SQL Get Users Password:

  b)SQL User Exists:

and made the control flag sufficient for both default authenticator and the new sql authenticator

and restarted all the services. But unable to login with the database user and couldnt find those users in the users in security realm.

Do we need to do any further configuration to make those users available in users and groups ?

Do we need to fill other provider specific queries?

How to find the exact root cause of the error ?

any help will be highly appreciated.

TN

Antonija Mandić

Hi,

you have all the steps needed to configure database authentication described in documentation:

https://docs.oracle.com/middleware/12213/biee/BIESC/GUID-99968A33-0D49-41AE-83CC-A3CA4112E9F1.htm#BIESC6096

From what I can see you are missing database adapter and virtualized identity store configuration.

Kind regards,

Antonija

Sunny86

I have used the same steps as below..

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/wls/12c/12_2_1/sqlauthenticator/sqlauthenticator.html

Sunny86

I am able to find the users and groups in weblogic now? Should i map the application roles from Fusion Middleware?

[Deleted User]

You haven't said what you did to make it work, so a bit hard to follow...

But in general: Yes. You must do the mapping in Enterprise Manager now.

Antonija Mandić

Have you configured database adaptor?

Sunny86

Yes Configured  Data source for oracle and it successfully connected.

Sunny86

Earlier i created some dummy tables and inserted some users to it and tried to modify the SQL Authenticator query for those tables. Now i have created the exact same tables mentioned in the tutorial and it listed the users and groups in weblogic. Now How to add those groups to the existing application roles. When i tried to add new group in to an existing application role, Search result doesnt included the new groups from DB

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/wls/12c/12_2_1/sqlauthenticator/sqlauthenticator.html

[Deleted User]

Have you added the VIRTUALIZE=TRUE parameter?

Sunny86

No.. .. I didnt know about it.. Let me add and check.

Sunny86

Those groups and users are not listed when i try to search for adding to application roles ..