QuickBooks Desktop Connection

Configure QuickBooks to allow an external application to connect

1. In QuickBooks, click on Edit and then select Preferences from the menu options.
2. Select Integrated Applications from the list.
3. Click on the Company Preferences tab.
4. Ensure that the checkbox for “Don’t allow any applications to access this company file” is NOT checked.
5. Click OK to exit the Preferences.

Set up a User account and password in QuickBooks for the Connection Manager to use.

6. In QuickBooks, click on Company.
7. Select Set Up Users and Passwords from the dropdown list and then select Set Up Users…
8. Click on the Add User… button.

9. Enter User Name, Password and Confirm Password for the new account.
10. Click on Next.

11. Select the areas of QuickBooks to which you want this user account to have access. We selected All areas of QuickBooks in this example. If you select Selected areas of QuickBooks, you will go through several more screens to choose the access to allow in each area.
12. Click on the Next button.

13. If there’s a warning pop-up to confirm your selection, click Yes to confirm.

14. A pop-up will display all the areas to which you have given this user access in QuickBooks.
15. Click on the Finish button.

16. The User List will now display the new user you just set up.
17. Click on Close to close the User List.

Configure and start the COZYROC QuickBooks Gateway.

This application must be run on the same server as the server where QuickBooks Desktop Edition is running. QuickBooks Desktop Edition does not provide any support for access over a network. Therefore, the COZYROC QuickBooks Gateway is used to provide that connectivity to your SSIS packages.

18. Using Windows Explorer, find QbConnector.exe by adjusting this path for your server: C:\Program Files (x86)\CozyRoc\SSIS\Tools.
19. Double-click on QbConnector.exe to open the application dialog.

20. In the Connection tab, ensure that the Port is set to 3081.
21. Choose the Mode you would like to use. In this example, we are using Default.
22. You may choose to Accept a connection from Any address or you may specify a specific Address. In this example, we will accept a connection from any address.

23. Click on the Users tab.
24. Type in the Name and Password of the account you just set up in QuickBooks for the COZYROC QuickBooks Gateway to use.
25. Click on the ellipses next to Company and then select the QuickBooks company file for the QuickBooks company you want to access.

26. Click on the Add button to add the new user.

27. Click on the Security tab.
28. Choose the appropriate security option for your environment. In this example we’ll choose Disabled. Note that if you select Disabled here, you will use http:// in front of the server’s address in step 35. If you select one of the security options that uses a certificate here, you will use https:// in front of the server’s address in step 35.
29. Click Start.

30. If you get a pop-up with a Windows Security Alert, check the appropriate checkbox and then click on the Allow access button.

Set up the QuickBooks Connection Manager in Visual Studio.

31. Right-click on the Connection Manager canvas.
32. Select New Connection in the pop-up list.
33. Scroll down to find the QuickBooks connection manager in the list and select it.
34. Click on the Add button.

35. When the configuration dialog opens, enter the IP address of the server where QuickBooks resides with 3081 as the port. If you selected Disabled under the Security tab of the QB Connector, this should start with http://. If you selected one of the certificate choices, this should start with https://.
36. Enter the User name and key for the user you set up in QuickBooks for this application to use. Enter the password in the key field.
37. Ensure that you have the QuickBooks company file open in QuickBooks that you want to access.
38. Click on Test Connection.

39. When the QuickBooks – Application Certificate pops up in QuickBooks, select one of the yes choices under the question Do you want to allow this application to read and modify this company file?

40. You may be asked to confirm your selection in the CozyRoc QuickBooks Gateway – Authorization pop-up if you chose to allow this application to access the company file even if QuickBooks is not running.

41. If you chose Yes, always; allow access even if QuickBooks is not running, then enter the User name of the account to be used to login from your SSIS package.
42. You may or may not want to check the checkbox for Allow this application to access personal data such as Social Security Numbers and customer credit card information.
43. Click Continue.

44. You will see an Access Confirmation pop-up. Click Done.

45. Now you should be back in Visual Studio and should see Test Connection succeeded. Click OK.
46. Click OK again to close the connection manager dialog.

47. If you go back into QuickBooks and look at the Integrated Applications settings in the Preferences, you will see that the User account used by your SSIS package now shows up as an application that has requested access to the company file.

Congratulations! You have successfully configured a QuickBooks connection manager.