The Tables In Set tab provides a ready reference to the schema tables known to the the extraction and loader set. Note: the Set Designer software is modal - it operates on both Extraction and Loader sets and the options on the screen display will change as is appropriate to the type of set being configured.

In order for the DataBee software to function, it needs to be aware of the tables in the source and target schemas and their structure (column names, column types, column sizes etc). This information is usually automatically acquired when the extraction or loader sets are created. The schema structure can be refreshed using the Refresh Schema and Indexes button on Options tab of the edit Rule Controller form.

The DataBee Tables In Set Tab

The panel on the top of the Tables In Set tab shows the tables in the extraction or loader set. Beside each table is a column indicating the number of rows in the table. Each table can expand to show the column structure of the table. Additional information is displayed beside each table name. The type of information is dependent on whether an extraction or loader set is currently open. - in the above example an extraction set is open.

The very first line of the table collection lists the schema connection information from the Rule Controller which owns the tables. If multiple Rule Controllers are present then multiple schema entries each containing the schema tables will also be present on the Tables in Set tab.

If the required table is not present in the list, then the schema information will probably need to be refreshed again. Use the Refresh Schema and Indexes button on Options tab of the edit Rule Controller form to reload this information.

A right mouse button click on any table name will cause a small menu to appear offering the option to see the columns, foreign keys and indexes for a particular table.

What the Columns mean (Extraction Set Mode)

Src. Rows

This is an estimate of the number of rows in the table in the source database. This value is obtained from the statistics or via a count(*) operation when the extraction set is created. It can be refreshed using the tools on the Options tab of the edit Rule Controller form if required - however it should always be treated as an estimate. DataBee does not require this information to be accurate in order to successfully extract data.

Ext. Rows

This is the number of rows extracted for this table during the last extraction run of this extraction set. The Set Extractor will transmit this information to the Set Designer when the extract completes.

Ext. Rows

This is the value of (Ext. Rows)/(Src. Rows)) expressed as a percentage. Since the Src. Row value is an estimate, this value should also be treated as an estimate.

Matches Plan

The Matches Plan column states how well the current extracted row count matches the goal specified in the Plan Type column. A value of Yes indicates that the current extraction state matches the plan and a value of No means the the current extracted row count does not match the desired plan goal.

Plan Type

The Plan Type column lists the Extraction Set Plan for that table. Planned extraction goals can be either Subset ([Subset]), All Rows ([all]), No Rows ([no rows]) or Unknown ([Unknown]).

What the Buttons do

Create Pseudo Table

Sometimes it is necessary to add table definitions manually (instead of refreshing from the schema) or to create a dummy table which actually represents a database link. The Create Pseudo Table button will launch a form which provides this functionality. See the help file for the Create Pseudo Table form for more information.

Choose and Remove Tables

The Choose and Remove Tables button launches a form which offers the option to select and remove tables. If the table has extraction rules applied to it these rules will also be dropped. Note that removing a table in the DataBee software has no affect on the table in the target schema - it just means that the DataBee application no longer knows about it. It is also possible to remove individual tables by right clicking on them with the mouse and choosing the Remove Table option.