Business Intelligence – Oracle

Oracle BI EE 10.1.3.3/2 – Integrating Scheduler/Delivers into Other Applications

Posted by Venkatakrishnan J on March 6, 2008

Lets look at an important utility today that would enable Application developers to integrate BI Scheduler/Delivers into their application. That utility is called as SASchinvoke.exe. This enables end users to call/run ibots programmatically from any application(You dont have to come into Delivers). One of the major advantages of this utility is that you can run an ibot at any given time i.e You can call ibots on demand. You cannot do this from answers since all the ibots are triggered at specific time periods and you do not have the flexibility to call them on demand. Lets look at how to go about using this utility. You can find this in {OracleBI}/Server/Bin folder. The Syntax for the utility is as shown

Usage:   SASchInvoke.exe
-u <Admin Name>/<Admin Password>
                        (-j <job id> | -i <iBot path>)
                        ([-m <machine name>[:<port>]]
                        | -p <primaryCCS>[:<port>] -s <secondaryCCS>[:<port>])
                        ([(-r <replace parameter filename>
                            |-a <append parameter filename>)]
                         | [-x <re-run instance id>])
                        [-l
                         [-c <SSL certificate filename>
                          -k <SSL certificate private key filename>]
                         [-w <SSL passphrase>|-q <passphrase_file>|-y]
                         [-h <SSL cipher list>]
                         [-v
                          [-e <SSL verification depth>]
                          -d <CA certificate directory> | -f <CA certificate file>
                          [-t <SSL trusted peer CNs>]
                         ]
                        ]

This has a lot of options and you pass multiple parameters(we would not be discussing all of them). Lets look at a simple example of calling ibots using this utility. In order to execute an ibot, all we need is either the ibot’s Job id or its path. You can find the Job id from Job Manager.

      

In our case, lets run the ibot with a Job ID of 1.

saschinvoke -u Administrator/Administrator -j 1

      

      

We shall be using this utility in a variety of different applications which i shall be discussing in future blog entries. The above should give you a basic idea of what this can do.

Advertisements

4 Responses to “Oracle BI EE 10.1.3.3/2 – Integrating Scheduler/Delivers into Other Applications”

  1. Sonam Makhija said

    Hi! That’s a lot of useful information. Maybe you can give reference of this blog to techies on SiliconIndia.com. It would be very useful.

  2. waka said

    Hello, this is very userful.
    I want to know how to use the “parameter filename” option.
    Is it possible to send the parameter to the JavaScript file through the iBot job by using this parameter ?

    Thanks

  3. karthik said

    hi gurus,

    I am running an iBot using the saschinvoke command to generate a report in a remote location.

    Is there a way to find if the command has been succefully executed from the place where the command is scheduled/executed.

    Thanks

  4. anonymous said

    Hi,

    Thanks for posting this information however I am having an issue here. I am running following coomand similar to yours:
    “saschinvoke -u Administrator/Administrator -j 48”
    where 48 is my job id.
    But this command doesn’t seem to invoke my Ibot. I have just now started working on Delivers so don’t have in-depth knowledge. Could you help me in troubleshooting this issue. Many Thanks.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: