1.5

Table Of Contents
Default Data Format
Default Format Settings can also be defined at the DataMapper configuration level (see
DataMapper Default Data Format for more information).
SQL Query Designer
The SQL Query Designer is used to design a custom SQL query to pull information from a
database.
l
Tables: Lists all tables and stored queries in the database.
l
Custom Query: Displays the query that retries information from a database. Each
database type has their own version of the SQL query language. To learn how to build
your own query, please refer to your database's user manual.
l
Test Query button : Click to test the custom query to ensure it will retrieve the
appropriate information.
l
Results: Displays the result of the SQL query when clicking on Test Query.
The Steps Pane Interface
The Steps tab displays the process that prepares and extracts data. The process contains
multiple distinct steps and is run for each of the Source Records in our Data Sample.
Window Controls
The following controls appear at the top of the Steps pane:
l
Zoom In (CTRL +) : Click to zoom in by increments of 10%
l
Zoom Out (CTRL -) : Click to zoom out by increments of 10%
Contextual Menu
You can access thecontextual menu using a right-click anywhere inside the Steps pane:
Page 149