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? 

Answering 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: 

Establishing connection to the OBI server: 

In the connection tab provide hostname, port and credential of the server. 

A connection message is displayed when the connection is established. 

Required Run Report Absolute path and format 

Submitting the job stream: 

Track/ monitor the submitted job: 

You can easily monitor the submitted job in WA through navigating to “Monitor Workload” page.  

Logs for the OBI server report creation: 

Generated report can be saved as different formats. The report looks like this: 

Report generation for OBI agent workstation: 

Submit the job stream with absolute path and format: 

Track/Monitor the job via “Monitor workload” page: 

Log for the OBI agent workstation: 

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. 

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: 

Establishing connection to the OBI server: 

In the connection tab provide hostname, port and credential of the server 

A connection message is displayed when the connection is established. 

 

path of the agent created by user in OBIEE 

Track/ monitor the submitted job: 

You can also easily monitor the submitted job in WA through navigating to “Monitor Workload” page.  

Logs for the agent creation  

Agent properties 

Alert window for the agents. 

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. 

Drop a mail at santhoshkumar.kumar@hcl.com for details on the plugins. 

Authors Bio 

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. 

www.linkedin.com/in/gaurav-kulkarni-62742b27 

 

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.

https://www.linkedin.com/in/akhilesh-chandra-442268a8  

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.

https://www.linkedin.com/in/roopa-karuti-080b7627/

 

 

Comment wrap
Further Reading
Automation | August 28, 2020
Manage your AWS resources by using AWSCloudFormation with Workload Automation
Let us begin with understanding of AWSCloudformation what it is all about before moving to our AWSCloudformation plugin and how it is benefits to our workload automation users.   AWS CloudFormation provides a common language for you to model and provision AWS and third-party application resources in your cloud environment. AWS CloudFormation allows you to use programming languages or a simple text file to model and provision, in an automated and secure manner, all the resources needed for your applications across all regions and accounts. This gives you a single source of truth for your AWS and third-party resources. Coming to our AWSCloudformation, below diagram summarizes what is our plugin can perform, so our workload customers can make use of this to simplify their infrastructure management as well as easy to implement changes to infrastructure.   To give more clarity on its benefits let us understand with below example,   For a scalable web application that also includes a back-end database, you might use an Auto Scaling group, an Elastic Load Balancing load balancer, and an Amazon Relational Database Service database instance. Normally, you might use each individual service to provision these resources. And after you create the resources, you would have to configure them to work together. All these tasks can add complexity and time before you even get your application up and running.   Instead, you can create or modify an existing AWS CloudFormation template. A template describes all your resources and their properties. When you use that template to create an AWS CloudFormation stack, AWS CloudFormation provisions the Auto Scaling group, load balancer, and database for you. After the stack has been successfully created, your AWS resources are up and running. You can delete the stack just as easily, which deletes all the resources in the stack....
Automation | August 28, 2020
Simplify The Data Loading Using Oracle UCM and HCM Data Loader plugins with Workload Automation
Customers using Oracle Human Resources Cloud face the challenge of continuous bulk loading of large amounts of data at regular intervals. Oracle Human Resources Cloud provides the tools like HCM Data Loader which address this business use case. Now you can automate data loading into Oracle Human Resources cloud using the Oracle UCM and Oracle HCM Data Loader plugins which leverage the HCM Data Loader for the Workload automation users. Business Process automated:       Source: https://docs.oracle.com/en/cloud/saas/human-resources/20a/faihm/introduction-to-hcm-data-loader.html#FAIHM1372446 The above diagram shows the business process automated through these plugins: This process is divided into 2 steps and hence the 2 plugins: A .zip file containing .dat files is placed on the Oracle WebCenter Content server. Here the Oracle WebCenter Content server acts as a staging infrastructure for files that are loaded and processed by the HCM Data Loader. HCM Data Loader imports the data first into its stage tables and then into application tables. Any errors that occur during either the import phase or load phase are reported in the job status and details in job log.   Technical description and workflow Oracle UCM plugin The Oracle UCM enables you to stage data files for processing to HCM Data Loader. It provides easier integration with other business processes by using the Oracle Universal Content Management (UCM) integration. The Oracle UCM Data Loader automates the process of bulk-loading of data. You can load the data files and monitor them from a single point of control. The data is uploaded as zip files to Oracle UCM, which is processed by the HCM Data Loader. This integration helps you save time, resources, and speed up data loading in a secure manner. Prerequisite for the plugins to work: - Oracle Human Resources Cloud service account with correct permissions to access File Import and Export task...
Automation | August 19, 2020
Workload Automation – Customer-centric approach
A customer-centric company is more than a company that offers good customer service. Customer-centric is our HCL Software business philosophy based on putting our customers first and at the core of business in order to provide a positive experience and build long-term relationships. In today’s uncertain world, not even the best contract can capture what will change tomorrow. A contract can only convert to business advantage through a value centric relationship. In the Workload Automation family, we strongly believe in customer collaboration and we have several programs that helps us to nurture relationship with our customers and involve them in the product design and evolution. The Client Advocacy Program is aimed to accelerate customer’s success and to create strategic relationships with HCL’s technical, management and executive leaders. The mission of our Client Advocacy Program is to build a direct relationship with our customers. We really want to be able to hear their voice. The User experience (UX) design in HCL is based on the Design Thinking approach, that relies on users to stay in touch with real-world needs. We work with users to design and build the solution to their needs through continuous participation of the same users in the design process. We really want to bring the user voice in the product design and development.   What this actually means? We take care of the relationship with each customer, no matter of the program. The programs are often just the first engagement: everything can start from a specific request or by pure chance. From the very first meeting with our customer we focus on addressing her/his needs and building trust, no matter if it happens in an Ask the Expert or in a Design Thinking session. We have tons of successful stories that have started from a simple question or even complaint. The entire product team takes care of each customer by looking for the subject matter expert to answer each question. The Customer Advocates often are the first point of contact in the entire organization. They are the customer best buddy; they nurture the relationship with constant...
a/icon/common/search Created with Sketch.