oracle2postgresql_cfg.yaml

batch_size: 25 # used when importing attributes
oracle_con_string: 'oracle+cx_oracle://username:password@oradb.example.com/?service_name=gprod.example.com&encoding=UTF-8&nencoding=UTF-8'
postgres_con_string: 'postgresql+psycopg2://username:password@127.0.0.1/dbname'

import_attributes:
# structure:
# "select stmt":
#    attribute_name: value

  "select distinct userid || '@example.com' from alumni":
    eduPersonAffiliation: alum

import_table:
# structure:
  #  source_table: source_table_name
  #  columns: ['first','second']
  #  changed: ['timestamp_column']

    source_table: w_exp_passwd_all2
    columns:
      - people_id
      - login
      - first_password
      - second_password
    changed:
      - first_password_modified
      - second_password_modified