Source Config Reference

The source always contains a schema, which is an array of Column elements and/or Calculated Column elements. Optionally you can also add a Filter element and an actionTypeColumn attribute (details of this attribute are at the end of this page). Below is an example of the Source page where the data source is chosen as a Cinchy Table:

On top of Cinchy Table, there are many other types of data sources and each data source type will have a different set of attributes supported.

If the data source is Cinchy Query, Cinchy Table, Delimited File or MS SQL Server then there is the option to load metadata using the dialog, which assists the user in loading the columns they want to sync.

Note: The Username/Password must belong to a non-Single Sign On Account which has access to the Source Table.

More information on how to use the Load Metadata dialog can be found in the Connections Usage Example.

For all other data sources there is no Load Metadata dialog. The Supported Data Sources page has a full list of all data sources and their varying attributes.

Attributes:

actionTypeColumn

(Optional) Specify a column from the schema that provides instructions on whether the record is an UPDATE, DELETE or INSERT, doing so will bypass the reconciliation process using the specified instruction.

Note: In the Connections experience, actionTypeColumn is on the Sync Behaviour page.

Below is an XML snippet using actionTypeColumn, Column, Calculated Column and Filter.

  <Datasource actionTypeColumn="ExampleColumn">
    <Schema>
      <Column name="Source Column Name"/>
      <Column name="ExampleColumn"/>
      <CalculatedColumn name="Source Calculated Column Name" formula="CONCAT(a,b)" />
        ...
    </Schema>
    <Filter>filter condition</Filter>
  </DataSource>