Syncing QuickBooks Data with Microsoft Azure

Synergration has a nice syncing solution, they write:

Posted by Synergration

Due to popular request we decided to implement support for Microsoft Azure into our OpenSync QuickBooks sync solution. There are few steps required on the Azure-end to make the connection but once you do you will be able work with it just as you would any OpenSync database.

First are the requirements:

• OpenSync version 2.0.51 or later
• Windows 7 , Server 2008 or later
• The 32 bit SQL native Client version 10 or later. This can be downloaded frommicrosoft.com

And finally the steps to add a Microsoft Azure database:

1. Create a new database within the Azure management web site.
2. From the Azure management site, select the new database and it will allow you to “View SQL Database connection strings for ADO .Net, ODBC, PHP, and JDBC”
3. Copy the connection string for ODBC to the clipboard. It should look something like this: Driver={SQL Server Native Client 10.0}; Server=tcp:vea9bx4fvo.database.windows.net,1433; Database=QBTest; Uid=Synerg123@vea9bx4fvo; Pwd={your_password_here}; Encrypt=yes; Connection Timeout=30;
4. Click on the link to “Set up Windows Azure firewall rules for this IP address to enable Azure access from your IP address.
5. Switch to OpenSync and add a new database
6. Set the database type to SQL Server
7. Select the option to Add tables to existing database
8. Select the option to Specify connection string and then past in the connection string from step 3. Make sure to replace the section “{your_password_here};” with your actual password. Also, if you are using a later version of SQL Native Client then update the “Driver={SQL Server Native Client 10.0}” section as well.
9. Specify an OpenSync name for the database
10. Click save

The Azure database can now be used as any other database in OpenSync. Woo-hoo!  If you have any issues, please leave a post in our support forums