In this example we will load an extraction to a MySQL database table.
We define an extraction based on the SAP table T001W which stores plants/branches.
Set destination We set the destination connection for the database.
Define settings We apply the default settings.
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.
In the new dialog select Drop & Create and click on Generate Statement. Columns will be created using the most appropriate data type.
Click the button Run. In the dialog Run Extraction click on either of the two Run buttons to run the extraction.
Click on Refresh in the Designer to check the execution status. In our example 238 rows have been loaded to the database.
Check the result in the database
Use the MySQL Workbench to see the table structure and content.