Friday, February 22, 2013

Changing password of the MDS and BIPLATFORM schemas used by OBIEE 11g

At my current engagement, we are required to change the passwords for everything every 60 days. After doing some research I found a blog post by someone who showed how to do this from Enterprise Manager, but they only covered three of the four locations to change the password. As I have mentioned previously, I like automation, so I build a script which takes care of all the tasks.

After the jump is an example script, along with the python for WLST, to perform this task.

Tuesday, February 5, 2013

Scripted OBIEE 11g Web Catalog deployments using runcat.sh and WLST

I had never looked deeply into automating the OBIEE Web Catalog, as on previous engagements I had a technical architecture team which handled all deployments. They were used to doing a manual process utilizing the Catalog Manager. On my latest engagement, I am the technical architecture team, and I like automation.

After poking around, I found that you can call the catalog manager form the command line, and along with WLST scripting, you can do a fully automated web catalog deployment.

After the jump is a script which can be used to do OBIEE 11g web catalog deployments. This script assumes you have setup ssh keys on the various servers so you can login without typing a password (http://www.linuxproblem.org/art_9.html).

Scripted RPD deployments using UDML and WLST

Automating the RPD deployment in OBIEE 10g was as simple as doing an SCP of the RPD to the OBIEE server, and then bounce the processes. With OBIEE 11g, RPD deployments are now handled through Weblogic, so we need to take some additional steps. Luckily these can be easily scripted thanks to WLST.

After the jump is a script which can be used to do OBIEE 11g RPD deployments. This script assumes you have setup ssh keys on the various servers so you can login without typing a password (http://www.linuxproblem.org/art_9.html).

Creating a UDML file for OBIEE 11g RPD

The ability to use UDML for scripted OBIEE RPD changes has been around since OBIEE 10g. UDML files are very useful in order to do migrations, as they can contain the connection pool information and any variables which are environment specific. I am currently using UDML within our enivonrments to allow for migration of an RPD from Development through to Produciton.

Take a jump to view the steps to create UDML files for your environments, along with a sample UDML file.