Friday, February 25, 2011

Oracle Data Miner 11gR2 available for download

It has been awhile since my last posting and decided to catch up by posting a couple of things I have been working on lately.

One of them is a topic which I am passionate about: Data Mining. A few weeks ago while at Boston I had the opportunity to visit an old friend of mine Charlie Berger (Senior Director PM Oracle Data Mining) in the Oracle office at Burlington.

 We had a short but nice conversation on the new release of ODM 11gR2. At the time of our conversation Oracle was getting ready to release it in OTN and it just made it last Tuesday Feb 22.
ODM 11gR2 is now part of SQLDeveloper ( currently in SQLDevelopers Early Adopters 3)

 and as such you need to download SQLDevelopers EA3 from this link:
Well the new good feature is that it now provides a graphical workflow to easily define the data flow and processes until final results for analysis are obtained. Here a screenshot of my first exercise with this tool.

It is really fantastic. This new GUI has long been waited for the Oracle Data Mining community.
We will post soon how Oracle Data Miner can be integrated with OBIEE to produce actionable analytical results. Stay tuned!

BI Publisher 10g: Switching from BI Server to XDO security mode

The BIEE10g default installation provides BIEE services as well BI Publisher services. Also, by default from this installation BI Publisher 10g is configured to authenticate all users through BI Server: “BI_SERVER”. But there is a way to switch BI Publisher from this pre-configured authentication mode to its own: “XDO”.
First, make sure all BIEE and BI Publisher (OC4J) services are down, next just (first make a back up of this file) modify the file xmlp-server-config.xml located at: C:\OracleBI\xmlp\XMLP\Admin\Configuration
and modify the entry from   <property name="SECURITY_MODEL" value="BI_SERVER"/>  to   <property name="SECURITY_MODEL" value="XDO"/>

Now, all you need to do is launch “Start OC4J” icon from your “Business Intelligence” programs group and immediately after BI Publisher will be running in stand alone mode. There is no need to have BI Server services running at all.

The predefined user for this setting is Administrator and password is Administrator. Now all users are controled and authenticated through BI Publisher interface.