Page History

The Writer Component

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 Creating Process Definitions of the wiki to add a process definition language and to open a process map for more information regarding creating and viewing a process.

Image Removed

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. When the adapter is selected as Salesforce, External ID field will show up.

    Enter the External ID name in the field, if you wish to perform the Upsert or update operation on the records. "Example: QBName__c".

    If insert operation is required External ID field should be left bank.

4. Enter the Table name that you want to select as the target. (Example: Account when the target adapter is Salesforce)

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: 100)

7. When the adapater is selected as QuickBooks, pkey field will show up to mention the primary key.

    If you wish to perform Upsert or update operation on the records enter the pkey name in the field.

    Click on the Lookup hyperlink to select the primary key. "Example: Name".

    If insert operation is required pkey field should be left bank.

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

9. Click Save to save the information.

10. Click Delete to delete the Writer Component.

11. Click Close to close the Writer window.

Note: A name for the writer must be defined.

A workflow is a collection of one Trigger and set of Rules required to perform an integration; The below screenshot illustrates the workflow listing page ,all the workflows have sequence in order of execution ,user has to just drag and move to change the order of sequence .

The statuses can be set to on or off directly from this page itself. The On status will enable a workflow for execution  either by schedule or by Run now action, off status will disable a workflow for execution either by schedule or by Run now action.

The properties can also be set by selecting the appropriate fields and clicking on save, in case if users changes to erase all earlier setting then he has to enter backspace where ever required and save them. Image Added