Browse Data
Execute > Browse
Last updated
Execute > Browse
Last updated
Use the Browse Data screen to query data from source or target connections, from here you can download data or convert your SQL into new mappings.
Use the pull-down to select from a list of existing connections defined in the Manage Connections screen.
This section allows you to browse the data objects available in the defined connection as displayed in a folder tree, which shows the schema, table, and column. This should be used to to navigate the data and even to help you write the query with the drag-and-drop interface.
Script as Select generates a SQL SELECT statement that queries this entire table just by clicking the button.
The SQL query appears in the SQL editor shown in the screen below under the heading Enter SQL Statement.
You can run the query as is, or modify it before running it.
When editing a query, you can manually type any SQL necessary or you can also drag-and-drop any column directly into the SQL editor.
Use the SQL editor window to type in a custom SQL statement to be executed against the selected source system. Or, you can use the tools noted above to automatically build a query of an entire table using the Script as Select button or to drag-and-drop columns into your query.
Shortcut to execute query
Mac: ⌘ + return
Windows: ctrl + enter
After you've typed a SQL Statement, you can Run, Download the results or Generate a Mapping per the drop down menu.
This area shows a data table of output from the SQL statement executed when you hit the Execute SQL button shown below under activities. Use the Show N Entries option to change the number of rows shown per page, the Search option to search for a value in the resulting rows, or the Previous, Next and numbered screen options at the bottom of your Results to navigate your data.
Available activities from this page
Run executes the SQL statement in the Enter SQL Statement area against the selected source system.
Execute as CSV runs the SQL statement in the Enter SQL Statement area against the selected source system with the output to a Comma Delimited text file downloaded via the browser.
Convert to Map sends the SQL statement to the Generate Mapping screen for further processing as a Custom Map.
Click on the icon to see additional objects in the hierarchy and drill down from the schema to table to columns.
At the table level, you can click on the table to open it and see all the columns, or right click on the table icon to pop up a button.
Clicking the Format button will attempt to format your sql statement so that it is legible.
Click the refresh icon to re-read the source system and find any changes in data structures or objects, such as added files or tables, new or removed fields, renamed objects, etc.
