Caché Monitor provides the ability to export user data to a variety of formats

• Text files (CSV)
• XML
• HTML
• SQL (INSERT, UPDATE or DELETE, INSERT)

In order to export the data from a table you can either use the Query Analyzer and write a SQL query to retrieve the required data or you can use the Export tables function to export one or many tables with one command.

Export Table

To do this go into the Server Navigator choose your namespace and select the Tables node. On the right panel you have to select the tables you want to export. After doing that you can select Export Table in context menu.

Choose an appropriate directory and name for the file

On the next Dialog you have to choose the directory and make some settings to configure the output. The filenames are inherited from the tablenames.

Click Save / Speichern to start the export and create the file(s).

Export Data (one table)

By selecting Export Data from the context menu at an ResultTable you export only this table.

On the save dialog you can make the same settings like at the Choose directory dialog above and give the export file a name you wish.

Data Export feature is based upon SQL Workbench/J. Thanks to Thomas Kellerer!