Page History

...

• Go to www.mydbsync.com, Select Customer Login. Enter your User Name and Password and click Login Button.
• Go to My Home and click on Launch Button in Console Area.
• In this tutorial I have used profile named Salesforce-Database. The Profile will be listed in the profile area as shown below:

Image RemovedImage Added

• Click on the Manage?Edit link on the right side of the profile Name. You will be redirected to the Process Builder window in the DBSync Console.

...

Drag the Create State Button onto the control flow Area to create a new state. Enter the state name as "Email" and click on OK Button. A new state will be created and placed on control flow area. Image Added Image Removed

• Wiki Markup
  Click on *\[X\]* icon on *sf2db* to delete the control flow from *sf2db* to *End_state.*

• Right Click\connect on sf2db followed by left click on Execute will create a control flow from sf2db to Execute.
• Right Click\connect on Email followed by left click on End_state will create a control flow from Execute to End_state. All the control flows are displayed using arrows from one state to other state. Below you will find 2 screenshots one containing no control flow and second containing control flow as Start_state to sf2db to Execute to End_state. Once done click on Save button at the top right corner of the window.

...

• Follow the same step for Create Map and Create Writer button. And you will get a data flow area as shown below in the screenshot. In this tutorial I have used "DBMap" for Create Map and "IntaactWriter" for Create Writer component.
  1. Reader: Reader is a process component that reads data from source "data source". Reading the data is also known as "Extracting" the data. Note one state can have only one Reader.
  2. Map: Map component converts data into the format that could be understood by writer and target data source. Converting the data so that it could be understood by target data source is also known as "Transforming" the data. Note One state can have more than one Map.
  3. Writer: Writer component writes the data to target "data source". Writing the data into a data source is also known as "Loading" the data. Note One State can have more than one writer.

Image RemovedImage Added

• Right Click\Connect on DBReader followed by left click on DBMap will create a control flow from DBReader to DBMap.

Image Removed   Image Added
Image Removed Image Added

• Right Click\Connect on DBMap followed by left click on DBWriter will create control flow from DBMap to DBWriter. All control flows will be displayed using arrows. A screenshot is shown below displaying the control flow after following the above process.

...

• Right Click\Properties on DBMap. Enter 1 in the sequence text box. Enter description for the mapping. Click on Edit link for *****_map.xml file. You will be presented with a new window with source and target columns. Just keep the mapping *Validate = "true"* to execute this state.

...

• Once you are done close the mapping screen from close button on the top right. In the DBSync Console click the RUN button to run the sync (A screenshot is shown below). Once Sync is complete you will receive an Email with the settings in writer adapter.

Image Removed