Restoring data from an archive file

You can restore data from an IBM® Optim Archive archive file to a connected target database. To restore data, create a new flow in the flow builder tool. Set the archive file that you want to restore as the first node in the flow.

Restoring from an archive

When you restore data from an archive, the archive file acts as the source in the flow.

The data contained within the archive is not automatically unmasked by a restore if masking policies were applied during archive creation. The restore flow extracts the data, as-is, from the archive and moves it to the defined target location.

To restore data from an IBM Optim Archive archive file by using the UI:

  1. From the navigation menu, click Workflow icon Workflow > Flow builder, then click Nodes to view existing nodes.
  2. Drag and drop an Archive node from the Nodes list onto the canvas. This archive will be the starting point and source of your extract flow.
    Added more nodes to the flow builder canvas in the following order:
    1. Access definition

    The definition of the specific data to be extracted from the archive. Access definitions are based on specific source (archive or connection) nodes.

    For information about defining an access definition, see Creating an access definition.

    2. Subset (optional)

    A subset of data from the archive that you want to include in your extracted data.

    For information about defining a subset, see Subsetting data.

    3. Masking (optional)

    The set of masking policies that will be applied to the data being extracted from the archive. Masking ensures that personally identifiable information (PII), and other confidential data are transformed while preserving data integrity and usability.

    For information about defining masking policies, see Applying masking policies.

    4. Target

    The final target location of the extracted data, such as a target database connection.

    For information about defining a target, see Defining a target.

    Note: After you drop a node onto the canvas, the previous node will become locked. This means that it cannot be removed from the canvas unless its dependent nodes are removed first.
  3. Click on any node in the canvas to edit it as needed.
  4. To save progress on your flow at any time, click Save. Saving a flow does not run it as a job; it only saves it as a draft flow.
  5. After building your flow and defining all of your nodes, you are ready to run your flow. A running flow job extracts data from the archive, applies any additional transformations in the flow, and then restores it to the target.

    To run the flow, click Run flow.