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. 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. 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):
Step 2. Copy the JDBC driver in your Workload Automation preferred location Step 3. Create a Workload Automation database job type using the Dynamic Workload Console a. Access the Workload Designer: b. Select Database job type: Step 4. Create a Workload Automation database job type
Make a test connection to very that the configuration is correct: 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 Step 6. Write your Stored Procedure in the SQL tab If the required parameters can be retrieved using “Lookup Parameters”: This is an example of the job run result: 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.
5 Comments
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,
Reply
Marco
10/26/2018 10:42:18 am
Hello Prabha.
Reply
Monique
8/28/2019 03:51:33 pm
I would like to know how HCL would work in comparison to Redwood.
Reply
Your comment will be posted after it is approved.
Leave a Reply. |
Archives
August 2023
Categories
All
|