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.
  1. Select the menu item Tools > Export Data > Export to Delimited File or the Export to Delimited File button from the main tool bar
  2. Select the open connection to use for this data export
  3. Select whether to export a single table or multiple tables
  4. Select the Next button to proceed to the next step
  5. Select the database catalog or schema containing the table(s) to be exported
  6. For a single table export:
    1. Select the table to be exported from the drop-down list
    2. Select the desired columns (or all) to be exported from the selected table
    3. Reorder the columns as desired using the Move up/down buttons
  7. For a multiple table export:
    1. Select the tables to be exported from the 'Available Tables' list using the arrow selection buttons
    2. Alter the order in which each table will be extracted using the Move up/down buttons
  8. Select the Next button to proceed to the next step
  9. Select a valid file path or paths for each individual table to be exported
  10. Select the Next button to proceed to the next step
  11. Select the delimiter type to use for the data from available options
  12. Select the action on error for the extraction process
  13. Select whether to trim leading and trailing whitespace from each individual extracted table column value
  14. Select whether to include the column names as the first row within the generated extract.
  15. Select the Next button to begin the data extract process
  16. Monitor the output pane for any errors - use the Stop button to halt the process at any stage during the run
  17. Select Finish (or Back to correct errors etc) when the process has completed