In order for the Set Designer to function, it needs to be aware of the tables in the source schema and their structure (columns, column sizes etc). This information is acquired in two ways. When the Set Designer loads an existing Extraction Set file it reads the .schema file and .rule file (if present) and becomes aware of the tables. If a new Extraction Set is being created, the schema structure is downloaded using the "Get Schema Information from DB" button on the Rule Tools Tab.

If a table is involved in one or more extraction rules, it is said to be "In a Set". If no rules reference it, the table is said to be "Out of Set".

Note: It is possible for tables to be present in the table list that do not contain any known column information. If tables are used in rules - but have no corresponding entries in the .schema file for the user, then the Set Designer application will know about the table - but not about the columns. More information on Extraction Set files and their uses can be found on the Extraction Set Reference pages.

The DataBee Set Designer Set Tables Tab

The panel on the top of the Set Tables Tab shows the tables in the Extraction Set. Beside each table is a column indicating whether the table is in or out of the set (used in a rule or not) and the source and extracted row counts. The source row counts are obtained via the Extraction Set .rowcount file. The extracted row count column contains the number of rows last extracted by the Set Extractor application when it last processed this Extraction Set. This column is automatically updated as the new information becomes available. An FP in this column indicates that the table is to be loaded by a Full-Pull and the Skip Extract Full-Pull Tables option has been set.

The "Plan Match" column states how well the current extracted row count matches the goal specified in the Extraction Set Plan. The first column indicates that the current extracted row count either matches (y), does not match (n) or is not specified (?) in the Extraction Set Plan. The second column lists the Extraction Set Plan goal for that table. Planned goals can be either Partial ([partial]), All Rows ([all]) or No Rows ([no rows]).

What the Buttons do

Discard Table

The Discard Table button removes the table name from the Set Designers knowledge. If the table has rules these rules will also be dropped. Note that discarding a table has no affect on the table in the source schema - it just means that the Set Designer application no longer knows about it.

Hide rows marked "No Rows"

If you have made a plan then it is probable that some of the tables will be marked as needing "No Rows" to be extracted. Clicking this option will remove such tables from the display.