(Glue-2108) Changed scenarios of Glue objects

Glue Transport Management enables you also to change Glue objects on the target system. 

Supported changes for specific objects

Glue Table

Glue objectScenarioStatusNotes
TableAppend fields to a Glue table(tick)

Columns are appended (added to the end of the table).

If applied, Datavard Glue also adjusts the extractor automatically without any need to transport it.

If a field was added only to an external storage table, the source field is empty. If a field was added to the SAP source table, it's mapped to a new field in the Glue table.

Recreate a table structure(error)

If you deactivate a table or add fields to the middle of the table structure and then activate and transport it to another system, you will receive an error. This error occurs, as adding fields to the middle of the structure isn't valid ALTER TABLE operation. 

To recreate a table structure, delete the original table from the target system using a deletion transport and then import the modified table using a standard transport mechanism.

Remove fields(error)Removing a field from a Glue table requires deactivation of the table. This means that you must follow the same procedure as described above.
Modify File storage options(tick)

Modification of File storage options is possible except for changing the Container name parameter.

To modify it, delete the original table from the target system using a deletion transport and then import the table with the modified container name using a standard transport mechanism.

Change description(tick)Change of table description is allowed. To change the description goto edit mode, change the description to desired one and activate table.

Glue Table created from external table


Glue objectScenarioStatusNotes
TableAppend fields to a Glue table(error)

Appending fields to a table created from external is not supported.

Recreate a table structure(error)

Altering a table created from external is not supported.

Remove fields(error)Removing fields from a table created from external is not supported.
Change description(error)Changing table description is not supported.

Extractor 1.0 objects

Glue objectScenarioStatusNotes

Extractor



Add routines(tick)
Add selection fields(tick)

Add source fields

(tick)


Change Skip initial Full load(error) The value of Skip initial Full load flag will stay unchanged on the target system

Variant

Change package size(tick)
Change the select option values(tick)

Extractor 2.0 objects

Glue objectScenarioStatusNotes
FetcherChange selection fields(tick)Selection fields are changed accordingly.
RDE flag(tick)

Check/uncheck the "Read deleted entries" flag in Fetcher is changed accordingly.

Change source object(tick)

Change source object to fetch data from e.g. SAP Table.

This change will affect objects using the fetcher.
Change delta type(tick)Delta type is changed.
Change load type(tick)Load type is changed.
ConsumerChange enable merge(tick)Enable merge is checked.

Process

Change start/end routine(tick)Start/end routine is changed.
Add routines(tick)


QueueChange description(tick)The description is changed.
Change structure(tick)The structure is changed.
Change list of subscribers(error)The list of Active queue subscribers will stay unchanged on the target system.

Depending on the changes you performed on the source object, you should either use a standard transport or a deletion transport to transport the updated object to the target system.

  • If you perform changes on the Glue object with a green status in the table below, you should use the standard transport for updating the object on the target system.
    In this case, proceed as described in the section Transport object to a target system.

In this case, you alter a Glue object in a way that is marked red in the chapter Supported changes and transport it with standard transport, the transport of this Glue object will fail.

  • If you perform changes on the object with a red status in the chapter Supported changes, you have two options on how to transport the changed object to another system.

    We recommend using the first option, as you may transport changes from a source system to a target system without deleting the Glue object on the source system. During this option, delete the Glue object on the target system first and then import the changed Glue object from the source to the target system.

The first option consists of these steps:

  1. Change the Glue object on the source system.

  2. Create both deletion and standard transport for the changed object (this step will save user the need to use two separate transports) in both cases use the same Request Number when collecting changed object
  3. Release this transport through standard SAP procedure
  4. Import this transport through standard SAP procedure
  5. Import this transport through Glue TMS (/DVD/GLTR)

Glue TMS will delete the changed object and create it with made changes with one transport. 


The second option consists of these steps:

  1. Delete the Glue object on the source system.

  2. Create and import a deletion transport for this object.

  3. Create a newly changed Glue object on the source system.

  4. Transport newly changed Glue object through a standard transport.