Creating a Postgresql Source

Login to xenn.lake Portal

To login use browser and insert the portal address. By default portal works on the port 8080 of the xennlake 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 xennlake 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 thedownloadssource 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

From the pop-up window;

Source Name:Name of the defined source connection.

Source Type: select the source type as sqoopPostgreSQL which represents the PostgreSQL connection.

Address:IP address or resolvable hostname of the server.

Port:Port of the postgresql database.

Username:Database username

Password:Database password

Database Name:name of the postgresql 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.