Programmers reference for Microsoft Dynamics 365 Business Central Writer

Connection properties

Client ID

String

Specifies the OAuth application's client ID.

Client Secret

Password

Specifies the OAuth application's client secret.

Company

String

Company name in Microsoft Dynamics 365 Business Central.

Connection Pool Size

Integer

20

Specifies the maximum number of active connections.

Connection Profile Name

String

Select the MicrosoftDynamics365 connection profile from the list.

Organization URL

String

URL of your Business Central web service endpoint.

For example: https://api.businesscentral.dynamics.com/v2.0/production/api/v2.0

Refresh Token

Password

Refresh token that can be used to generate and refresh access tokens.

Tenant ID

String

Tenant identifier for Business Central instance.

Use Connection Profile

Boolean

False

Set to true to use a connection profile instead of individual properties.

Scheming and data handling

Batch Policy

String

eventCount:999, Interval:90

The batch policy includes the event count and interval. Events are buffered locally on the Striim server and sent as a batch to the target every time either of the specified values is exceeded. When the app is stopped, any remaining data in the buffer is discarded. To disable batching, set to EventCount:1,Interval:0.

With the default setting, data will be written every 90 seconds or sooner if the buffer accumulates 999 events.

Mode

String

MERGE

With the default value of MERGE, inserts and deletes in the source are handled as inserts and deletes in the target (as detailed in the notes for Merge API).

Set to APPENDONLY to handle all operations as inserts. With this setting:

Data selection

Tables

String

The name(s) of the table objects(s) to write to, in the format <table_object>. The tables must exist when the application is started.

When the input stream of the target is the output of a DatabaseReader, IncrementalBatchReader, or SQL CDC source (that is, when replicating data from one database to another), it can write to multiple objects. In this case, specify the names of both the source and target objects. You may use wildcards for the object names. If the reader uses three-part names, you must use them here as well.

Note that SQL Server source table names must be specified in three parts when the source is Database Reader or Incremental Batch Reader (source.schema.%,%) but in two parts when the source is MS SQL Reader or MS Jet (schema.%,%).

Examples:

Additional properties

Application Error Count Threshold

Integer

0

Application-specific Discarded Event count threshold. The application will HALT if the number of Ignorable errors crosses the threshold value.

Ignorable Exception

String

A comma-separated list of exceptions which are ignored while calculating the Application error count threshold.

Connection Timeout

String

300

Specifies the maximum duration an API call should wait for a response before triggering a timeout exception.