Click Create>Workflow.

Click the connector between the Start and End nodes, then click the + icon.

With the workflow graph displayed in the workspace, click the Name field and enter a descriptive name for the workflow.

For example, ETL workflow.

The name in this field is the name that displays for the workflow job in the WFM dashboard.

Click the Sqoop icon to add an action node to the workflow.

This Sqoop action will extract data from the MySQL database.

Click the Sqoop node in the workflow graph and rename it using a descriptive name.

For example, name the node sqoop-extract.

This is necessary because there will be two Sqoop actions in this workflow, and each node in a workflow must have a unique name. Having descriptive node names is also helpful when identifying what a node is intended to do, especially in more complicated workflows.

Click the Sqoop node again and then click the Action Settings gear icon.

In the Sqoop action dialog box, select Command.

In the Sqoop action settings, you can choose to use commands or arguments with a job-XML element to run the job. This example uses a command.

In the Command field, enter a command to extract data.

For example:

import --connect jdbc:mysql://wfmgr-5.openstacklocal/customer-data --username wfm --password-file /user/wfm/.password
--table marketing --split-by rowkey --hive-import -m 1 

This Sqoop command imports the MySQL data from the database customer-data into a Hive table called marketing. The password for user wfm is called from a password file.

Expand the Advanced Properties section and do the following:

Use the default settings for the remaining fields and options.

Click Save and close the dialog box.