Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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_HOME
JAVA_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