MYOB AccountRight Incremental Configuration

See the Connector Marketplace topic. Please request your administrator to start a trial or subscribe to the Premium MYOB AccountRight connector.

Enable Incremental Read #

Use this method to fetch only the new or modified records instead of an entire data load.

Define the conditions to control the incremental data load during application runtime.

Column #

A column should be selected that can act as a reference to identify changes in the data source from the last data movement.

The columns listed can be integer, long, date, timestamp, decimal, etc. It is recommended that the column should have sequential, sorted (in increasing order), and unique values.

Read Control Type #

Select an approach to control the incremental load of data out of the following options:

• None

• Limit By Value

• Increment By Value

The start value should be in the exact format of the reference column. It will be non-inclusive for the application run.

None #

It will perform a full load of the data source for the application’s first run unless the start value is specified. After that, for each subsequent run, the last read record of the reference column will automatically be set as the start value.

Limit By Value #

It will perform an incremental load based on the range provided, i.e., start and end values. For each subsequent run, the last read record of the reference column will automatically be set as the start value, whereas the end value will always remain the same unless changed by the user.

Increment By Value #

It will perform an incremental load based on the start value and increment size. For each subsequent run, the last read record of the reference column will automatically be set as the start value, whereas the increment size will always remain the same unless changed by the user.

Tips for configuring the read control option:

• The start value and increment size should be integers if the reference column is numeric.

• The start value should be a date in the GMT zone, whereas the increment size should be specified in the number of days if the reference column is a date.

• The start value should be a timestamp in the GMT zone, whereas the increment size should be specified in the milliseconds unit if the reference column is a timestamp. For example, 86400000.