Monday Mar 24, 2014

BI Web service security client - authentication operations for 11.1.1.6 and 11.1.1.7.x

This wlst/python script connects to bi security web service to authenticate a user specified in the "ObieeWebServiceClient.properties" file. In 11.1.1.7, this calls: getAuthenticatedUserWithLanguageAndProperties operation of the /bisecurity/service web service.

In 11.1.1.6, this calls authenticate operation of the /bimiddleware/security/service web service.

This returns as part of the xml response the user unique identifier (guid) and other permissions/roles for the user. This is useful when debugging an issue with OBIEE security.

The script has to be run with %ORACLE_HOME%\oracle_common\common\bin\wlst.cmd (sh)

Script is available there: https://blogs.oracle.com/pa/resource/ObieeWebServiceSecurityClient.zip

[Read More]

Thursday Feb 27, 2014

OBIEE 11.1.1 - Advanced Usage of nqcmd command

Following are the useful nqcmd command lines arguments:

a. In your environment set the "export SA_NQCMD_ADVANCED=yes"

b. Following is the description of the nqcmd command line arguments for BIServer (nqsserver) testing:

-d = Datasource.
-u = username.
-p = password.
-s = inputsqlsfile.
-o = outputfile. counters will be in outputfile_Counters.txt.
-td <secs> = timeduration in secs. nqcmd will run until <secs> elapses.
-qsel r = select queries random manner from inputsqlsfile.
-ds <secs> = dump statistics to outputfile_Counters.txt every <secs>.
-T = Timer is on. Otherwise you won’t get correct statistics.
-t <number> = generate users . if you give -t 50, 50 users will be there.
-q = turn off row output - mandatory flag for nqsserver load testing.
-n <number> = used for login test run for <number> iterations.
-w = thinktime (in seconds).

[Read More]

Monday Feb 03, 2014

BI Checks with WLST - Enable debug, login and parse logs - Part 3

This third post continues with the BIEE Security checks using WLST and Python scripting.[Read More]

Tuesday Jan 28, 2014

BI Check with WLST - SQL Datasources part 2

This second post continues with the BIEE security checks using WLST and python. This time, the following information is gathered about BISQLGroupProvider:

*  looking for SQLGroupProvider in the configured providers
*  retrieving the SQL queries
*  retrieving the JDBC source details
*  testing the connection pool, for each server that uses it (make sure your BI server is up and running)
*  testing the SQL queries directly against the database, with the test.user and test.group provided in the automation.properties file

[Read More]

Friday Jan 24, 2014

BI Check with WLST - Providers and Technical users part 1

 Checking OBIEE 11.1.1.7.1 security configuration manually is relatively time consuming. Using WLST and Python, it is possible to automate most of these tasks. The following script performs checks on OBIEE configuration. It is the first of a 3 part series.[Read More]

Monday Dec 09, 2013

OBIEE Web services with javascript

OBIEE web services provide a large set of operations on ibots, jobs, metadata, analysis, webcat...
http://docs.oracle.com/cd/E21764_01/bi.1111/e16364/soa_overview.htm
http://docs.oracle.com/cd/E23943_01/bi.1111/e16364/methods.htm

A wsdl is provided for these services, and it is common to call them in a process running in Weblogic server (java custom application).  However, it is also possible to call them using javascript in a browser, or in a server with a javascript engine (Nodejs.org, or else).


 

[Read More]

Thursday Jul 18, 2013

OBIEE cluster web SSO - ADFS IdP SAMLv2

We posted how to configure OBIEE for SSO using SAML and ADFS , on a single node previously --> there: https://blogs.oracle.com/pa/entry/obiee_web_sso_with_adfs

This post describes  how to perform the same, but with a clustered OBIEE deployment. The main change is regarding the necessary use of aWeblogic RDBMS security store to cache SAML assertions across nodes, as well as the configuration of the load balancer.[Read More]

Wednesday Feb 22, 2012

OBIEE 11.1.1 / EPM 11.1.2 - WebLogic Server 10.3.x takes long to startup on RHEL 5.x.

WebLogic Server 10.3.x takes long to startup on RHEL 5.x. About 7 mins then eventually comes up in running mode. After this when you enter username and password on the WLS console, it takes 5-8 mins to come up.

Issue is that OS was running out of random number generation, and that caused the delay in startup. Following solutions will resolve this issue.

Possible solutions:

1) mv /dev/random /dev/random.ORIG ; ln /dev/urandom /dev/random
Note: The above mentioned solution is not recommended, though it does the job.

2) Add “-Djava.security.egd=file:///dev/urandom” to java parameters (JAVA_OPTIONS in setDomainEnv.sh file).

Note: This article applies to OBIEE 11.1.1.x and EPM 11.1.2.x


Tuesday Nov 29, 2011

OBIEE 11.1.1 - Introduction to OBIEE 11g Full Sample App

Introduction to OBIEE 11g Full Sample App

Isn't it nice
.. to discover OBIEE 11g around a nice "How To" catalog of features?
.. to observe OBI and Essbase relationships at work?
.. to discover TimesTen?

[Read More]
About

A blog focused on Tips & Tricks about Oracle Business Intelligence (OBI), Oracle Exalytics and Oracle Enterprise Performance Management (EPM) products.
[Blog Admin: ahmed awan]

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today