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

Workload Automation and HANA database: a perfect integration

10/3/2018

5 Comments

 
Picture
Here is the most frequent question about SAP and Workload Automation: “Is Workload Automation integrated with HANA database?” The answer is YES! In this article, I will explain what this integration means and will guide you through it. Do you know what SAP HANA actually means? 
​
SAP HANA or High-performance ANalytic Appliance, is an application that uses in-memory database technology and allows the processing of massive amounts of real-time data in a short time. 

The in-memory computing engine allows HANA to process data stored in RAM as opposed to reading it from a disk. 

This allows the application to provide instantaneous results from customer transactions and data analyses.
Picture
Using Workload Automation, you can trigger on HANA database, both SQL queries and Stored Procedure. 

HANA offers an integration using jdbc driver for java client.

Picture
With the following few steps you will be able to trigger your SQL queries or stored procedure into your HANA database. 

Step 1. Locate the JDBC driver 
The driver (ngdbc.jar), which is installed as part of the SAP HANA client installation, is located at (unless otherwise specified during the installation): 
  • For Microsoft Windows platforms: C:\Program Files\SAP\hdbclient\ 
  • For Linux and UNIX platforms: /usr/sap/hdbclient/
​
Step 2. Copy the JDBC driver in your Workload Automation preferred location
Picture
Step 3. Create a Workload Automation database job type using the Dynamic Workload Console 
a. Access the Workload Designer:
Picture
b. Select Database job type:
Picture
Step 4. Create a Workload Automation database job type 
  • Enter the required information 
  • For the Port number, use the following pattern: 3<instance number>15
Picture
Make a test connection to very that the configuration is correct:
Picture
You can also specify one or more failover servers by adding additional hosts, as in the following example: jdbc:sap://HANA_SERVER_1:30215; HANA_SERVER_2:30215; HANA_SERVER_3:30215
You can also directly test or use the SAP HANA JDBC driver from the command line:

    
For more information about the JDBC Connection Properties, you can check the online documentation. 

Step 5. Write your SQL HANA query in the SQL tab
Picture
Step 6. Write your Stored Procedure in the SQL tab
Picture
If the required parameters can be retrieved using “Lookup Parameters”:
Picture
This is an example of the job run result:
Picture
By adding one or more database type jobs to the job stream that automates your entire business process flow, you can schedule your SQL statements and stored procedures on a SAP HANA database directly, as part of your enterprise workload, using Workload Automation as a unique point of control.  Stay tuned for my next article on SAP topics. 
For comments, write to marco.borgianni@hcl.com.
Picture
Marco Borgianni
Senior Technical Specialist 

Marco is a Senior Technical Specialist Engineer and is working as a services for Workload Automation, an IBM + HCL product. Marco has been working in the Workload Automation team since 2000 as a developer, Level 3 Service Specialist, finally services acquiring a deep knowledge of customers' needs in that area. Marco is interested in everything that is related to supporting customers in their technological challenges. With a background in computer science technologies, in the design and development of integrations with ERP and Business Analytic tools.
5 Comments
grabmyessay legit link
10/10/2018 07:48:48 am

If you're the type of person who works under Information Technology industry, I am pretty sure that you are familiar with SAP HANA or High-performance ANalytic Appliance. With the advent of different applications that are free to be downloaded, everything can be made possible. Actually, I am not familiar with what this application is all about. But I am pretty sure that it can give a lot of benefits, especially to those who are working under IT industry. If I belong with this industry, I am sure that I will be familiar with this one!

Reply
Prabha
10/15/2018 08:58:03 pm

Hi Marco,
Which version of TWS supports this integration? and how this new feature is different from using a REST API job type to trigger an XS classic job on HANA.

Reply
Marco
10/26/2018 10:42:18 am

Hello Prabha.
This kind of integration is available starting from Workload Automation 9.3.
In this way you will connect directly with the HANA database and you will able to run SQL or stored procedure. Instead with HANA restful API for HANA XSEngine you could run xsjob directly. In most of the case xsjob trigger itself a stored procedure, so the result is the same that with Workload Automation.
Comparing with with Workload Automation objects, xsjob is the JobStream that contains the xsjs job.

I hope this clarify
Regards
Marco

Reply
Monique
8/28/2019 03:51:33 pm

I would like to know how HCL would work in comparison to Redwood.

Reply
marco link
8/29/2019 03:17:56 am

Hello Monique,

Thanks to reach me.

For comparison aspect of the HWA please write an email to cristiano.plini@hcl.com. He is willing to provide to you all needed information.

regards
Marco

Reply

Your comment will be posted after it is approved.


Leave a Reply.

    Archives

    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
    Business Applications
    Cloud
    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