The DataBee Set Loader application uses an loader set built by the Set Designer to load the rows extracted by the Set Extractor application into the target schema. During extraction the ROWIDs of the extracted rows are stored in a temporary table within the source schema (or proxy schema). The Set Loader application connects to the target schema and accesses these extracted ROWIDs and uses them to load the target schema in the destination Oracle database.
The Set Loader is one component in a suite of applications used to accomplish the task of building a smaller Oracle database from the contents of a larger one. For a step-by-step guide to the DataBee software and the tools and processes involved, please see the DataBee Quick Start Guide. If you are unsure about what an loader set is and why you might need one, please see the useful
loader set overview help page.
The Set Loader Application
As with all DataBee applications, the Set Loader presents its global functions (loading, saving, exiting etc.) as a
column of buttons in the right hand side of the application window. The tabs on the top left are used to provide areas of major functionality where the rules in the currently open loader set can be used to load rows from the source Oracle database into the target. Along the bottom of the window is a status line area where the Set Loader application provides information about its current state.
Command Line Options and Batch Mode
The Set Loader application can be used in a "batch" mode to automate the load of data from a source schema into a target. Please see the detailed discussion on the Set Loader Command Line Arguments help page.
The Global Functions
- The Bee Logo Button
- The Bee Logo button brings up an About DataBee form which provides information on the Set Loader version and support contact information. The About DataBee form also contains the license key details and provides information on new upgrades which have been issued subsequent to this version.
- Open Loader Set
- The Open Loader Set button reads in a loader set and configures the Set Loader to use it. Loader sets contain the rules that govern which extracted rows are copied from the source schema into the target schema. Loader sets are built by the Set Designer application.
- Clear Loader Set
- The Clear Loader Set button clears the existing loader set information from the Set Loader application.
- Run Loader Set
- This is the button that runs the rules! Once the loader set has been opened, press this button to load the previously extracted ROWIDs located in the source Oracle schema into the target schema specified in the loader sets Rule Controller rules. At the end of the load process, the rows associated with the extracted ROWIDs will have been inserted into the corresponding tables in the target schemas.
There are a number of distinct steps to the load process. Each step is implemented by a specific rule type and the execution order is enforced by rule blocks.
The usual process is as follows: the Set Loader connects to the target schemas specified in the Rule Controller then rules which disable the foreign keys and triggers are executed. The foreign keys must be disabled prior to the load because, although the Set Loader will copy over every row referentially required to be present in the target schema, it cannot ensure that while the load is actually in process that referentially integrity will always be maintained. Thus the foreign keys have to be disabled before the load takes place and re-enabled afterwards. Triggers may or may not need to be disabled depending on whether it is desirable to have them fire for every row inserted. After the foreign keys and possibly triggers have been disabled, the target tables are truncated and the tables are loaded with data. Once the load is complete, the foreign keys and triggers are re-enabled and the loader set run is finished.
- Stop Loader Set Run
- This button will stop any loader rules which are currently in progress. Loader runs are completely restartable so you can stop and restart them as required. The Stop Loader Set Run button can be pressed several times to request increasingly strict levels of halt signal.
- The Restart button re-activates the current loader set and restarts execution from the place it last stopped. Note that the restart process uses the information contained in the DataBee temporary tables located in the target schema and in order for the loader set to successfully restart this information must be present.
- Quick Start Guide
- The Quick Start Guide button launches a help page which will guide you through the process of creating extraction and loader sets for your own databases.
- A button which launches context sensitive help on the Set Loader Application (this file).
- Closes the Set Loader application.
- Rules in Set
- This tab displays the rules contained in the currently opened loader set. The rules cannot be edited here
(that is the function of the Set Designer application) but they can be disabled if required. Please see the specific Rules in Set tab help page for detailed information on this topic.
- Table Statistics
- The Set Loader application keeps an accurate count as the rows are copied from the source Oracle
database into the target. When a Load Manager rule is operational this tab will show a continuously updated display of the number of rows loaded into each table. Please see the specific Table Statistics tab help page for detailed information on this topic.
- Rule Statistics
- As the Set Loader processes the rules in the loader set, it will update the contents of this tab to
indicate which rules have been processed and which have not. The Rule Statistics tab also shows a continuously updated summary of the actions taken by the loader rule and the associated execution time. Please see the specific Rule Statistics tab help page for detailed information on this topic.
- Run Statistics
- The Set Loader is multi-threaded and can execute multiple load rules in parallel. The Run Statistics tab provides information on the rules which are currently running as well as summary statistics for the entire loader set run. Please see the specific Run Statistics tab help page for detailed information on this topic.
- Misc. Setup
- This tab provides a variety of configuration options for loader sets. Please see the specific
Misc. Setup tab help page for detailed information on this topic.