- Click on Customer Login in www.mydbsync.com and enter the registered user name and password to sign in, then click on Launch to Access DBSync Integration Project Console.
- You will be redirected to DBSync In the Project console, select Process Template from top Menu to add a Process Template in DBSync Console. It will take you to Process Template Pageclick on Template Library on the left panel. List of DBSync will be displayed.
- Choose your process template according to the adapters connectors you have. In this Demo I will be using "Salesforce & QuickBooks Bidirectional" Template. Click on View More Button In front of the Process Template and on the next screen click on Add Now Button Try Now Button next to SalesforceQuickBooks:BiDirectional.
- A new profile will Project will be added in profiles Project section with Process the Template Name.
- Once the process is addedClick on the template SalesforceQuickBooks:Bidirectional, click on "Quick Start" Link in Profiles Section of DBSync Console. You will be presented with a new page to get you started with configurations for Integration.
- Enter your login information in the properties window for Salesforce and click on validate button to validate the login credentials of Salesforce. Once you receive the message "Connection settings are valid" click on Continue button at the bottom. If you receive the message "Connection settings are invalid" then please check the followings
- Check whether User ID and Password for Salesforce is correct.
- Is there any invalid Network Access Settings.
- Make sure that security token is added in your password (for Salesforce Adapter)
- Click on QuickBooks link from the left Menu to open QuickBooks settings. Enter you QuickBooks Desktop file path in the "file:_\* (file:_*)" text box and click on *Save Properties button. Click on configuration Link{_} at the bottom.
- A Pop-up box will appear, asking to open the file with "QuickBooks Web Connector (default)" click on OK button as highlighted below in screenshot.
- Click on OK in the next window (first screenshot below) and on the next window select the option button "Yes, always; allow access even if QuickBooks is not running" and check the check box for "Allow this application to access personal data" and click on continue button (second screenshot below).
- In the Access Confirmation window click on the Done button. And the profile will get added to your QuickBooks Web Connector. A screenshot of the QuickBooks Web Connector is displayed.
- In the Advanced Properties settings select ALL from Log Level Drop Down. Enter your Email- ID in Email Text Box so you can receive notification results for every Integration. Click on Save Button below Email to save these settings. Click on Continue button at the bottom to move to Validate Process.
- On Validate process click on the button Click to Validate Process. This process will check all the Adapter settings, mappings and states for the sync and present you with a report. In the report all the valid actions are marked with a green check icon as
Image Removed and all invalid actions are marked with red minus icon as
Image Removed . If all the actions are valid (
Image Removed ) then click on continue button at the bottom.
- All the default mappings are listed in the left menu. the connectors. You should have Salesforce & QuickBooks connectors. Ensure that both the connector settings are validated.
- You can refer the below link for the details on configuring DBSync with Salesforce and QuickBooks Desktop. http://help2.mydbsync.com/docs1/display/dbsync/Configuring+DBSync+with+Quickbook+WebConnector
- Go to the newly added project SalesforceQuickBooks:Bidirectional, click on the available process.
- You will see list of workflows. Each workflow will have Trigger & Rules.
- Default mappings are listed in the rule of each Rule. You also have the capability to create custom mappings as per your business.
- You can choose to use or not use any mappings, like in the images below the mapping is done for Salesforce Accounts to be moved in QuickBooks as Customers. You can check the Status Check Box to make it part of integration, if you leave it unchecked it will not be part of integration. Similarly you select or deselect other mappings as required. You also have the capability to create custom mappings as per your business process.to use a specific workflow. Status of workflow can be either On or Off. Based on the business process & the integration requirement you can choose which one to keep On. If you want to keep the dataflow moving from Salesforce Opportunity to QuickBooks Invoice, OpportunityToInvoice status should be ON.
Salesforce as Master Database
- Enable the only states highlighted in screenshot below to make Salesforce as The following workflows should be kept on based on the integration requirement to keep Salesforce a master database for uni-directional integration.
- AccountToCustomer
- ProductToItemService
- ProductToItemInventory
- ProductToItemNonInventory
- ProductToOtherCharge
- ProductToDiscount
- OpportunityToInvoice
- OpportunityToEstimate
- OpportunityToSalesOrder
- OpportunityToSalesReceipt
QuickBooks as Master Database
- Enable the states highlighted in screenshot below to make QuickBooks as The following workflows should be kept on based on the integration requirement to keep QuickBooks a master database for uni-directional integration.
- CustomerToAccount
- ItemServiceToProduct
- ItemInventoryToProduct
- ItemNonInventoryToProduct
- ItemDiscountToProduct
- ItemOtherChargeToProduct
- InvoiceToOpportunity
- InvoiceToInvoice
- EstimateToOpportunity
- SalesOrderToOpportunity
- SalesReceiptToOpportunity
Run Integration
- Once you are done with the mappings go to your QuickBooks Web Connector by Start > All_Programs > QuickBooks > Web Connector* and click on the password textbox for profile *{*}dbsync2-SalesforceQuickBooksBiDirectional* as highlighted below:
- Enter your DBSync password in the in the text box and hit Enter on your keyboard. One Message Box will be displayed asking you "Do you want to save this password" select Yes button. DBSync Password will be saved in the web connector.
- Check the DBSync2-SalesforceQuickBooksBiDirectional check box and click on Update Selected button and sync will start and complete automatically.
- Data for all the mappings will be updated in Salesforce or QuickBooks according to the state selection by you., you can run the integration using scheduler or QuickBooks WebConnector.
- If you are using QuickBooks Webconnector 'Auto Run' in QB web connector must be used to run integration on a fixed interval. To run the integration manually, 'Update Selected' in QB web connector must be used.
- You can also use DBSync scheduler to schedule the Integration Run. The details are available in the following link http://help2.mydbsync.com/docs1/display/dbsync/Scheduler
{"serverDuration": 171, "requestCorrelationId": "ef6707b053ad5877"}