-


         
Rapid Miner and SAP HANA DB integration:

Objective: 

If you have SAP HANA data base which stores all the enterprise transactional data and want to apply predictive/machine learning algorithms on the HANA data base tables or views. This blog gives you the steps to connect SAP HANA data base from Rapid Miner and retrieve tables/views/procedures data and apply Rapid Miner statistical algorithms or machine learning techniques to get the insights of data.

Back Ground and use case:

Rapid Miner is a data science platform for teams that unites data prep, machine learning, text mining and predictive model deployment. It is used for business and commercial applications as well as for research, education, training, rapid prototyping, and application development and supports all steps of the machine learning process including data preparation, results visualization, model validation and optimization.

SAP HANA is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE. Its primary function as a database server is to store and retrieve data as requested by the applications.

With the SAP HANA Data Platform of structured and unstructured data we wanted to do the proof of concept on Text analytics, Market basket analysis, Customer churn, Customer segmentation data science use cases using Rapid Miner Studio.

The below step by step procedure helps to  connect HANA DB tables/views/procedures from Rapid miner studio.

Rapid Miner & HANA Integration steps:

1.     Prerequisites : You must have below before trying your hands on Rapid miner models on HANA data.

     HANA CLIENT Tools (Which installs required drivers in the client machine)

     Rapid Miner Studio Client (Interface to develop Rapid miner models)

     User Account in HANA DB with read access on DB Objects.

     Optional: Install HANASTUDIO/WEB IDE to analyze or preview SAP HANA data.

2.     Once you Install HANA Client tools, you will see ngdbc.jar file in the below path
             C:\Program Files\SAP\hdbclient

Place this ngdbc.jar file below Rapid miner installation folder path

             C:\Program Files\RapidMiner\RapidMiner Studio\lib\jdbc

3.     Open the Rapid Miner studio and create data base driver .
Go to manage data base drivers and enter the following parameters as shown in picture

Name of driver: HANA_JDBC
            Jar file: C:\Program Files\RapidMiner\RapidMiner Studio\lib\jdbc\ngdbc.jar
             Port : 30115
             Driver class: com.sap.db.jdbc.Driver


4.     Now go to manage data base connections , create data base connection with below parameters. Select previously created driver in the data base system Give the HANA system host, port ,user id, password


 Do the test connection- you should see success message.


5.     Now use db connect process to import the data and process the data using rapid miner models.
From read data base parameters, you can connect tables or views or you can write custom HANA SQL Query.




Writing custom SQL query :





Date: 09/17/2018
Prepared  By : Joseph Yeruva 
https://twitter.com/josredy










Comments

Post a Comment

Popular posts from this blog

-
Image
End to end model of Data Analysis & Prediction using Python on SAP HANA Table data: This blog helps to connect with SAP HANA DB (Version 1.0 SPS12) then extract the data from HANA table/View and analyze the data using Python Pandas library. Then you can clean and select independent variables/features data to feed the Machine learning algorithms to predict dependent variables or find insights. In today’s digital economy, businesses cannot take action on stale insights, thus a true in-memory data platform should support real-time processing for transactions and analytics for all of a company’s data. SAP HANA helps to manage data in a single in-memory platform, so you can take action in the moment. Accelerate the pace of innovation and run live in this new digital economy. SAP HANA Capabilities include database services, advanced analytics processing, app development, data access, administration, and openness. Python is becoming popular in analytics and data science. It...
Read more
-
Image
Sentiment analysis of Product reviews/survey data: Customer centric company tries to understand what customer need and deliver that. Customer experience is the key to business success. Customer centricity is a new way of doing business that give positive customer experience. But what customers saying about your brand? Businesses are using tools or web scraping techniques to collect the product reviews, customer feedback data or social media data. Web scarping is a method of gathering data available on websites. Once you have the product reviews, customer feedback data or survey results data, sentiment analysis helps to find the insights on the data. The text analytics tools (Natural language processing ) can provide insights analyzing the text data and separates the text data into tags like positive, negative, and strong positive. You can Understand what your customers like and dislike about your product. Compare your product reviews with those of your competitors. Get t...
Read more

SAP BW DeltaQueue (RSA7)

-
Frequently Asked Questions around SAP BW DeltaQueue (RSA7) What does the number in the 'Total' column in Transaction RSA7 mean? The 'Total' column displays the number of LUWs that were written in the delta queue and that have not yet been confirmed. The number includes the LUWs of the last delta request (for repetition of a delta request) and the LUWs for the next delta request. A LUW only disappears from the RSA7 display when it has been transferred to the BW System and a new delta request has been received from the BW System. What is a LUW in the delta queue? A LUW from the point of view of the delta queue can be an individual document, a group of documents from a collective run or a whole data packet of an application extractor. Why does the number in the 'Total' column in the overview screen of Transaction RSA7 differ from the number of data records that is displayed when you call the detail view? The number on the overview screen corresponds to the total of...
Read more