Highest Rated Posts

Marco_Boeck Team Lead Software Engineering

June 14

Re: Sankey plot

Hi, Nope, but I used this simple set to test it Regards, Marco

josephreddy07

June 13

RapidMiner & SAP HANA DB Integration using ODBC

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 using Rapid Miner. 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 2.0 Data Platform of structured and unstructured data,I wanted to do the proof of concept on Text analysis, Market basket analysis, Customer segmentation and other 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. SAP HANA DB & Rapid Miner 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.   You can use tables or views or write SQL script  to retrieve the data. 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 : Now use other operators in Rapid miner and feed this data based on your usecase.

varunm1

June 11

Re: Can I publish RapidMiner results with Educational Edition license?

Hello @Casper72 I work on rapidminer for most of my ML related works and published some papers as well. The only thing you need to do is to cite rapidminer in your references and where relevant. You can also go through our discussion about citing rapidminer below. https://community.rapidminer.com/discussion/54779/how-to-cite-rapidminer-studio-for-scholarly-publications Hope this helps Varun

mschmitz

May 22

[New Extension] Projects

Hello Everybody! I've just released a new extension called "Projects". This extension adds two new entries to your repository actions: This allows you to create a standard setup for a project. It automatically creates a folder structure, add standard processes with defined documentation and so on. The structure for the Project looks like this: Some of the processes already have a implementation. The 04-Learning one looks like this: I hope that these templates can make your life easier andmake yourself more efficient. I appriciate any feedback on the templates and of course on further enhancements! Best, Martin

rfuentealba

May 12

Re: Feature Selection

Hello, again! Stop! Stop! Stop! Don't make that answer the right one! (My pride says "delete your answer", but my OCD says "leave it there"). TIL that it is more common if we put feature selection inside the cross validation process because otherwise it would lead to biased results. Thanks to @varunm1 for the several links he has sent me. I actually got confused (too many hours programming stuff, you know) but this article got clarity for me: https://rapidminer.com/blog/learn-right-way-validate-models-part-4-accidental-contamination/. Despite my lapsus (and understanding the question), I can now focus on this: (Quote) Let's see: * On each cross validation fold, the selected features will differ. * In the RapidMiner documentation for the Cross Validation operator, it says: (Quote) So, the correct answer is: You get the model trained with all the data (not a specific fold), but only if you connect the mod port somewhere else. The model trained will use the best features found for all of these, though. All the best, Rodrigo.

varunm1

April 23

Re: Error when executing operator

Hello, The user need to check the python path in Settings --> Preferences --> Python Scripting window. Here they need to set the python path and test to see if everything is fine. Screenshot below.

Latest Posts

RapidMiner Community

Discussion List

• Filter/sort the premises and conclusions of association rules

  Responded But No Solution 31 views 1 comment 0 points Most recent by MarlaBot 2:42PMHelp
• How to map a value to missing

  Solution Accepted 9 views 1 comment 0 points Most recent by mschmitz 10:30AMHelp
• Not being able to view Turbo Prep and Automodel on update

  Responded But No Solution 8 views 1 comment 0 points Most recent by varunm1 10:27AMHelp
• Date Format

  Responded But No Solution 23 views 3 comments 0 points Most recent by sgenzer 10:02AMHelp
• Automodel learn/test

  Solution Accepted 20 views 1 comment 1 point Most recent by varunm1 9:41AMHelp
• Calculate Price Elasticity

  Responded But No Solution 36 views 5 comments 0 points Most recent by lionelderkrikor 8:52AMHelp
• Exporting Results of operator "create association rules"

  Responded But No Solution 14 views 1 comment 0 points Most recent by mschmitz 7:22AMHelp
• General Results

  New Question 29 views 0 comments 0 points Started by naxiota 7:16AM Help
• Reading Excel files directly from your companies OneDrive

  158 views 3 comments 6 points Most recent by Montse 4:28AMKnowledge Base
• Viewing results of run operators when an error occurred at the end

  Responded But No Solution 19 views 6 comments 1 point Most recent by Marco_Boeck 4:07AMHelp
• Model Simulator and Gradient Boosted Trees on v9.3

  Solution Accepted 31 views 4 comments 0 points Most recent by Marco_Boeck 4:06AMHelp
• Text mining - Results View - Wordlist (Process Documents from Data) not there anymore

  Solution Accepted 41 views 3 comments 0 points Most recent by MarlaBot June 18Help
• Text Mining - Unnammed error in Apply Model (Documents) Operator

  Responded But No Solution 35 views 2 comments 0 points Most recent by MarlaBot June 18Help
• Work on disease data

  Responded But No Solution 84 views 9 comments 0 points Most recent by varunm1 June 18Help
• Why is my fetch taking so long?

  Responded But No Solution 46 views 7 comments 0 points Most recent by sgenzer June 18Help
• Log data table error

  Responded But No Solution 13 views 6 comments 0 points Most recent by sgenzer June 18Help
• Classification - comparison of one attribute to others attributes

  Responded But No Solution 34 views 7 comments 0 points Most recent by Serek91 June 18Help
• Merge of multiple data tables with overlapping attributes

  Responded But No Solution 23 views 1 comment 0 points Most recent by varunm1 June 18Help
• Azure HD Insight 3.5 and Radoop: cannot get it to work

  Responded But No Solution 25 views 1 comment 0 points Most recent by sgenzer June 18Help
• Get back Cloud Repository contents after trial ending

  Responded But No Solution 54 views 4 comments 0 points Most recent by sgenzer June 18Help
• Thank you for the invitation

  Responded But No Solution 20 views 1 comment 1 point Most recent by sgenzer June 18Help
• A crazy idea in my mind,, Is it possible??

  Solution Accepted 47 views 2 comments 0 points Most recent by SGolbert June 18Help
• Jobagent not connecting properly to server

  Solution Accepted 28 views 3 comments 0 points Most recent by kayman June 17Help
• WordList (Process Documents from Data): word count

  Responded But No Solution 72 views 3 comments 0 points Most recent by Knut-RM June 17Help
• Giving parameters in RapidMiner Studio to RapidMiner Server

  Responded But No Solution 19 views 3 comments 0 points Most recent by Edin_Klapic June 17Help
• Renewing RapidMiner educational licence

  Solution Accepted 41 views 5 comments 0 points Most recent by sgenzer June 17Help
• File output for Execute Python

  Responded But No Solution 57 views 3 comments 0 points Most recent by btamas June 17Help
• Guardar valor

  Responded But No Solution 50 views 5 comments 0 points Most recent by NestorAndrade June 16Help
• How to split column and pivot values

  Solution Accepted 22 views 3 comments 0 points Most recent by User139033 June 16Help
• How to add value to an attribute with a logical condition up to a percentage of the ExampleSet

  Responded But No Solution 17 views 1 comment 0 points Most recent by Telcontar120 June 15Help