1.2.1 Create Extract
This topic describes the systematic instructions to create an extract.
The user can create a new extract by selecting the preferred start time and encryption profile, then clicking Create.
Once initiated, the system sets up the GoldenGate extract in the backend. This process may take a short time.
If the extract is created successfully, it will appear in the UI with its details and status. Initially, the extract will typically be in a Stopped state (not yet running).
Note:
A user can have only one active extract at a time for a given source. The UI will prevent creating a second extract if one already exists. To recreate an extract, the existing one must be deleted first. If no extract exists, the UI will indicate this, and the Create Extract form will be available.
The above page is displayed when the user has not created any extracts or Deletes an existing Extract.
The user can create a new Integrated Extract through the self-service UI by either selecting Begin
Now to start immediately or specifying a CSN (Commit Sequence Number) to begin capturing
changes from a particular point in the source database.
- Begin Now: The extract starts immediately from the current point in the source database.
- CSN: The extract begins capturing changes from a specific System Change Number.
For CSN option the user can select an CSN from the available values by clicking the CSN list option located below the CSN registration Option field. The same is explained in detail in section2.2.3
For Begin Now, the CSN field under the CSN registration Option can be left empty, as the extract will start immediately from the current point in the source database.
Parent topic: Integrated Extract