Register an Extract from the Admin Client

Registering an Extract is required for change synchronization for Oracle and PostgreSQL databases.

This topic describes registering an Extract from the Admin Client. You can also register an Extract from the web interface while creating the Extract. See Add an Online Extract to see the steps to register an Extract from the web interface.

In case you need to upgrade Oracle GoldenGate and the installation directory for the Extract process is different, you need to use the MIGRATE option with the REGISTER EXTRACT command in Admin Client. See REGISTER EXTRACT in the Command Line Interface Reference for Oracle GoldenGate to know more.

Registering Extract for Oracle

Follow these instructions to register an Extract. Extract registration must be done prior to creating an Extract.

Ensure that you are connected with the database using the DBLOGIN command.

See REGISTER EXTRACT in the Command Line Interface Reference for Oracle GoldenGate for more information.

Using the Admin Client, connect to the deployment, then connect to the credential alias for the source database.
```
OGG> CONNECT https://remotehost:srvmgrport DEPLOYMENT deployment_name AS deployment_user PASSWORD deployment_password
```
When running the CONNECT command, the command prompt changes from "not connected" to "https://servername:port deployment_name", as shown in the following example:
```
OGG (https://pdbeast.vcn.oracle.com:16000depl_east)>
```

Connect to the database using the DBLOGIN command:

OGG (https://remotehost:portoracle_source)> DBLOGIN USERIDALIAS alias

Register the Extract. The Extract names cannot be more than 8 alpha-numeric characters.
```
OGG (https://remotehost:portoracle_source)> REGISTER EXTRACT extname DATABASE
```

You can also register an Extract in the background while creating an Extract from the Oracle GoldenGate MA web interface. See Add an Online Extract for details.

Registering Extract in Microservices Architecture for PostgreSQL

An Extract for PostgreSQL must be registered with the database and be granted a reserved replication slot. Replication slots are allocated through the database configuration setting max_replication_slots and can be configured as discussed in Database Configuration.

Follow these instructions to register an Extract. Extract registration must be done prior to creating an Extract. See REGISTER EXTRACT in the Command Line Interface Reference for Oracle GoldenGate for more information.

Using the Admin Client, connect to the deployment, then connect to the credential alias for the source database.

OGG> CONNECT https://remotehost:srvmgrport DEPLOYMENT
          deployment_name AS deployment_user PASSWORD deployment_password

OGG (https://remotehost:16000postgresql_source)> DBLOGIN USERIDALIAS alias

Register the Extract, which internally creates a replication slot for the Extract. Extract names cannot be more than 8 alpha-numeric characters.
```
OGG (https://remotehost:16000postgresql_source)> REGISTER EXTRACT extname
```

You can also register an Extract from the Oracle GoldenGate MA web interface. See Add an Online Extract.