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]