WORKLOAD AUTOMATION COMMUNITY
  • Home
  • Blogs
  • Forum
  • Resources
  • Events
    • IWA 9.5 Roadshows
  • About
  • Contact
  • What's new

Agents and Reports: Oracle Business Intelligence, A step ahead with Workload Automation

7/17/2020

0 Comments

 
Picture
Are you familiar with Automation Hub! It is the time. 

Data! We have enough data to process.
 

Analyze! We have multiple 
software and algorithms to analyze and process the data. 

Question is how to represent or publish the processed data together as a report. 
There are few which do this favor. 

But, will the generated reports be flexible for reuse? Will the report maintenance be easy? Will they have an optimized data extraction and data generation process?
 

​Answer
ing is tough. Because it is not easy to maintain and produce efficient reports from huge data consistently with an ease. 
Big fishes like Oracle, IBM will have the trick to satisfy the customer with the required features. ​
There comes our plugin OBI Run Report to answer all the queries with minimal effort which is associated with Oracle BI publisher. This can be combined with the workload automation tool by the users. 

Yes, reports are generated and published with the requirements. How to reach them to the customers. Simple answer is by using agents. Agents can deliver the reports to the customers based on the trigger events and the targets. Targets can be different, in other way, the delivery routes can be varying by multiple conditions and requirements. 

Agents are triggered by schedules or conditions that in turn generates a request to perform analytics on data based upon defined criteria, which can be used for reports scheduling as well as alerts sent to the required recipients on different web accessible / communication devices. 

Agents also provide proactive delivery of real-time, personalized, and actionable intelligence throughout the business network. 

​As a next block of feature, we introduce OBI agent which help to satisfy the requirement. This plugin shares the features with Oracle iBot/agent in all aspects and they are part of session-based web services and associated with workload automation. 
 
Technical description and workflow

OBI Run Report plugin 
Defined from the business use case that Oracle BI publisher provide pixel-perfect published reporting solution for enterprise reporting needs and customers can create BI Publisher reports using host of features provided in the Report Designer to suit their requirements. 

With OBI Run Report plugin they can run a specific report in the BI Publisher Server and save the generated report to defined location. 
 
Prerequisite for the plugins to work: 
-OBIEE 12C or above installation 
 
 
BI Publisher reports can be generated in 2 ways by this plugin.  
  – On OBI server  
  – On Agent Workstation  
 
For both the cases must provide the path for report generation. 
 
Log in to the Dynamic Workload Console and open the Workload Designer. Choose to create a new job and select “Oracle Business Intelligence Run Report” job type in the ERP section: ​
Picture
Establishing connection to the OBI server: 
In the connection tab provide hostname, port and credential of the server. ​
Picture
A connection message is displayed when the connection is established. ​
Picture
Required Run Report Absolute path and format ​
Picture
Submitting the job stream: ​
Picture
Track/ monitor the submitted job: 
You can easily monitor the  submitted  job  in WA through navigating to “Monitor Workload” page.  ​
Picture
Logs for the OBI server report creation: ​
Picture
Generated report can be saved as different formats. The report looks like this: ​
Picture
Report generation for OBI agent workstation: ​
Picture
Submit the job stream with absolute path and format: ​
Picture
Track/Monitor the job via “Monitor workload” page: ​
Picture
Log for the OBI agent workstation: ​
Picture
OBI agent plugin 

iBot or agent (OBIEE) 

software-based intelligent agents utility used for reports scheduling as well as Alerts sent to the required recipients on different web accessible/communication devices. Used to access, filter, perform analysis on data and that execute requests and generate responses to the appropriate people and devices. 

Elements contains: - 
  – Priority and visibility 
  – Conditional request 
  – Schedule 
  – Recipients 
  – Delivery content 
  – Destination 

​The agent can be event-based or scheduled and provide constant monitoring and intelligence spanning operational and business intelligence sources. 
 
Architecture: - 
​

OBIEE (Oracle Business Intelligence Enterprise Edition) 
Business Intelligence (BI) is tool by Oracle Corporation which has a prove architecture and common infrastructure producing and delivering enterprise reports, scorecards, dashboards, ad-hoc analysis, predictive alerts, notifications and OLAP analysis provides a rich end-user experience. ​
Picture
Components of OBIEE. 
 
Prerequisite for the plugins to work:  
- Oracle Business Intelligence 12c (12.2.1.4.0) 
- Oracle Database 12c 
- Oracle Fusion middleware12c (12.2.1.4.0) 
- Credentials and roles for user to establish a connection with OBI Server and run OBI Agent. 
 
For more details, use the official Oracle Documentation 
 
https://docs.oracle.com/middleware/bi12214/biee/index.html 
https://docs.oracle.com/cd/E17904_01/bi.1111/e10541/deliversconfigset.htm#BIESG1360 
 
Log in to the Dynamic Workload Console and open the Workload Designer. Choose to create a new job and select “Oracle Business Intelligence Run Report” job type in the ERP section: ​
Picture
Establishing connection to the OBI server: 
In the connection tab provide hostname, port and credential of the server ​
Picture
A connection message is displayed when the connection is established. ​
Picture
path of the agent created by user in OBIEE ​

Picture
Track/ monitor the submitted job: 
You can also easily monitor the submitted job in WA through navigating to “Monitor Workload” page.  ​
Picture
Logs for the agent creation  ​
Picture
Agent properties ​
Picture
Alert window for the agents. ​
Picture
Picture
Data is endless. Best way to oversee them is finding a friend who handle it with ease and wise. 

Workload automation can help you for what you are looking at. 

​D
rop a mail at santhoshkumar.kumar@hcl.com for details on the plugins. ​

Picture
Picture

Author's Bio
Picture
Gaurav Kulkarni, Technical Specialist at HCL Software 

Experience in Java technologies like Hibernate, Spring boot, Web Services and REST APIs, UI technologies like native JavaScript, jQuery, ReactJS, python flask, Databases like Postgres, Oracle. Enthusiast about full stack software development and other similar technologies. ​
View my profile on LinkedIn
Picture
Akhilesh Chandra, Developer at HCL Software 
 
Java Developer, Experience in Cross Domain, Working Experience in Spring framework, Spring Boot, web services, Core java, J2EE and Database. 
Interested in artificial intelligence, python, machine learning and data science. ​
View my profile on LinkedIn
Picture
Rooparani Karuti – Senior Test Specialist at HCL Software 
 
Working as senior test specialist for wo Workload Automation team in HCL Software, Bangalore. Worked both in manual and automation test scenarios across various domains. ​
View my profile on LinkedIn
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Archives

    March 2023
    February 2023
    January 2023
    December 2022
    September 2022
    August 2022
    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    December 2021
    October 2021
    September 2021
    August 2021
    July 2021
    June 2021
    May 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    January 2020
    December 2019
    November 2019
    October 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017

    Categories

    All
    Analytics
    Azure
    Business Applications
    Cloud
    Data Storage
    DevOps
    Monitoring & Reporting

    RSS Feed

www.hcltechsw.com
About HCL Software 
HCL Software is a division of HCL Technologies (HCL) that operates its primary software business. It develops, markets, sells, and supports over 20 product families in the areas of DevSecOps, Automation, Digital Solutions, Data Management, Marketing and Commerce, and Mainframes. HCL Software has offices and labs around the world to serve thousands of customers. Its mission is to drive ultimate customer success with their IT investments through relentless innovation of its products. For more information, To know more  please visit www.hcltechsw.com.  Copyright © 2019 HCL Technologies Limited
  • Home
  • Blogs
  • Forum
  • Resources
  • Events
    • IWA 9.5 Roadshows
  • About
  • Contact
  • What's new