Page History

...

Note : Make sure both the tables have sample data in them before they can be mapped within DBSync.

1. Open www.mydbsync.com in your browser and click on Customer Login.
2. Enter in your DBSync username and password to Sign in. Once logged in, click on Launch to access DBSync Integration Console.
3. Once logged into the DBSync console, click on Create New project button .
4. You can use any naming convention for a project as long as there are no white spaces in the name of the project.
5. Once the project is created, click on Connector --- Edit to configure the Connectors.
6. Click on the Create New Connector from the top right section of the page 
7. Enter the name for the connector and select Database Adapter from the drop down. Click on Save button once done. 
8. Similarly, click on the Create New Connector button again to add Quickbooks Connector to your DBSync profile.
9. Once both the Connectors are added, you will see them listed in the connector listing page.
10. Now click on the Edit link next to the Database Connector and enter your Database credentials as shown. In this tutorial, the database used is SQL Server 2005 and corresponding credentials are entered.

...

     12. At this point you have successfully validated your Database Adapter.

1. Click on the Edit link next to the Quickbooks Connector from the connector listing page.
2. Under the file section, enter the full path of your Quickbooks file as shown.
3. You can retrieve full path / location of your Quickbooks file by pressing 'F2' key on your keyboard when in Quickbooks 'Home' page as shown below.

...

      7. Please enter your DBSync password in the password section of the Web Connector and save it. 
      8. At this point you have successfully completed configuring your Quickbooks with DBSync. You can run the integration by clicking on the Update Selected button.

1. Create a project , Process with Names of your choices.
2. Create a Workflow with name "DB2Customer"  *and likewise create another Workflow with name "DB2QBInvoice"*. 
3. Click on Edit of workflow  "DB2QBCustomer" which will redirect the user to Workflow detail page.
4. Create a rule , and select the Target as QuickBooks and choose the object to which you want insert/upsert the records.
5. From the Trigger section, choose the DB connector and from Advanced Query builder , enter the below query , user can run the query and view the result in Query Designer itself.
6. If user wishes to set the properties , can be done from the Properties Tab

   Code Block
   select * from account

         5. For a rule created, set the following properties by selecting the Properties Tab.

...