03-18-2017 06:48 PM
I am having trouble connecting my database to RapidMiner. After pressing the 'Add Data' button in RapidMiner studio (upper left corner),
I choose the 'Database' option. After successfully choosing the data location (as well as testing the connection, which is ok),
I choose the table entitled 'events' (containing 5 attributes), and use the SQL Query:
pressing the 'Add Data' button in RapidMiner studio (upper left corner), I choose the 'Database' option again. Again testing the connection to the correct database ('Saninudge') checks out, but then after pressing the 'Next' button the window is empty and no tables are visible.
So at this point I am really stuck and could use some advice on how to successfully connect RapidMiner Studio to my database. Any ideas why the tables suddenly appears empty after installing the MySQL Driver? ANy help is much appreciated.
Solved! Go to Solution.
03-19-2017 12:59 PM
That sounds odd. Have you tried using the Read Database operator instead of "Add Data?" That's the more manual and fine tuning way.
Also, if your DB table is huge, RM will want to fetch the metadata for it and it could take a LONG time. If that's the case, just go to Preferences and toggle off Fetch SQL Metadata.