You are here:

Configuring The Source

Click Configure Source in the main window. The Configure Source dialog box opens.
Select a connection in the Connections drop-down list. If the connection you want is not available in the Connections drop-down list, click New to create a new connection.
For some datastores, you can update the source by selecting the connection for both the source and a target connection. However, not all connections can be used as a source and a target.
Note: Only valid connections display in the Connections drop-down list.
Do one of the following:
- Select a single data object (the default)
  With a single object selected, you can:
  - Update or delete source rows during processing.
  - Specify a source key and name
    Note: Some sources cannot be updated. If you select Update Source for a source that cannot be updated, an error message appears. In this case, you may be able to achieve the same effect by using the source connection as both a source and a target connection, and adding an update step on this target connection.
- Create a custom query (if available). The Custom Query option only appears if custom queries are supported by the selected connection. The contents of the custom query pane depends on your connection.
  - For connections that support SQL, you can create a SQL query.
  - For many Adapter connections that do not support SQL, you can create a Scribe custom query.
When you are done, click OK. The Configure Source dialog box closes and the selected source fields display in the Source pane of Workbench.

Note: If connection information is required for the selected connection, the appropriate login dialog box appears. Enter the login information and click OK to close the login dialog box.