The Remote Connector includes a host of powerful features for easily enabling secure remote access to QuickBooks from other Apps. Best of all, it's FREE!
An easy-to-use web-based proxy for servicing requests between Apps and QuickBooks Desktop & Server.
Works with any tool, application, or component that can send and/or receive QBXML.
Secure communications enabled through strong SSL/TLS security & Digital Certificates.
Straightforward user-level access controls with fine-grained control of access and permissions.
Advanced connection logging capabilites with configurable output verbosity.
Completely FREE to download & use. Want to distribute with your application? Contact us for licensing.
Using the Remote Connector for QuickBooks is easy. To get started:
That's all there is to it. Once you have the Remote Connector running, it will create a web entry-point to service remote QuickBooks requests
All of the CData Software Tools, Drivers, and Adapters can seamlessly interact with the Remote Connector.
To get started, simply set the
URL property / parameter of the Drivers connection string, to the
location where the Remote Connector will accept incomming requests. The CData Drivers will then use the Remote
Connector for all QuickBooks data requests.
More information about using the CData Drivers for QuickBooks is available online, at http://www.cdata.com/drivers/quickbooks/
There are no additional costs for using Remote Connector with any CData product. You may redistribute derivative products freely as long as you are a licensed user.
The /n software QuickBooks Integrator components support connectivity with the Remote Connector. To use Remote Connector you simply need to set the QBConnectionString property of any of the controls.
controlname.QBConnectionString = "URL='http://www.foo.com:8166' User='Foo' Password='Bar'"
This will instruct the control to direct its request to Remote Connector instead of the local instance of Quickbooks.
More information about using the /n software QuickBooks Integrators is available online, at http://www.nsoftware.com/ibiz/quickbooks/
There are no additional costs for using Remote Connector with any of the /n software QuickBooks Integrator components. You may redistribute the executable freely as long as you are a licensed user of the QuickBooks Integrator.
Remote Connector hosts a lightweight webserver when launched. This server accepts incoming HTTP POSTs containing QBXML as the body and executes the QBXML directly with QuickBooks. The QBXML response is returned in the HTTP response body.
To issue a request to QuickBooks through Remote Connector, first define a user in the Remote Connector and define permissions. The HTTP POST must use Basic authorization to authenticate to Remote Connector. The body of the POST must be the fully formed QBXML that adheres to the Intuit specifications.
For example, assuming the Remote Connector is running on
could issue an HTTP post similar to the following:
POST / HTTP/1.1 Host: localhost:8166 Authorization: Basic dGVzdDI6dGVzdDI= Accept-Encoding: gzip, deflate Connection: close Content-Length: 166 <?xml version="1.0" ?> <?qbxml version="3.0"?> <QBXML><QBXMLMsgsRq onError="stopOnError"><CustomerQueryRq><OwnerID>0</OwnerID></CustomerQueryRq></QBXMLMsgsRq></QBXML>
After QuickBooks processes the QBXML the server will respond to the POST with the QBXML returned by QuickBooks in the body:
HTTP/1.0 200 OK Content-Type: text/plain X-AcctSyncConnectorVersion: 2.0 Content-Length: 755 <?xml version="1.0" ?> <QBXML> <QBXMLMsgsRs> <CustomerQueryRs statusCode="0" statusSeverity="Info" statusMessage="Status OK"> <CustomerRet> ... </QBXML>
More information about using the QuickBooks SDK and QBXML is available on the Intuit site at https://developer.intuit.com/docs/0200_quickbooks_desktop/0400_tools/quickbooks_desktop/download_the_sdk#/621