Unloading Data

You can use the Unload page to export the contents of a table to a text file or XML document.

Topics:

Unloading a Text File
Unloading to an XML Document

Unloading a Text File

Use the Unload to Text Wizard to export the contents of a table to a text file. For example, you could export an entire table to a comma-delimited file (.csv).

To unload a table to a text file:

On the Workspace home page, click the Utilities icon.
Click Data Load/Unload.
Click Unload.
Click Unload To Text.

The Unload to Text Wizard appears.
Follow the on-screen instructions.

You select the schema and choose the table and columns to be exported. Additionally, you can specify the type of separator to be used to separate column values and also whether column text strings are identified using single or double quotation marks.

Unloading to an XML Document

Use the Unload to XML Wizard to export the contents of a table to an XML document adhering to the Canonical XML specification.

To unload a table to an XML document:

On the Workspace home page, click the Utilities icon.
Click Data Load/Unload.
Click Unload.
Click Unload to XML.

The Unload to XML Wizard appears.
Follow the on-screen instructions.

You select the schema and choose the table and columns to be exported.