Loading Extracted Data into the Relational Database

When you have extracted data to the data store, the RPS node secondary enables you to load this data into the target RDBMS database.

To load data from the data store into the target relational database

1. Select the Load command from the Extracts menu. The common File dialog is then displayed, with the directory defaulting to the script directory.

2. Select the SQL script that you want to run to load data into the target RDBMS database and then click the Open button. Alternatively, click the Cancel button to abandon your selections.

The load process then runs the script on the target RDBMS database. The Jade RPS Manager window displays the progress of the extract process and its completion.