The Best Way To Buy!
IP*Works!
Microsoft .NET ActiveX / VB ASP Delphi C++ Builder C++ Java J2EE Unix / Linux Mac OS X .NET CF
IP*Works! SSL
IP*Works! S/MIME
Microsoft .NET ActiveX / VB ASP Delphi C++ Builder C++ Java J2EE
IP*Works! SSH
Microsoft .NET Java J2EE .NET CF
IP*Works! Zip
IP*Works! EDI/AS2
Microsoft .NET Java / J2EE
IP*Works! SNMP
Microsoft .NET ActiveX / VB Delphi C++ Builder C++ Java J2EE .NET CF
QuickBooks Integrator
E-Payment Integrator
Vital/TSYS Integrator
Microsoft .NET ActiveX / VB ASP Delphi C++ Builder C++ Unix / Linux Mac OS X
Paymentech Integrator
FDMS Integrator
Microsoft .NET ActiveX / VB ASP Delphi C++ Builder C++ Java J2EE .NET CF
USPS Integrator
FedEx Integrator
UPS Integrator
E-Banking Integrator
Microsoft .NET ActiveX / VB ASP Delphi C++ Builder C++ Java J2EE Unix / Linux
PayPal Integrator
Amazon Integrator
Biztalk Adapters
SQL Server SSIS Tasks
Windows Workflow
SharePoint Extensions
3-D Secure MPI
Microsoft .NET ASP Delphi C++ Builder C++ Java / J2EE
QuickBooks Integrator:
Access QuickBooks remotely with the Remote Connector for QuickBooks!
/n software Remote Connector is a distributable utility that allows you to connect your QuickBooks Integrator applications to remote QuickBooks instances.
The Remote Connector contains a lightweight embedded web server, which listens for HTTP requests originating from the QuickBooks Integrator components. Each request contains the XML data to be communicated to QuickBooks as well as configuration settings specifying how the connection is to be opened. The Connector then communicates with QuickBooks via COM, and returns the QuickBooks response (or an error message) in the HTTP reply.
The Remote Connector is part of the QuickBooks Integrator and it will be installed in your machine automatically when you install the SDK. Once installed the configuration is easy. Simply set the server port under Client Connection and click Start, and Remote Connector will listen for incoming messages on the specified port. The messages will be processed locally and the results will be automatically returned to the requesting client. If security is desired, a username and password can be required. If so, clients not providing the correct username and password will be refused access to your QuickBooks data. The username and password are specific to QuickBooks Integrator and are not required to be the same as your QuickBooks username and password.
The Remote Connector is part of the QuickBooks Integrator and it will be installed in your machine automatically when you install the SDK. Once installed the configuration is easy. Simply set the server port under Client Connection and click Start, and Remote Connector will listen for incoming messages on the specified port. The messages will be processed locally and the results will be automatically returned to the requesting client.
If security is desired, a username and password can be required. If so, clients not providing the correct username and password will be refused access to your QuickBooks data. The username and password are specific to QuickBooks Integrator and are not required to be the same as your QuickBooks username and password.
To use the Remote Connector you need to set the QBConnectionString property of any of the controls: <control name>.QBConnectionString = "URL='http://www.foo.com:2080'" You may also set a username and password for accessing QB through the Connector. In this case the connection string will look like: <control name>.QBConnectionString = "URL='http://www.foo.com:2080' User='Foo' Password='Bar'"
To use the Remote Connector you need to set the QBConnectionString property of any of the controls:
<control name>.QBConnectionString = "URL='http://www.foo.com:2080'"
<control name>.QBConnectionString = "URL='http://www.foo.com:2080' User='Foo' Password='Bar'"
There is no additional cost for using the Remote Connector. You may install and run it in any machine that has an QuickBooks Integrator runtime license.
If you wish to obtain the source code for the connector so that you can change it to match your exact needs please e-mail or call us for a quote.
Using SSL, along with a digital certificate, greatly increases the security of the Remote Connector. SSL will encrypt all data transmitted across the network, ensuring that only the Connector can read incoming requests, and that only the requesting client can read the QuickBooks responses. This prevents unauthorized parties from accessing your QuickBooks data. You should use a full digital certificate on the server (Connector) side, and this will contain a public key and a private key. This version of your certificate should be kept private. You may export a version of the certificate containing the public key only, and distribute this to all clients that need to communicate with the Connector.
Using SSL, along with a digital certificate, greatly increases the security of the Remote Connector. SSL will encrypt all data transmitted across the network, ensuring that only the Connector can read incoming requests, and that only the requesting client can read the QuickBooks responses. This prevents unauthorized parties from accessing your QuickBooks data.
You should use a full digital certificate on the server (Connector) side, and this will contain a public key and a private key. This version of your certificate should be kept private. You may export a version of the certificate containing the public key only, and distribute this to all clients that need to communicate with the Connector.
In Windows, certificates are commonly stored in system stores. The most common store is the "My" store, which is typically used for your personal certificates. From the "Security" tab, click the "Configure Certificate..." button, and the Connector will allow you to choose a certificate. By default, the Connector will list the certificates in the "My" store; however, you may choose a different store if desired. Additionally, certificates may be stored in PFX files. To use a certificate from a PFX file, click "Select Another Store...", and the Connector will allow you to browse for the appropriate PFX file.
In Windows, certificates are commonly stored in system stores. The most common store is the "My" store, which is typically used for your personal certificates. From the "Security" tab, click the "Configure Certificate..." button, and the Connector will allow you to choose a certificate. By default, the Connector will list the certificates in the "My" store; however, you may choose a different store if desired.
Additionally, certificates may be stored in PFX files. To use a certificate from a PFX file, click "Select Another Store...", and the Connector will allow you to browse for the appropriate PFX file.
If you do not have an appropriate certificate, you may use the Remote Connector to create a self-signed certificate. A self-signed certificate is similar to a commercial certificate, except that your identity is not vouched for by a Certificate Authority (CA). Accordingly, a client machine will need your public-key certificate to authenticate the server. To create a certificate, simply click "Create New Certificate...", and type in an appropriate subject (such as your name, or your company's name). An appropriate certificate will be created in the "My" store, and configured for immediate use. Exporting Certificates If you are not using a commercial certificate, you will need to export public-key certificates so they can be used from the QuickBooks Integrator. To do this, click "Export Certficate..." after selecting or creating your certificate. This will open a new dialog, and allow you to export your certificate into a file. The certificate will be exported as a ".cer" file without the private key, so it is safe to distribute this file anywhere.
If you do not have an appropriate certificate, you may use the Remote Connector to create a self-signed certificate. A self-signed certificate is similar to a commercial certificate, except that your identity is not vouched for by a Certificate Authority (CA). Accordingly, a client machine will need your public-key certificate to authenticate the server.
To create a certificate, simply click "Create New Certificate...", and type in an appropriate subject (such as your name, or your company's name). An appropriate certificate will be created in the "My" store, and configured for immediate use.
Exporting Certificates
If you are not using a commercial certificate, you will need to export public-key certificates so they can be used from the QuickBooks Integrator. To do this, click "Export Certficate..." after selecting or creating your certificate. This will open a new dialog, and allow you to export your certificate into a file. The certificate will be exported as a ".cer" file without the private key, so it is safe to distribute this file anywhere.
Once you have configured SSL in the Connector, and exported your certificate, you should add the following code (or something similar) to your application: (control name).QBConnectionString = "URL='https://www.foo.com:2080' User='Foo' Password='Bar'" (control name).Config("SSLAcceptServerCertFile=c:\exported_cert.cer") Note that if you use SSL, all clients must use SSL (HTTPS) to make connections.
Once you have configured SSL in the Connector, and exported your certificate, you should add the following code (or something similar) to your application:
(control name).QBConnectionString = "URL='https://www.foo.com:2080' User='Foo' Password='Bar'" (control name).Config("SSLAcceptServerCertFile=c:\exported_cert.cer")
Note that if you use SSL, all clients must use SSL (HTTPS) to make connections.
