Thalasar Ventures

Oracle Developers are increasingly providing services for Oracle Business Intelligence deployment and thus they need to involve better administration and management processes. Oracle enterprise manager is used for accomplishing these along with better deployment of fresh repositories and catalogues. Oracle developers can also perform changes to configuration which helps in advanced parameters, possibility of query caching and value addition through add-on components for better load handling.

For some instances better choice is development of scripts that enables accomplishment of above jobs. With the use of these scripts it is possible to apply post install alters to system, deployment of changes in bundles across numerous environments and automating tedious operations so human errors are eliminated. The enterprise edition 11g has included fresh features for enabling the scripting tasks. API is used to bring in functionality to the BI domain and it is full of JMS administration MBeans. If Oracle developers need to keep a track by monitoring the WebLogic server instances and domains then it could be performed using a powerful scripting tool named WebLogic Scripting Tool. Using these tools you can make the automation possible with BI processes or tasks.

As we are aware that Oracle Enteprise Manager Fusion Middleware Control facilitates admin staff to successfully perform the administration tasks of system. The tools do this with reaching MBeans that handles administration tasks and subset associated with API. If only you use API you can make sure that you have correctly applied all the configuration alterations. Further let us see how to use the API and usage of WebLogic Scripting Tool for working with JMX MBeans.

MBeans are used for performing common systems management tasks:

First step would be to add a new BI repository then next would be restarting the server component and you get the fantastic results of enabling repository available for queries. You are available with three options and using them by uploading you can make it accessible to users. All three are mentioned below:

BIInstanceMBean
BIDomainMBean
ServerConfigurationMBean

If in your Oracle BI suite you need using any of these then manual invoking is one option and calling them from Java app is another one. Leaving these both options behind if you wish to implement similar functions from script then WebLogic Scripting Tool is there to help you out. This one is used as command-line tool that can perform admin processes and view the configuration state. Those desiring its usage at the time they are online can type commands which results into instant action. While those who wish to use at the time they are offline then they can write a script for later action in batch form.

BI suite from Oracle with its new release of 11g has bought in immense new features and opportunities for Oracle developers to perform best deployments, developments and administration of environment. As above we saw how the administration processes are automated for making the deployment totally errors free.