Doris ETL Target

Target Configuration #

Configure the data emitter parameters as explained below.

Connection Name #

Connection name for creating connection.

Use the Test Connection option to ensure that the connection with the Dynamics 365 channel is established successfully.

A success message states that the connection is available. In case of any error in test connection, edit the connection to resolve the issue before proceeding further.

Message Name #

The name for the message configuration which will act as metadata for actual data.

Database Name #

Datbase name for creating connection.

Table Name #

Existing table name for specified database.

Is Batch Enable #

Enable parameter to batch multiple messages and improve write performance.

Batch Size #

It determines how many rows to insert per round trip. This can help performance on JDBC drivers. This option applies only to writing. It defaults to 1000.

Save Mode #

Save Mode specifies how existing data is handled in Doris (in case of batch source). Available options are: Append and Upsert.

Append: The source records will be appended in the specified target per the schema mapping.

Upsert: Updates existing records and inserts new ones.

If Upsert Save Mode is selected, then there should be a unique key present in the table.

Priority #

Priority defines the execution order for the emitter.

Add Configuration: Additional properties can be added using this option as key-value pairs.

Schema Results #

The schema result is displayed having columns in the target table selected for mapping.