Trigger agent asynchronously — Oracle Analytics

Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Trigger agent asynchronously

Needs Votes
91
Views
7
Comments
PeregoD
PeregoD Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server Idea Lab

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): SISAL LOTTERY ITALIA SPA


Description (Required): In OAC Agents can be triggered only by calendar event, we would like to launch agent automatically during a data workflow.


Use Case and Business Need (Required): Agent not triggered at a specific day/time but after a custom event.


Enhancement Request / Service Request: SR 3-30889800781

Tagged:
1
Up
1 votes

Needs Votes · Last Updated

Comments

  • Marcelo Finkielsztein
    Marcelo Finkielsztein Rank 6 - Analytics Lead

    @PeregoD

    Hello PeregoD,

    I have been able to develop a Web Service Client that launches OAC agents using a command line.

    I have been using it successfully for years.

    Oracle documentation is here: https://docs.oracle.com/cd/E23943_01/bi.1111/e16364/part_page_2.htm

    The solution requires some programming knowledge; I can explain what i did and offer help, if needed.


    Kindly,

    Marcelo Finkielsztein

  • PeregoD
    PeregoD Rank 3 - Community Apprentice

    Hello Marcelo,

    thank you very much for the link: but this is obiee 11. Is it working also in OAC?

    thanx,

    Daniele

  • Marcelo Finkielsztein
    Marcelo Finkielsztein Rank 6 - Analytics Lead

    Yes. I am running this in OAC.

  • PeregoD
    PeregoD Rank 3 - Community Apprentice

    Hi Marcelo,

    we are in a SSO environment.

    We've followed this doc to get the token (https://docs.oracle.com/en/cloud/paas/analytics-cloud/acapi/authenticate.html) and try to run the agent like this but i don't think it's supported

    curl -i --header "Authorization: Bearer <<TOKEN HERE>>" --request GET "https://<<OAC ADDRESS>>/analytics/saw.dll?RunIBotNow&AlertPath=AlertPath=<<AGENT PATH>>"

    any help will be appreciated :)

    thanx,

    Daniele

  • Marcelo Finkielsztein
    Marcelo Finkielsztein Rank 6 - Analytics Lead

    Hello Daniele,

    I will not be able to help you achieve OAuth authentication. If anyone else here can provide guidance on how to accomplish OAuth, i will really appreciate it!

    ---

    Not long ago, I tried to understand how to obtain an access token programmatically, (to improve my authentication method), following the same document you referred, but I failed.

    I filed an SR asking Oracle to help me but I was did not obtain good results; Oracle Support did not solve the problem for me. After a long back and forth and several long zoom sessions with them, I had to give up since I had higher priority tasks that required my attention.

    Again: If anyone else here can provide guidance on how to accomplish OAuth, i will really appreciate it!

    ---

    The solution I wrote uses authentication via userid and password, not SSO.

    Reference: https://docs.oracle.com/cd/E23943_01/bi.1111/e16364/methods.htm#BIEIT240

    Method: 3.8.8 - logon()

    Reference to the logon() method: https://docs.oracle.com/cd/E23943_01/bi.1111/e16364/methods.htm#BIEIT254


    Marcelo Finkielsztein

  • PeregoD
    PeregoD Rank 3 - Community Apprentice

    Hello Marcelo, thank you for your reply. We'll go deep into it - i've also opened a SR but Oracle closed the request becouse not a feature :(

    I'll post something here if we've found the solution.

    br,

    Daniele

  • Marcelo Finkielsztein
    Marcelo Finkielsztein Rank 6 - Analytics Lead

    Thank you. I look forward to that. Forza, Daniele! : )