The Candidate Finder dialog enables you to define SQL statements that retrieve potential match candidates from a database, as well as map the columns that you select from the database to the field names that are defined in your dataflow.
Option Name |
Description / Valid Values |
---|---|
Finder type |
Select Database. |
Connection |
Select the database that contains the candidate records. You can select any connection
configured in Management Console. To connect to a database not
listed, configure a connection to that database in Management
Console, then close and reopen Candidate Finder to refresh the
connection list.
Note: The Dataflow Options feature in Enterprise
Designer enables the connection name to be exposed for
configuration at runtime.
|
SQL statement |
Type a SQL statement in the text box as described in Defining the SQL Query |
Field Map tab |
Choose field mapping settings as described in Mapping Database Columns to Stage Fields. |
Preview tab |
Click this tab to enter a sample match key to test your SQL SELECT statement or your index query. |