Metadata in an External Storage

To save space on the primary database of the control system, you can store some large tables with Datafridge metadata in some external storage. You can use any supported storage. However, to ensure better performance of Datafridge, we recommend using some of the fast relational database.

There are three types of metadata which can be stored on an external storage:

  • Object list

  • Object attributes

  • Attachment list

For each logical system, you need to set up the following columns in the logical system record:

  • Metadata storage ID: ID of an external storage which you want to use for metadata.

  • Ext. for obj list: "X" - store object list and object attributes on an external storage.

  • Ext. for attach.: "X" - store attachment list on an external storage.

  • Objlist tabn. prefix: Prefix for the new object list tables (for example ZDVD_OL).

  • Objlisa tabn. prefix: Prefix for the new object attribute tables (for example ZDVD_T).

  • Attach. list prefix: Prefix for the new attachment list tables (for example ZDVD_AT).

  • Package for metadata: Development class for the newly generated tables (for example ZDVD_RMX).

Metadata move

When you have already logical system with metadata stored in the control system and you want to move them to an external storage, you can use process Metadata move.

  1. Start transaction /DVD/RMX.

  2. Select Execute Data Ingestion.

  3. In the form, fill out the fields Run ID and Description.

  4. Click Create.

  5. In the pop-up, select the option Move metadata.

  6. On the setup screen, select Logical system.

  7. Set the parameters according your scenario. You can move metadata from the primary to the external storage or vice versa. You can also move only metadata for some selected business objects and you can also move only some type of metadata (for example only the attachment list).

  8. On the next screen, you can check which metadata will be moved and if needed, remove some of the changes.

  9. The task handler run is now created and you should run the tasks one by one.