# Elastic Search import tool configuration file

# directive: locale
locale: en_US

# Eligible objects for Search
# directive: objects
objects:
  sdm_index: nr, cnt, cr, KD, kdlinks, trending, pcat
  sdm_autocat_index: autocat
  catalog_index: service_offering, service_request
  sp_index: search_history,autocat_search

# directive: index; mandatory
# name of the elastic search index
#index: sdm_index, sdm_autocat_index
index: sdm_index, sdm_autocat_index, catalog_index, sp_index

# name of the auto-categorization source and target indices
autocat:
  source: sdm_index
  target: sdm_autocat_index

# database connection
database:
  # directive: type; mandatory 
  # which database system to use "oracle"|"mssql"
  type: mssql
  # directive: host
  # database host name or IP address
  # example: localhost or 127.0.0.1
  host: bosd1sql\test
  # directive: db; mandatory 
  # database name
  # example: mdb
  db: mdb
  # directive: user
  # database user
  user: ca
  # directive: password
  # password for the database user
  password: 2J05e1gOOD/vvEXunPAaVyEgX6FOV0bhtMra0rG7IS5HBz67gU5xjB0WFRDD3MXWE7pX55xdLZs=
  # directive: port
  # port of the database server to use
  port: 58146 
  # directive: query_timeout
  # a value for how long an SQL statement is allowed to be executed before it is considered as lost. 
  # Default is 1800
  query_timeout: 1800

# Metrics logging can be enabled to watch for the current transfer statistics.
metrics:
  # directive: enabled
  # if true, metrics logging is enabled. Default is false
  enabled: true
  # directive: interval
  # the interval between metrics logging. Default is 30 seconds. 
  interval: 1s
  logger:
    # directive: plain
    # if true, write metrics log messages in plain text format. Default is false
    plain: true
    # directive: json
    # if true, write metric log messages in JSON format. Default is false
    json: false

# directive: max_bulk_actions
# the length of each bulk index request submitted (default: 10000)
max_bulk_actions: 20000

# directive: versioning
# Setting to control concurrent updates
versioning: true

#detect_json - if json structures in SQL columns should be parsed when constructing JSON documents. Default is true
#set to false to handle scenario where the value contains json like structure. ex:"inc_desc":{"paradigm":6}
detect_json: false

#Limit the initial load to number of years
dataload_limit: 10y