2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This page will demonstrate how to edit the writer component of DBSync.
In order to access the writer, first you will need to open the mapping of a process that you have already created. Please see section 3.1 of the wiki to add a process definition language, and section 4.2 to open a process map for more information regarding creating and viewing a process.

Reference the above screen shot when reviewing the instructions given below.

1. Right-click on the Writer Component and select 'Properties' to view the details of it.

2. Select the Adapter type from the drop down list – Example – QuickBooks Adapter. The properties of the specific adapter are automatically displayed on the selection.

3. Enter the External ID name in the field, if you wish to perform the Upsert operation on the records.
Example-QBName__c

4. Enter the table name that you want to select as the target. (Account for example)

5. Click on the Lookup hyperlink to select the object to which it has to be written.

6. Enter the maxbatchsize that is the maximum batch size of the file as per your requirement. Example – 1000

7. Select the write type from the drop down list. The options available are insert, update and upsert.

8. Click Save to save the information.

9. Click Delete to delete the Writer Component.

10. Click Close to close the Writer window.

Note: A name for the writer must be defined.