Fabric Mirror Writer programmer's reference

Batch Policy

String

eventcount:10000, interval:5m

You may specify eventcount and/or interval, or alternatively filesize (which cannot be combined with eventcount or interval). With the default policy of eventcount:10000,interval:5m events will be written to the Fabric landing zone every five minutes or sooner if Striim accumulates 10,000 events. The filesize value range is 10MB minimum to 2048M maximum; do not set it outside this range. For best performance with a large dataset, set only the interval. See Setting output names and rollover / upload policies for more information.

Connection Profile Name

String

The connection profile for the Microsoft Fabric instance where data will be mirrored. See Introducing connection profiles.

Connection Retry Policy

String

retryInterval=30, maxRetries=3

Specifies the number of times and the time interval between subsequent retries the writer tries to upload a file on a connection drop.

Mirrored Database Name

String

The name of the database in which source data will be mirrored. If the database does not exist, Striim will create it.

Parallel Threads

Integer

For initial load using Database Reader, creates multiple instances of the writer for better performance. For maximum performance, set to one less than the number of available CPU cores.

In the CDC phase, leave blank or set to 1. Parallel threads are not supported in this phase as they can interfere with recovery.

For more information, see Creating multiple writer instances (parallel threads).

Tables

String

Specify the names of the tables to mirror in the format <source>,<target>. Fabric names may not contain special characters.

You can provide multiple mappings with a semicolon as a separator. For example: srcdb.emp1,schema.emp1; srcdb.emp2,schema.emp2. You can also provide wildcards to specify table names, for example: <source schema>.%,<target schema>.% If a table name contains a special character, it will be converted to a valid Java identifier in Fabric; for example, TestDB$Table will be converted to TestDB_DOLLAR_Table.

Optionally, specify KeyColumns with table mapping using the syntax <source table>,<target table> KeyColumns(<target column>). Null values for key columns are not supported. For more information, see Defining relations between source and target using ColumnMap and KeyColumns.

When the source is SQL Server, during initial load using Database Reader, source table names must be specified in three parts (<source database>.<source schema>.<source table>,<target schema>.<target table>), but in the CDC phase, when the source is MS SQL Reader or MS Jet, source table names must be specified in two parts (<source schema>.<source table>,<target schema>.<target table>). The schemas must exist in the target. Table names are case-sensitive.