Glue (Glue-2005) Change Scenarios of Glue Objects

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

In the table below you can find a more detailed description of particular scenarios.

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 a 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(error)

Modification of File storage options is not possible.

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

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)