Quick ETL Copy For Hyperstage Using Extended Bulk Load Utility

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:

Target Name

The name of the target synonym into which the data will be loaded.

Target Table Name

The name of the Hyperstage table that will be the base for the target synonym.

Adapter

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.

Connection

The Hyperstage connection to be used for the load operation.

Load Type

Select Extended Bulk Load Utility to take advantage of the bulk load options specific to the Hyperstage adapter.

Commit every row(s)

A commit command will be issued every time the specified number of rows is loaded successfully.

Use Distributed Load Processor for loading data in Hyperstage Database

Selecting this option will allow you to use the Distributed Load Processor (DLP), a parallel loading tool built into Hyperstage DB.

Maximum Number of Load Sessions

The maximum amount of simultaneous parallel threads which the DLP can use to load data.

Application

The target application on the WebFOCUS server, which will store the target synonym and fex involved in this load operation.

Number of Partitions

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.

Key for Partitions

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.

Select Columns

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