Step 1: When you create a new connection, for example as shown here Connect To hadoop , you will get to Preview Screen.

 

Step 2: On preview screen,on top right corner you will see a button of "export".

 


Step3: When you click on export a popup opens, which gives you different options of the systems in tabs where you can export your data such as Hadoop, JDBC, Amazon S3.

 

 


 

Step 4: Fill out the below details : 

 

JDBC  - 

  • Database Type - Select the database type from the dropdown : MYSQL,ORACLE etc.
  • Write Mode - Options like : Overwrite, append etc.
  • Hostname or IP - ip address of name node
  • Port - port to connect to name node
  • Username - Username required to access the database.
  • Password - Password required to access the database.
  • Database Name - The name of the database to be exported.
  • Table Name - The name of the table to be exported.

 





Step 5: Once done, you can click on export. Data will be exported as the background process and you will get a notification once it is successfully done.