I am new to oozie, please suggest me process for connecting oozie with sap hana. in my ambari oozie and all relative services are up and running.

[#1 · Accepted solution]

There is an article Creating a HANA Workflow using HADOOP Oozie from the SAP blog

Perhaps easier is to connect to SAP Hana via NIFI. Preferred method is via REST API, not via JDBC (see previous question on this topic). However, you can connect over JDBC with Hana using NIFI as explained here: https://community.hortonworks.com/articles/81153/basic-cdc-using-apache-nifi-and-sap-hana.html

[#2]

It is very helpful.. Many Thanks....