Customizing the Schema.csv Mapping File

To import from your database using the schema mapping method, you must use the Schema.csv file, which correlates tables and columns in your database to the tables and columns in Harmony. This .csv file is pre-configured for use with the ARIES database.

The Schema.csv mapping files is installed in the following folder:

Windows 7, 8, 10 — C:\ProgramData\FAST Fekete Associates Inc\Harmony<version>\DatabaseMappings\Aries

Schema.csv

The Schema.csv mapping file contains the table and column names in your ARIES database, and the corresponding table and column names that Harmony's database uses.

Data in this file is grouped by table. The groups are introduced by the table name (in a row containing the word Table:), which is followed by one or more rows containing the names of the columns in that table (in rows starting with the word Column:).

The most important columns are the second and third, which contain (respectively) the table and column names used by Harmony and by your database. The column names pertaining to your database must be in the third column in order for Harmony to locate the correct tables and columns in your database.

Note:   If you modify any of the other columns, IHS cannot guarantee success in importing data.