(Glue-2408) ODP Replication

In this page you will find a step-by-step list on how to set up an ODP Extraction.

Create SNP Glue™ Table

1. Go to transaction /dvd/gl80 right click on desired package and hit Create Glue Table.

2. Fill in Table name and confirm.

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

   Open

   

4. Click on fields tab an click button Import fields in toolbar.

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

   Open

   

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

7. Table is now active and created on target storage.

Create ODP Fetcher

1. Go to transaction /dvd/gl80 right click on desired package and hit Create Extractor 2.0 Object.

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

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

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

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

Create Glue Table Consumer

1. Go to transaction /dvd/gl80 right click on desired package and hit Create Extractor 2.0 Object.

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

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

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

Create Extraction Process

1. Go to transaction /dvd/gl80 right click on desired package and hit Create Extractor 2.0 Object.

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

    

3. In Parameters fill in Fetcher and Consumer names and hit enter.

4. Click Suggest transformation mapping in 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 in case you do not want to perform full load prior to delta initialization) from 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