(Glue-2411) ODP Replication

Owned by SNP
yesterday at 10:38 am
3 min read

On this page, you will find a step-by-step list of how to set up an ODP Extraction.

Create SNP Glue Table

  1. Go to transaction /DVD/GL80, right-click on the desired package, and press Create Glue Table.

  2. Fill in the Table name and confirm.

  3. In the attributes tab fill in Storage ID. You can use F4 help to get available storages.

  4. Click on the fields tab and click Import fields in the toolbar.

  5. Select From ODP from the options and fill in your source table. It is important to specify the ODP Context. In our case, we use DataSources/Extractors.

    image-20240815-104240.png

  6. Click Activate in the toolbar at the top of the screen.

  7. The table is now active and created on target storage.

Create ODP Fetcher

  1. Go to transaction /DVD/GL80, right-click on the desired package, and press Create Extractor 2.0 Object.

  2. Fill in the Object name. Select Fetcher in the Component type list box and ODP Fetcher in the Component Implementation list box.

  3. In the Fetcher screen fill in the ODP Queue (Name of ODP source) and select the appropriate context.

  4. If the ODP Queue is correct, the filter selection should be updated. In filter selection, you can check a selection checkbox that will allow you to perform filters on checked fields.

  5. Click Activate in the toolbar at the top of the screen.

Create Glue Table Consumer

  1. Go to transaction /DVD/GL80, right-click on the desired package, and press Create Extractor 2.0 Object.

  2. Fill in the Object name. Select Consumer in the Component type list box and GLUE Table Consumer in the Component implementation list box.

  3. In the consumer screen, fill in the Glue table with your Glue table name.

  4. Click Activate in the toolbar at the top of the screen.

Create Extraction Process

  1. Go to transaction /DVD/GL80, right-click on the desired package, and press Create Extractor 2.0 Object.

  2. Fill in the Object name. Select Extraction Process in the Component type list box and Extraction Process in the Component implementation list box.

     

  3. In Parameters fill in Fetcher and Consumer names and press Enter.

  4. Click Suggest transformation mapping in the Transformation section.

     

  5. Click Activate in the toolbar at the top of the screen.

Execution of Extraction

  1. Open Extraction Process in transaction /DVD/GL80.

  2. Click Execute in the toolbar at the top of the screen.

  3. Click Execute again in the toolbar at the top of the screen.

  4. Choose either Dialog execution or Background execution.

Execution of delta

  1. Open Extraction Process in transaction /DVD/GL80.

  2. Click Execute in the toolbar at the top of the screen.

  3. Select Delta Load (Init delta if you do not want to perform full load before delta initialization) from the Extraction mode list box.

  4. Click Execute again in the toolbar at the top of the screen.

  5. Choose either Dialog execution or Background execution.

  6. If delta was not previously initialized first Delta Load will perform Delta initialization + full load