When the Set Designer starts, the source and destination users are listed as <UNKNOWN>. Usually this user information is defined when the New Set Wizard is run and then saved and loaded with the Extraction Set. However the information can be added and updated manually via the Add a New User button.

The Source user is required - the Set Designer application expects to be able to connect to this user to retrieve schema information (table structures etc). The destination user is optional - although if it is known it should probably be entered here. If the destination schema information is not entered the Set Loader application will prompt for it when the extracted set data is loaded.

The source and destination schema information can be changed at a later date. Hence it is quite possible to develop the Extraction Set against a test database and then change the source user in the DataBee Set Extractor application so that the extract takes place against a production schema. Please note that the two schemas must be exactly identical or the rules built by the Set Designer application will not be right.

The DataBee Set Designer Set Schemas Tab

The panel on the top of the Set Schemas Tab lists the schemas in the Extraction Set. The current version of DataBee can configure an Extraction Set for up to 64 users. To see the details on a schema click on the schema name with the mouse and press the Update User button.

The User Information panel contains the buttons which can add, discard, modify or test the connection details for each schema in the Extraction Set. The button will operate on the schema currently selected in the top panel.

The Set Information panel contains the name of the currently loaded Extraction Set. This is the filename that is the container for the various component files and contains information on all users in the Extraction Set. These components are designed to be used in a modular fashion. Component files can be changed as required to configure different variants of an Extraction Set.

Connection Information File

This file contains the source and destination connection information that is displayed in the top panel. This information is created and updated via the use of the Update User button.

Schema Information File

All of the table information (table name, and column information) is contained in this file. If the source schema is upgraded this is the file that will need to be updated or changed. This information is created and updated via the Get Tables from Schema dialog box.

DB Constraint Rule File

Most Oracle databases enforce some sort of referential integrity using foreign key constraints. Rules based on these constraints are kept separate from manually entered Extraction Set rules. If the schema changes and new foreign key constraints are added or dropped this file will need to be updated or changed. This information is created and updated via the Generate Rules from DB Constraints dialog box.

Custom Rule File

An Extraction Set based entirely on foreign key constraint rules is unlikely to be satisfactory. Almost always custom rules will have to be manually added. This file contains those rules. It is quite possible to keep a number of variants of these files (each for a different purpose) and to substitute them as required. This information is created and updated via the many Set Designer Rule Tools.

Row Count File

The count of the rows in each table in the source schema is quite useful information to have when designing an Extraction Set. It would be very inefficient to retrieve these from the source schema each time they are required. The Row Count file contains stored row counts - it may need to be refreshed occasionally. This information is created and updated via the Get Table Row Counts dialog box.

Plan File

This file contains the information entered by the Set Planner application during the planning stage. This information is optional - but is useful during the design of the Extraction Set as it tells you how well the current rules match the desired outcome as dictated by the plan.

Changing and updating the Extraction Set Information Files

Change File

Pressing this button will start the process of loading a new component file in place of the selected file. The old information will be cleared and the new information will be inserted. Pressing the Save Set button on the main dialog box will save the new file as the new component file for that part of the Extraction Set.

Clear File Name

This button clears the file name for the selected component file - but does not clear the information it contains.

Save

This saves the information in the selected component file - but does not save any of the other component file data.

Save As

This saves the information in the selected component file and prompts for the new file name. Use this button if you wish to create alternate component files for an Extraction Set.

Discard Info.

Use this button if you wish to clear all information for the selected component.