> For the complete documentation index, see [llms.txt](https://docs.pentaho.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.pentaho.com/pdia-data-integration/10.2-data-integration/pdi-job-entries-reference-overview/sqoop-export-job/general-sqoop-export/quick-setup-mode.md). # Quick Setup mode ![PDI Sqoop export step Quick Setup mode](/files/87cjQDWIfAnsI0CnNhrN) ## Source The source refers to the Hadoop cluster where your Sqoop data that you want to import into a database is stored. | Option | Definition | | -------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Hadoop Cluster** |

The name of the Hadoop cluster that contains the data for export. Use the Use Advanced Options to specify configuration information for the host names and ports for HDFS, Job Tracker, and other big data cluster components (default).

Click Choose Available to select an existing cluster to use. If you do not have any existing cluster connections, click New.

Information on Hadoop can be found in Use Hadoop with Pentaho.

| | **Edit** | Click **Edit** to open the **Hadoop Cluster** dialog box where you can edit the configuration information. | | **New** | Click **New** to open the **Hadoop Cluster** dialog box where you can add a new Hadoop cluster configuration. | | **Export Directory** | Path of the HDFS directory containing the Sqoop data you want to export. | | **Browse** |

Click Browse to display the Open File dialog box, which displays the file system of the cluster. Click the directory to select the directory with your Sqoop data.

Note: Browse only works when you have a valid cluster connection configured and selected.

| \## Open File dialog box When you have a valid cluster connection, click **Browse** to display the **Open File** dialog box to view the cluster files. | Option | Definition | | ---------------------------------------- | ------------------------------------------------------------------------------------------------------------------ | | **Open from Folder** | Indicates the path and name of the HDFS directory you want to browse. This directory becomes the active directory. | | **Up One Level** | Displays the parent directory of the active directory shown in the **Open from Folder** field. | | **Delete** | Deletes a folder from the active directory. | | **Create Folder** | Creates a new folder in the active directory. | | **Active Directory Contents (no label)** | Displays the active directory, which is the one that is listed in the **Open from Folder** field. | | **Filter** | Applies a filter to the results displayed in the active directory contents. | ## Target The target refers to the database where you want to put your Sqoop data. | Option | Definition | | ----------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Database Connection** |

Click Choose Available to select the name of an existing database connection that contains the data for export.

If you do not have an existing connection, click New. If you need to modify an existing connection, click Edit.

| | **Edit** | Click **Edit** to open the **Database Connection** dialog box if you need to modify an existing connection database. | | **New** | Click **New** to open the **Database Connection** dialog box where you can add a new database connection. See [Define data connections](https://help.hitachivantara.com/Documentation/Pentaho/9.5/Setup/Define_data_connections) | | **Table** | The name of the target destination table. If the source database requires a schema, you must supply it in the format: `SCHEMA.TABLE_NAME`. This table must exist in the destination database and its structure must match the input data’s format. | | **Browse** | Click **Browse** to open the **Database Explorer** and explore configured database connections. | --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.pentaho.com/pdia-data-integration/10.2-data-integration/pdi-job-entries-reference-overview/sqoop-export-job/general-sqoop-export/quick-setup-mode.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.