You are here:

Selecting A Single Data Object As The Source

The Configure Source dialog box displays a list of available data objects in the database. Use the Data Objects Explorer to expand each level.

To Select A Source Data Object

Expand the Data Objects Explorer as necessary to highlight a single data object:

Icon	Object	Definition
	Table	Name that displays in the Data Objects Explorer in the Configure Source/Target dialog boxes, after the Data Source created in Step 1 has been selected from the Connect to Source/Target dialog box.
	View	Views show tables grouped according to specific database configurations in your system. When you select a view as the source, the required tables are automatically joined.
	Stored Procedure	A stored procedure is a collection of SQL statements and optional control-of-flow logic (for example, if A then do this, if B, then do something else) that are compiled and stored in the database. Stored procedures can be used for a variety of purposes: fetching sets of data, reading single values, and inserting/updating/deleting data in many tables. They are re-usable, can take and return parameters, and can return information relative to their successful or failed execution. Software applications that run on top of relational databases often make use of stored procedures to handle certain complex database operations. Note: Stored procedures can be used only as targets or in source queries. Stored procedures are also used to customize the way an application interacts with a database to affect business rules or business process logic. These customizations are done by creating new stored procedures or modifying existing stored procedures that ship with an application. Insight allows you to use the business process logic already present in these stored procedures. Execute is the only operation that can be performed on a stored procedure step. When a stored procedure is selected for a target step, the parameters of the procedure are displayed in the Target pane. Data can be mapped to these parameters in the same way that data is mapped to target fields.
	Adapter	Adapters provide a means for the Workbench to interface with other applications. Depending on your configuration, adapters may or may not display in your Data Objects Explorer.
	XML	Either an XML document or schema. For more information about using XML objects as a data source, see Using XML as a Source.

Click OK. The list of fields in the selected object appears in the Source pane of the main window.
Note: Some adapters support the Filter option to allow you to restrict the fields and/or rows returned in the results set. If the selected adapter supports filtering, the Filter button is enabled. Filtering options depend on the adapter — refer to the adapter documentation for more details.

You can show or hide hidden data objects by selecting Hidden Data Objects and Fields from the View menu. However, the setting does not change until you close (and reopen) the Configure Source dialog box.