Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

After all "normal" import processes are done, these scripts/files are executed/imported as a final step to load the OLE data into the database.

ole-cfg-dbs Project Structure

...

Within the ole-cfg-dbs project, there are four major items:

schema.xml

This file represents the structure for the entire database schema. This contains all tables, views, sequences, indexes, and constraints.

data

Each file in this directory contains the data for a single table. These files are maintained in a pipe (|) delimited flat file format.

graphs

The "programs" used by Clover ETL to perform the import. Their main purpose is to map between the files and the database, translating any placeholders for pipes in the data. Graphs only exist for tables which contain data. For performance reasons, tables without any data have their graphs purged during the export process.

formats

The structure used for both the data file and the import into the database. Referenced by the graphs during execution.

Rice Data Locations and Structure

...