YAML Configuration

Overview

The YAML configuration file name is specified with a -y option on the command line as in this example:

java -jar jarfile -p dev.profile -y users.yaml

The YAML contains an optional Metrics file name, followed by a list of tables to be loaded. The metrics file (if specified) will be written when the load completes, and will contain start and end times and number of records processed.

metrics: user.metrics
tables:
- source: sys_user
- source: sys_user_group
- {source: sys_user_grmember, truncate: true}

To specify multiple Options for a table, you must indent according to YAML conventions:

tables:
- source: sys_user_grmember
  target: group_member
  truncate: true

or use curly brackets:

tables:
- {source: sys_user_grmember, target: group_member, truncate: true}

JSON can also be used since YAML is a superset of JSON:

{"tables":[{"source":"sys_user_grmember","target":"group_member","truncate":"true"}]}

Keys and values are mostly case insensitive, except for table names which are case sensitive. This is okay:

Tables:
- {Source: incident}

This will not work:

Tables:
- {Source: Incident}

Next

Options