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

Define extraction

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

mysql_table_extraction_T001W

Set destination We set the destination connection for the database.

mysql_Destination_Details2

Define settings We apply the default settings.

mysql_extraction_specific_settings2

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.

mysql_extraction_specific_settings_custom_SQL

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

mysql_extraction_specific_settings_generate_statement

Run extraction

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

mysql_table_extraction_T001W_Run

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

mysql_table_extraction_T001W_Run_Result

Check the result in the database

Use the MySQL Workbench to see the table structure and content.

mysql_table_extraction_T001W_Editor_Result