As of today HdInsight Hadoop clusters didn’t have SQOOP MySQL connector. Manually setting it up is tedious. HdInsight recommended way of doing it is to use “script action”. To make it simpler I have authored a script action to install MySQL connector on windows clusters.
Script action is currently shared at https://kkhdiprodonly.blob.core.windows.net/scriptactions/MySqlSqoopConnector.ps1
CAUTION:
Above script action is only for testing purposes. Otherwise recommendation is to copy and re-host it.
Update the MySql version according to your needs. Currently Its authored to install mysql-connector-java-5.0.8 version.
How to use it:
Select “Custom Create” option
On last screen of the wizard Fill the script URI (NOTE: Make sure “All nodes” is selected for “NODE TYPE”
