Creating a MySQL Source

Login to xenn.lake Portal

xenn.lake also supports Microsoft Azure Cloud Services. This tutorial show the integration of a MySQL database hosted on Azure Cloud.

To login use browser and insert the portal address. By default, portal works on the port 8080 of the installed server.

http://<hostname>:8080/xennlake_web

Go to Integration Module

Click on the <INTEGRATION> Link on top of the web page. This will lead you to the integration module. By there are two system generated sources which cannot be deleted.

generalFileInput: Is for the custom operating system files which can be uploaded manually and let xenn.lake to import them to the Hadoop File system.

downloads: Are the predefined source definition for the uploaded files via the INTEGRATION module. You can directly upload your files from the UPLOAD button which is in the left side of the INTEGRATION module. This uploaded files are going to be stored in the downloads source definition.

Select <New Source>

From the left menu, click on the <NEW SOURCE> button to open the pop-up window for the new connection.

Insert Necessary Information

Here, all the source connection parameters are from the Azure MySQL service.

From the pop-up window;

Source Name:Name of the defined source connection.

Source Type:select the source type as sqoopMySQL which represents the MySQL Database connection.

Address:IP address or resolvable hostname of the server.

Port:Port of the MySQL database Server.

Username:Database username

Password:Database password

Database Name:Name of the MySQL Database.

Click the <SAVE CONNECTION> button to save the connection.

Test Connection

After saving the connection, screen returns to the Integration Main Page. You can click on the <TEST> button to test the connectivity.

Now you are ready to define a table and transfer its data to Hadoop Filesystem which is explained in detail at the Creating and Transferring Files section.