 |
Exporting Data to Delimited Files
|
 |
The Export to Delimited File feature allows for the creation of one or
multiple delimited text files generated from existing data within selected
database schemas and tables.
|
 |
- Select the menu item Tools > Export Data > Export to
Delimited File or the Export to Delimited File button from the
main tool bar
- Select the open connection to use for this data export
- Select whether to export a single table or multiple tables
- Select the Next button to proceed to the next step
- Select the database catalog or schema containing the table(s) to
be exported
- For a single table export:
- Select the table to be exported from the drop-down list
- Select the desired columns (or all) to be exported from the
selected table
- Reorder the columns as desired using the Move up/down
buttons
- For a multiple table export:
- Select the tables to be exported from the 'Available Tables'
list using the arrow selection buttons
- Alter the order in which each table will be extracted using
the Move up/down buttons
- Select the Next button to proceed to the next step
- Select a valid file path or paths for each individual table to be
exported
- Select the Next button to proceed to the next step
- Select the delimiter type to use for the data from available
options
- Select the action on error for the extraction process
- Select whether to trim leading and trailing whitespace from each
individual extracted table column value
- Select whether to include the column names as the first row within
the generated extract.
- Select the Next button to begin the data extract process
- Monitor the output pane for any errors - use the Stop button to
halt the process at any stage during the run
- Select Finish (or Back to correct errors etc) when the process
has completed
|