Reviewing Data from the Source

Once the data source connection has been configured, the next step is to preview the data returned from the query. This confirms that you have configured the connection properly and are retrieving the expected data. You can validate the returned data, with no effect on the source data or future imports.

To review the returned data:

1. Click on the Data node in the structure tree on the left.
   The main panel displays the data returned from the data source.

   Figure: The data grid offers many options for organizing the list

   

2. Right-click on the column header to organize the data as you require.
   Note: Operations on this list have no impact on the data source or data import. This list simply helps you confirm that you are gathering the correct data from the source.