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]
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