Extracting Data and Loading it into the Relational Database
When the RPS node secondary data store is configured or created with the Full or Mapping Extent persistent database modes, you can extract the data on the RPS node and then load it into the target RDBMS database. For details and benefits about database modes, see "Configuring your RPS Node", earlier in this chapter.
The extract process creates the data and format script files, which the load process then loads into the target RDBMS database.
When extracting data, you can override the names of files created by the extract process, including the names of the script file itself, and you can split a data file into two or more partitions, to support the parallel loading of large tables.
To extract data from your persistent data store and load it into the target relational database
-
Select the Extract & Load command from the Extracts menu. (The Extract & Load command is disabled on an RPS node when the RPS Datapump application is running.)
The Data Extract and Load dialog is then displayed. The controls on this dialog are the same as those on the Data Extract dialog. The Extract & Load command automatically runs the script to load the data extracted from your persistent data store into the target relational database.
For details about using the Data Extract and Load dialog, see "Extracting Data from the Jade Database", earlier in this chapter.
When you click the OK button on the Data Extract and Load dialog, the Datapump application is started and the data is extracted to the specified files.
After the extract completes, the script is run to load the data.
The Jade RPS Manager window displays the progress of the extract and load process and its completion.
