Edit Fields
You define the fields to be transferred together with their properties.
Context
If you have created the open hub destination based on a template, you will be offered all fields from the template as fields for the open hub destination. You can edit the field list by removing or adding fields. You can also change the properties of these fields.
If the template for the open hub destination is a DataSource, the field SOURSYSTEM is automatically added to the field list with reference to InfoObject 0SOURSYSTEM. This field is required if data from heterogeneous source systems is being written to the same database table. The data transfer process inserts the source system ID that is relevant for the connected DataSource. You can delete this field if it is not needed.
If you have selected Database Table as the destination and Semantic Key as the property, the field list is given an additional column. You can define the key fields for the semantic key here.
Procedure
- Choose the Details tab.
- To add an InfoObject, choose Add InfoObject. Specify the start of the name, select an InfoObject from the result list, and press OK. You can also select multiple InfoObjects by pressing Ctrl + Shift. The InfoObjects are added to your open hub destination. Any compound characteristic are added too.
- You can now configure further settings for the InfoObject properties in the right screen area.
- To add a field, choose Add Field. The field is added to your open hub destination. You can now define the field in the right area of the screen.
- Enter a description for the field.
- You can specify an InfoObject under Identify with:. This changes the field into an InfoObject. The properties of the InfoObject are applied. You can undo this by switching to Field under Identify with:.
- Specify a data type and data length for the field.
- To delete InfoObjects or fields, choose Delete Field(s).
- Under Manage Keys, you can define keys for the open hub destination.