<p>We use QuickBooks for financial management, and feed it from a variety of sources. I now need to hook it up to BizTalk, and I'd hate to reinvent the wheel. I've done searches, and as far as I can tell there's no QuickBooks adapter for BizTalk. Does anyone know of anything that'll do the job, preferably something that doesn't suck? </p>

<hr>

<p>Doesn't the QB SDK require that Quickbooks be running on the client machine? Is there any way around it?</p>

[{'answer_id': 45735, 'author': 'seanyboy', 'author_id': 1726, 'author_profile': 'https://Stackoverflow.com/users/1726', 'pm_score': 2, 'selected': True, 'text': '<p>Quickbooks talks .NET quite easily. You\'ll need the QuickBooks SDK 7.0 and a copy of Visual Studio.NET, but after that it\'s very easy to do anything with Quickbooks. </p>\n\n<pre><code>Imports QBFC7Lib\n\nSub AttachToDB()\n    If isAttachedtoQB Then Exit Sub\n\n    Lasterror = "Unknown QuickBooks Error"\n    Try\n        QbSession = New QBSessionManager\n        QbSession.OpenConnection("", "Your Company Name")\n        QbSession.BeginSession("", ENOpenMode.omDontCare)\n        MsgReq = QbSession.CreateMsgSetRequest("UK", 6, 0)\n        MsgReq.Attributes.OnError = ENRqOnError.roeStop\n\n        Lasterror = ""\n        isAttachedtoQB = True\n    Catch e As Exception\n        If Not QbSession Is Nothing Then\n            QbSession.CloseConnection()\n            QbSession = Nothing\n        End If\n        isAttachedtoQB = False\n        Lasterror = "QuickBooks Connection Error. - " + e.Message + "."\n    End Try\nEnd Sub\n</code></pre>\n\n<p>See <a href="http://developer.intuit.com/" rel="nofollow noreferrer">http://developer.intuit.com/</a> for more information. </p>\n'}, {'answer_id': 45915, 'author': 'seanyboy', 'author_id': 1726, 'author_profile': 'https://Stackoverflow.com/users/1726', 'pm_score': 0, 'selected': False, 'text': "<p>Unfortunately it does. It also asks you to authorise any application you've built. (at least once.) </p>\n\n<p>I don't know any way around it. </p>\n"}, {'answer_id': 67747, 'author': 'Chris Romp', 'author_id': 10372, 'author_profile': 'https://Stackoverflow.com/users/10372', 'pm_score': 1, 'selected': False, 'text': '<p>If you do build the integration code using .NET, you may want to consider leveraging the WCF Line-of-Business SDK:</p>\n\n<p><a href="http://www.microsoft.com/biztalk/technologies/wcflobadaptersdk.mspx" rel="nofollow noreferrer">http://www.microsoft.com/biztalk/technologies/wcflobadaptersdk.mspx</a></p>\n\n<p>It\'s not a BizTalk-only technology, despite its categorization.  The SDK is designed to make it easier to create a WCF channel to a LOB application, which can be consumed from almost any other platform.</p>\n'}, {'answer_id': 337042, 'author': 'Keith Palmer Jr.', 'author_id': 26133, 'author_profile': 'https://Stackoverflow.com/users/26133', 'pm_score': 0, 'selected': False, 'text': "<p>The QB SDK <em>does not</em> require that QuickBooks be running on the client machine. It <em>does</em> require that QuickBooks is <em>installed</em> on the client machine. You can access QuickBooks company files even if QuickBooks is not running though. </p>\n\n<p>Have a look through the SDK docs. Additionally, when QuickBooks first prompts you to authorize the application, you need to make sure to tell it to allow access to the company file, even when QuickBooks isn't open/the company file isn't open. </p>\n"}]
['https://Stackoverflow.com/questions/45653', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/2757/']