Configuring the Data Pump

These steps configure the data pump that reads the local trail and sends the data across the network to a remote trail.

In GGSCI on the source system, create the data-pump parameter file.
```
EDIT PARAMS name
```
Where: name is the name of the data pump Extract group.

Enter the data-pump parameters in the order shown, starting a new line for each parameter statement. Your input variables will be different. See the following table for description.

Basic parameters for the data-pump Extract group:

EXTRACT extpump
SOURCEDB FINANCE USERID ogg, PASSWORD AACAAAAAAAAAAA, BLOWFISH ENCRYPTKEY mykey
RMTHOST fin1, MGRPORT 7809
RMTTRAIL /ggs/dirdat/rt
TABLE hr.*;

Parameter	Description
`EXTRACT group`	`group name` is the name of the data pump.
`SOURCEDB database USERID user, PASSWORD password, BLOWFISH ENCRYPTKEY keyname`	Specifies database connection information. `SOURCEDB` specifies the default DB 2 for i database. `USERID` specifies the Extract database user profile. `PASSWORD` specifies the user's password that was encrypted with the `ENCRYPT PASSWORD` command. Enter or paste the encrypted password after the `PASSWORD` keyword. `BLOWFISH ENCRYPTKEY` `keyname` specifies the name of the lookup key in the local `ENCKEYS` file.
`DECRYPTTRAIL BLOWFISH`	Decrypts the input trail.
`RMTHOST hostname, MGRPORT portnumber`	`RMTHOST` specifies the name or IP address of the target system. `MGRPORT` specifies the port number where Manager is running on the target.
`ENCRYPTTRAIL BLOWFISH`	Encrypts the remote trail with Blowfish encryption.
`RMTTRAIL pathname`	Specifies the path name of the remote trail.
`TABLE schema.object; TABLE library/file; TABLE library/file(member);`	Specifies a table or tables to process. Terminate the `TABLE` statement with a semi-colon. To exclude tables from a wildcard specification, use the `TABLEEXCLUDE` parameter after the `TABLE` statement.

Enter any optional Extract parameters that are recommended elsewhere in this manual and any others shown in Summary of Extract Parameters in Reference for Oracle GoldenGate.
Save and close the file.