Settings

In this section, all writeback-related settings can be configured by the admin.

1. Allow users to configure database connections

Admins can enable or disable users from configuring database connections using this toggle as highlighted below:

Allow users to configure databases - enabled

When disabled, no user can add a new connection to the EDITable visual. They can only connect to the existing database connections that are already configured and available.

2. Request Time out

When EDITable cannot connect to a database connection within a specified time limit, it displays a request timeout error. To avoid this, you can set a custom connection time from the admin console which gives ample time for EDITable to connect to a database before displaying a time-out error.

In the admin console, navigate to Settings and then Writeback > Settings. Under the Writeback destination connection settings, you can set the duration of the request time-out. In the example, we have set it to 300 seconds. EDITable will wait up to 300 seconds for the connection to be established before generating a request timeout error.

Request Time out

3. Batched Write Setting

By default, if your writeback payload exceeds 50k records, EDITable can split the payload into multiple chunks each of size 50k records, and write them back batch-by-batch.

You can change the default batch size of 50k records in the Batched Write Setting section. In the example below, we have specified the batch size as 75k. Batched writeback happens when the writeback payload exceeds 75k records with writing back each chunk of size 75k records.

Batched Write Setting

The request time out and batched write setting can be adjusted when you are working with high volume data to achieve better performance.

Last updated