Conversion Artifact Generator

Conversion Artifacts is a set of supporting files used for data upload with SQL Loader. The artifacts are generated based on the table and maintenance object metadata and the definitions from Conversion Master Configuration and Configuration Task Types. Conversion artifacts include SQL Loader control files, input data file specifications and other supplemental files.

  • Input data file specifications provide detailed field-by-field description of the expected data type and format, field order and other instructions. Your implementation may use these specifications to create the legacy data extract.

  • Control file defines the rules and options of the data upload

  • File List enumerates input data files expected to be provided for upload

The generator reads Conversion Master Configuration in order to determine the conversion task type associated with the table or maintenance object.

The generator creates Conversion Tasks, one instance per table and/or per maintenance object, creates attachments that store the artifacts and links the attachments to the Conversion Task as Related Objects.

Note: IMPORTANT: The regeneration is necessary each time the metadata or conversion configurations are amended.

Conversion Tasks query is provided with the base product.

You can choose to generate artifacts for table-level and/or maintenance object-level load, or for the entire system or for specific Table or Maintenance Object:

Generate Artifacts in bulk — for all Tables and/or Maintenance Objects

  • Submit new batch job for Batch Control K1–CNVAG. This process performs a complete refresh of the conversion artifacts. It deletes existing and creates new Conversion Tasks for every Table and/or Maintenance Object that includes tables marked for conversion.

Generate Artifacts for an individual Table or Maintenance Object

  • Navigate to Admin —> Conversion Support —> Generate Conversion Artifacts.

  • Select one of the options:

    • Table search allows you to select specific target table

    • Maintenance Object search allows you to select specific target Maintenance Object.

Note: The process overrides all previously generated artifacts and replaces existing files.

Accessing the Artifacts

Navigate to Conversion Task query and search for the task that is corresponding to a table or a maintenance object. or use other available search criteria. Explore the Attachments collection to view the artifacts.