Page History

• Go to www.mydbsync.com, Select Customer Login. Enter your User Name Username 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:

• 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.

• Click the Create Adapter Button on the left hand side.

• Click the Create Adapter Button on the left hand side. Enter the Adapter Name, from AdapterType Drop Down Select Intaact Email Service and Click on Save Button.

• Adapter will be created and will be listed in the Adapter section of the Process Builder.
• Click on Edit link in front of the Email adapter and you will be presented with properties for the Adapter at the bottom left of the window. Enter values for all the properties and click on Save Properties. Both the sections of the window are shown below sequentially.

• Click on Validate Link Next to Email Adapter. A message box is displayed; if the message says "Connection Settings are valid" you are good to go. Else Click on Edit and enter correct values for Adapter properties and repeat the steps. Click OK.

• Right Click \ Open on the Process Name "SalesforceDatabase" to open the process in the Control flow for DatabaseSync process.

• The process will contain 3 States by default:
  1. Start_state
  2. Sf2db
  3. End_state

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. 

• 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.

• Double click on Execute state to open data flow for Execute state. Drag the Reader button onto the data flow area and enter the Name for reader and click on OK Button. In this tutorial I am using "DBReader" as the reader name.

• 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.

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

...

• Right Click\Properties on DBReader. The properties will be displayed in the bottom left area of DBSync Console. Select Console Adapter from Adapter Drop Down. Click on Save button to save the settings.

• Right Click\Properties on DBWriter. The properties will be displayed in the bottom left area of DBSync Console. Select Email from Adapter Drop Down. Once Email Adapter is selected, all the properties for DBWriter will be listed in the properties area. Enter the values for body, recipients, subject and sender (sender Email ID). Click on Save button once done.

• 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.

•  button to launch Project console.

• Click on Project on the left section of console. Click on the existing project SalesforceDatabase.

• You will see the existing process SalesforceDatabaseBidirectional.

• Click on Connectors on the left section of Project console. You need to create a new connector Email Connector.

• Click on Create New Connector enter the connector name as Email & select the connector type as Email Service Adapter and click on Save.

• Enter all the required details, click on Save & then Validate connection.

• Email Connector is created and the connection is validated.

• You will see the existing connectors Salesforce and Database. Ensure these connectors are also validated.

• Go to Process SalesforceDatabaseBidirectional, create new workflow Email.

• Open the workflow Email, you will see Trigger on the top and Rules in the bottom.

• In Trigger, select datasource as Console Adapter.

• In Rules, click on Add New Rule, Select Target Connector, Operation, Target Object as Email, Insert, Email respectively.

• Click on Map in this newly created Rule. You will see the target fields in the left section of Mapping screen.

• Enter the required values for the Target field. Save and Close. Save Workflow.

• Ensure that Workflow status is On.

• You are now ready to run the sync. Click on the Run Button next to the Project SalesforceDatabase.

• You can run the integration using the Run button or the Scheduler in the left section of Project console. Run button is available once you open the project.

• Using the button Logs in the left section, you can view the Logs.

• Once the integration is complete, you will receive an email based on the settings specified in the Map of the newly created Rule.

• This concludes brief introduction on building DBSync integration data flow from Intacct to Database.