SQL Authenticator Configuration for OBIEE 12.2.1.0.0 - Page 2 — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

SQL Authenticator Configuration for OBIEE 12.2.1.0.0

Received Response
191
Views
22
Comments
2

Answers

  • Antonija Mandić
    Antonija Mandić Rank 3 - Community Apprentice

    Under Provider Specific have you set all the requested SQL?

    Have you tried to restart?

  • Sunny86
    Sunny86 Rank 6 - Analytics Lead

    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.

  • Sunny86
    Sunny86 Rank 6 - Analytics Lead

    Do we need to configure data adapter other than the data source in weblogic? any config file ?

  • Antonija Mandić
    Antonija Mandić Rank 3 - Community Apprentice

    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.

  • Sunny86
    Sunny86 Rank 6 - Analytics Lead

    Let me try it and will update you..

  • Sunny86
    Sunny86 Rank 6 - Analytics Lead

    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

  • Antonija Mandić
    Antonija Mandić Rank 3 - Community Apprentice

    Verify that the environment variables are set:

    • ORACLE_HOME<span class="variable" style="font-style: italic;"><br/></span>
    • WL_HOME
    • JAVA_HOME
  • Sunny86
    Sunny86 Rank 6 - Analytics Lead

    Hello,

    This is how it is displayed

    pastedImage_0.png

  • Antonija Mandić
    Antonija Mandić Rank 3 - Community Apprentice

    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.

  • Sunny86
    Sunny86 Rank 6 - Analytics Lead

    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?