Creating an any-to-any map for sequential file to COBOL conversion

A map is a set of instructions used to transform source data in one format to destination data in a different format. ECMap provides many options for your source and destination data. Each can be a flat file, a database, XML/HTML, or standards data – X12, EDIFACT, or HL7. This means that ECMap can convert X12 data to a flat file, a flat file to a database, EDIFACT to XML/HTML, a database to HL7, a flat file to a flat file, a database to a database, HL7 to X12, and many other combinations.

During this tutorial of ECMap, you create and run a map to convert data from the format of one proprietary application to the format of a different proprietary application. ECMap calls this kind of map an any-to-any map. The data in each application is a flat file.

For this exercise, you are a company called Major Insurer, Inc. that sells insurance policies to large companies. In order to provide health insurance coverage to the employees of these companies, you need enrollment information for each covered employee. The goal of this exercise is to create and run a map to convert data from the format of the proprietary Human Resources application of your trading partner, Big Manufacturing Company, to the format of your own enrollment database.

Complete this exercise in three easy steps:

  1. “Setting up your mapping environment”

  2. “Mapping your data”

  3. “Running your map”

Install ECMap on your PC to use this tutorial.

WARNING! You must create the following directory in order for the map to run:

c:\QT\output

StepsStarting the tutorial

  1. From the desktop, double-click the ECMap (globe) icon on your desktop. (When you install ECMap, the installation process automatically places this icon on your desktop.)

  2. In the Password text box on the Login window, type ecmap. Press Enter or select OK.

    The main ECMap window opens and you are ready to begin the tutorial. To perform actions in ECMap, you can use the menu options at the top of the window or the icons on the toolbar. (The icons are also available on the ECMap Work Space, which can be opened by choosing Workspace from the View menu on the main ECMap window.)

    Table 1-1: Menu icons

    Project

    Map

    Company

    Partners

    Application Directories

    Files/Databases

    Records/Tables

    Memory Variables

    Rules

    Mapping

    Map Flow

    Generate Map

    Run Map

Hints