Skip to main content

System Setup

Updated over 2 months ago

Once Data Gateway is deployed, system parameters that control data extract process must be set. Many of the parameters related to this process are determined by the Technical Resource when the gateway is configured for the first time. However, there are a few parameters that need to be set based on individual business requirements. These parameters are:

  • EXCALSDATE – The calendar start date. A set of records starting on this date will be created. This is for an Entity called SYCalendar hold dates based on a start date provided in this parameter.

  • EXCALWKDAY – The number of the day of the week considered to be the start of the week. 1-Sunday,7-Saturday. The default is Sunday.

  • EXCALYEARS – How many future years of the calendar should be generated in SYCalendar.

  • EXHIST – The number of days of Change Data Capture history to keep allowing for disaster recovery. Default is 2 days, which should be enough.

  • EXKCOS – A comma-separated list of companies to extract data from.

  • EXPREFIX – Prefix to be used added to the start of the Entity name to create the extract and dataset records. This allows you to ensure that any datasets created for replication do no conflict or overwrite any other datasets that you may have and keeps all the extract datasets together.

  • EXMON - The email address to be emailed in the event of the replication process failing.

Did this answer your question?