The collection of information about a schema and its extraction rules is called an Extraction Set and is stored on disk as a series standard text files. The layout and storage mechanism of the Extraction Set files offers a considerable amount of flexibility and versatility to help cope with changes and variations in the source database configuration. Please see the Extraction Set Reference for more information on the function of each file in an Extraction Set and how it is used.

The DataBee Set Designer application exists to provide a simple and easy way to build and maintain Extraction Sets. The Set Extractor application reads the Extraction Set and uses the rules and other it contains to extract data from the source Oracle database. The extracted row information is stored on disk in a binary file. The Set Loader application reads the extracted row information and uses it to load the target Oracle Database.

The DataBee Set Planner and Set Designer applications contain a number of tools to assist with the task of building an Extraction Set for a database. However, you will almost certainly need business knowledge about how the tables are related to one another in order to build a complete Extraction Set. At the very least, the WHERE Clause rules that provide the starting data for the set extraction will need to be specified. In all probability, rules that express table-to-table relationships will also need to be manually added. More information on Extraction Set rules can be found on the About DataBee Extraction Set Rules page.

Yes, the Extraction Set files are user editable. Manually changing an Extraction Set is inadvisable because of its complexity - the Set Designer application is the recommended solution. We recognize however, that situations may arise where a quick search and replace on the set file may save hours of work. So, if it really is necessary to manually edit the set file then please do have a look at the Extraction Set Reference to find out what all of the fields mean before starting.

Note: Download the DataBee Quick Start Guide for a complete discussion DataBee Extraction Sets and their usage.