Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
SQL Authenticator Configuration for OBIEE 12.2.1.0.0
Answers
-
Under Provider Specific have you set all the requested SQL?
Have you tried to restart?
0 -
Yes.. I did.. and those users and groups listed in EM.. Now i am trying to add it to the application roles.. but it is not displayed while adding to application roles.
0 -
Do we need to configure data adapter other than the data source in weblogic? any config file ?
0 -
Yes, if you already haven't done so, you sholud configure database adaptor. Search in the documentation on the link I gave you for term "Configuring Database Adaptor".
Quick side note: If you make an error in adaptor configuration make sure you delete it and create another one, modifying the one with the errror won't work.
Just follow the documentation and everthing sholud work just fine.
0 -
Let me try it and will update you..
0 -
While configuring database adapter we need to execute the below script
./libovdadapterconfig.sh -adapterName userGroupAdapter1 -adapterTemplate adapter_template_usergroup1.xml -host 10.0.0.227 -port 9704 -userName weblogic -domainPath /app/Oracle/Middleware/Oracle_Home/user_projects/domains/bi2/ -dataStore DB -root cn=users,dc=oracle,dc=com -contextName default -dataSourceJNDIName jdbcSQLAUTH
below ERROR:
Could not find or load main class oracle.ods.virtualization.config.TemplateAdapter
any help will be highly appreciated.
But still same error
0 -
Verify that the environment variables are set:
ORACLE_HOME<span class="variable" style="font-style: italic;"><br/></span>WL_HOMEJAVA_HOME
0 -
Hello,
This is how it is displayed
0 -
According to what you have posted, your ORACLE_HOME should be /app/Oracle/Middleware/Oracle_Home and your JAVA_HOME should pint to jre folder.
0 -
Installed oracle client in /app/obiee .. So should i change it to /app/Oracle/Middleware/Oracle_Home? Also Java installed in the path abovce.. So which path i should use for java?
0
