Roadmap for inserting data with Optim on distributed platforms

Use this roadmap to guide you through the insert process with Optim™ on distributed platforms.

To insert data:

  1. Create an insert request
    Use the Insert Request Editor to define parameters for processing the insert request. These parameters include the source archive file and processing options. You must also include a table map, which can include a column map.
    • Create a table map

      Use a table map to specify correlating source and destination tables of compatible data. You can map tables that have different names, modify table names, exclude tables from a process, or include column maps for greater control over the data.

    • Create a column map

      Use a column map to define the specifications for mapping columns of compatible data between source and destination tables. You can map unlike-named columns, modify data, or exclude columns from a process. You can include one or more column maps in a table map.

  2. Run the insert process

    Use the Insert Request Editor to run the insert process. The insert process inserts data from an archive files to the original or to a different database.