You are here: Getting Started > Exporting data

Exporting Data (Prepared exports)

There are two sources of data for prepared exports: Data from Staged Data and data from Results Books.

Note, it is also possible to create an ad-hoc export to Excel directly from the Results Browser.

Staged Data Export

Once you have written a Staged Data table using a Writer processor, you can set up an export of the Staged Data table to a data store. The export may then be manually run, or executed when you run the process that generates the Staged Data table.

To set up a data export of a Staged Data table:

Right-click on Exports in the Project Browser, and select New Export...:

Select the Staged Data table that you wish to export
Select the Data Store that you want to export to

If you are not creating the table in the Data Store during export, select the table in the Data Store that you want to export to

Note: The contents of this table will be overwritten by default, though you may choose to append to the table, or replace records with the records in the staged data table using the primary key, when running the export as part of a configured Job.

If required, map the columns in the Staged Data table to columns in the target table:

Note:Click on the Auto button to automatically map the columns in the order they are presented.

When you have completed your mapping, click Next, and optionally change the default Name of the export (the default name shows the name of the staged data table and the name of the data store)
Either run the export straight away, or save the configuration for running later (for example, as part of the scheduled execution of a job or process)

Results Book Export

Once you have written a Results Book you can set up an export of the Results Book to a data store. The export may then be manually run, or executed automatically as part of a scheduled job.

To set up an export of a Results Book:

Right-click on Exports in the Project Browser, and select New Results Book Export...:
Select the Results Book you wish to Export from
Select the Result Pages (within the selected Result Book) you wish to export and the number of rows to export (for example, you may want to restrict the export to only a few sample rows). No value here indicates that all records will be exported.
Select the Data Store to export to. Note that if writing to a database, a Results Book Export always creates tables (corresponding to the names of the results pages) if they do not exist, and always overwrites tables of the same name if they do exist.