In this example we will load an extraction to a Vertica database table.

Define extraction
We define an extraction based on the SAP table T001W which stores plants/branches.

XU_Vertica_Table_T001W

Set destination
We define the connection details for the database.

Vertica_destination_details

Define settings
We apply the default settings.

XU_Vertica_Destination

The Preparation option Drop & Create drops an existent table and creates a new one.

Optional: You can preview the SQL statement or use it as a template for your own SQL statements.
Select the list value Custom SQL for Preparation then click on the Edit SQL button.

XU_Vertica_CustomSQL

In the new dialog select Drop & Create and click on Generate Statement. Columns will be created using the most appropriate data type.

XU_Vertica_Custom_SQL_DropCreate

Run extraction
Click the button Run. In the dialog click on either of the two Run buttons to start the extraction.

XU_Vertica_Vertica_RunExtraction

Click on the Refresh button in the Designer to check the execution status. In our example 238 rows have been loaded to the database.

XU_Vertica_Vertica_Extraction_Result