Importing Data from XML Files


The Import from XML File feature allows for the insertion of data from one or more XML files into selected database tables.
Note: XML file imports rely on the table name and column name tags being present within the import file. For example:
<?xml version="1.0" encoding="UTF-8"?>

  <table name="employees">

     <row rownum="1">
       <employee_id>1234</employee_id>
       <first_name>John</first_name>
       <second_name>Smith</second_name>
       <department>001</department>
       <start_date>20020506</start_date>
       <salary>55000</salary>
     </row>

     ...

  </table>
  1. Select the menu item Tools > Import Data > Import from XML File or the Import from XML File button from the main tool bar
  2. Select the open connection to use for this data export
  3. Select whether to import a single table or multiple tables
  4. For a multiple table import:
    1. Select whether to import from one file that includes ALL tables or multiple files where a single file is used for each individual table
  5. Select the Next button to proceed to the next step
  6. Select the database catalog or schema containing the table(s) to be imported to
  7. For a single table import:
    1. Select the table to be imported from the drop-down list
    2. Select the desired columns (or all) to be imported from the selected table
    3. Reorder the columns as desired using the Move up/down buttons to match the order the columns appear in the file
  8. For a multiple table import:
    1. Select the tables to be imported from the 'Available Tables' list using the arrow selection buttons
    2. Alter the order in which each table will be imported using the Move up/down buttons
  9. Select the Next button to proceed to the next step
  10. Select a valid file path or paths for each individual table to be imported
  11. Select the Next button to proceed to the next step
  12. Enter the XML element style as contained within the import file(s) (use the sample button on the form to view an example
  13. Select the action on error for the extraction process
  14. Select the rollback segment size (commit block) for the process
  15. Select whether to attempt to parse date values before inserting into respective tables
    Note: If date values exist and this option is not selected the system will insert each date values as the relevant CHAR format to be converted to date/time values by the database upon record insertion. Please review your specific database product documentation for the acceptable default date/time syntax.
    1. Select the date pattern to be applied to each date value (see date patterns)
  16. Select whether to run as a batch process (usually faster for very large record sets)
  17. Select the Next button to proceed to the next step
  18. Review and confirm the import process to be performed
  19. Select the Next button to begin the data import process
  20. Monitor the output pane for any errors - use the Stop button to halt the process at any stage during the run
    Note: Data may or may not have been committed to the database when the Stop button is selected
  21. Select Finish (or Back to correct errors etc) when the process has completed