Note: Hyperstage only supports DataMigrator and Quick ETL Copy as ETL tools.
The Hyperstage adapter offers several unique options for the Quick ETL Copy tool. These options take advantage of bulk loading methods specific to the Hyperstage DB, to allow for faster and easier copying of large volumes of data into Hyperstage tables. In order to use these options, select Extended Bulk Load Utility as the Load Type during Quick ETL Copy configuration.
To access this tool, right-click the name of the synonym corresponding to the table or data you wish to move into Hyperstage, and select Quick ETL Copy.
The following configuration setting options are available:
The name of the target synonym into which the data will be loaded.
The name of the Hyperstage table that will be the base for the target synonym.
The list of adapters currently configured on the WebFOCUS server. Your Hyperstage adapter must be configured with at least one connection to appear in this drop-down menu.
The Hyperstage connection to be used for the load operation.
Select Extended Bulk Load Utility to take advantage of the bulk load options specific to the Hyperstage adapter.
A commit command will be issued every time the specified number of rows is loaded successfully.
Selecting this option will allow you to use the Distributed Load Processor (DLP), a parallel loading tool built into Hyperstage DB.
The maximum amount of simultaneous parallel threads which the DLP can use to load data.
The target application on the WebFOCUS server, which will store the target synonym and fex involved in this load operation.
The Quick ETL Copy tool will divide the data within the source table into the specified number of equal-sized blocks. These blocks will be loaded simultaneously, in parallel to each other. To use this option, your source table and synonym must be defined with at least one index or primary key.
The specific key to be used for the partition of the data, if the source table or synonym is defined with more than one key or index.
Note: The selected key field must be of a numeric data type.
Selecting this option will allow you to specify individual columns from the source table to be loaded into the target. Leaving this option unchecked will automatically load all the available columns.
WebFOCUS |