-
On the Define Data Reader Pattern page, click Add table from database
in the Tables pane.
All the tables in the database defined in the selected data connection are displayed
in the Select Tables dialog box.
-
Select one or more check boxes beside the names of tables in the Select Tables dialog box, and click OK to add them to the list in the Tables pane.
If a Microsoft Excel file is used as a database, the worksheets in the Microsoft
Excel file are considered to be data tables.
-
In the Tables pane, select a table. The column names of the selected table are displayed in the Table Properties pane.
-
In the Table Properties pane, select one or more check boxes beside the column names to include them in the query.
-
Click Map Selected Fields
to map the selected fields to the existing database properties. For more information
on mapping fields, see Map selected fields.
-
In the Table Properties pane, select a column name and click Apply Converter
to update the property value before importing to the database. For more information
on mapping fields, see Convert the property values.
-
Select a table from the Tables pane.
-
In the Create Query pane, click Add table to query
to add the table to the query.
In the Create Query pane, if you already have a table and you try to add another table, then the Join Tables dialog appears. For more information about creating joins, see Join tables.
-
Click Custom Properties to create a custom property. For more information, see Create custom properties.
-
Click Generate SQL
to view the query in the SQL Query pane.
-
Click Save to save the data reader pattern.
-
You can type a query in the SQL Query pane and click Save to add a data reader pattern.
-
In the Tables pane, select a table and click Join Tables
to join one table with another table. The new table name created with the join is
added in the Tables pane. For more information, see Join tables.
-
You can add the same table multiple times with a different display name or alias name each time.
-
In the Tables pane, select the table and click Refresh
to update the new columns which were added in the database and to remove any columns
that no longer exist in the database. You can view the updated or deleted columns
in the Table Properties pane.
-
In the Table Properties pane, you can do the following:
-
You can type the look up file path in the Look up path column. This is required when a value is given instead of a field name and you want to transfer the value from the database into a name when it is retrieved into Data Capture. The lookup file must be an xml file, and the format needs to be similar to the example mentioned below:
<Values Name="Yes/No">
<Value ID="1" Value="Yes" />
<Value ID="2" Value="No" />
</Values>
-
You can type the units of measurement in the UOM column. The unit of measurement is appended to the value imported from the existing database.
-
You can click Click to add condition
in the Where column against one of the table properties to define a WHERE clause for it. For more
information, see Create a WHERE clause.
-
-
In the Create Query pane, you can do the following:
-
Select the table on the right side of the join and click Delete
to delete the table from the query. If you have more than one join in the Create Query pane, then you can delete the table on the right of the rightmost join.
-
You can select a join between two tables and click Edit
to modify the join type or condition of the join.
-
Click Preview
to view the first 100 records that will be extracted by the query as it is defined.
-
-
Click Transpose Selected Fields
to restructure the data. For example, data represented in a single row can be represented
as columns. You can preview the data after creating the mappings.
You can append the unit of measurement (UOM) of the property in the Transpose Fields dialog box.