AccessBooks RealTime

Access

Time to upgrade?   Need help?

AccessBooks RealTime

5.00 out of 5
(4 customer reviews)

$129.00$299.00

Are you tired of poor or slow ODBC connections to your QuickBooks data? AccessBooks RealTime provides a QuickBooks export and sync solution. Using advanced database replication technology, AccessBooks RealTime natively synchronizes your QuickBooks company file to an external Microsoft Access database, or to a Microsoft SQL Server, MySQL or Oracle database in the Plus edition.

Login or register to download a 30-day free trial of AccessBooks RealTime

  • Microsoft Access Database Support
  • Dynamic Synchronization
  • Built-in Scheduler
  • Database Independent
  • Increased processing speed over qODBC connections
  • Ability to export raw report data and build custom reports
  • Ideal for use with Crystal Reports
  • Support for Custom Fields export
  • Enhanced table support: Transaction, Billing Rate, Unit of Measure, Inventory Site, Transfer Inventory
  • Integrated database browser
  • Support for enhanced custom fields in QB 2010 and 2011
  • Support for large item tables

  • All standard features
  • MySQL, Microsoft SQL Server, and Oracle database support


Clear selection
SKU: ABRT. Category: . Tag: .
  Do you want to install AccessBooks RealTime on more than one computer? Copy for a friend perhaps? Buy additional licenses now and take 25% off your entire order. Massive savings!

Product Description

QuickBooks export made easy

AccessBooks RealTime provides a QuickBooks export that enables you to write queries that execute against a true database engine and achieve performance gains of up to 100% over the native QuickBooks QODBC driver. And if you also need to update QuickBooks, our AccessBooks Updater product will propagate changes made in the database back to QuickBooks. Now you can build truly scalable applications that share data with QuickBooks.

With the QuickBooks export functionality AccessBooks RealTime provides you can build solutions that support several hundred concurrent users with a standard ODBC interface. All data made available by Intuit through the QuickBooks API can be quickly and easily exported to a database. This includes support for US, UK and Canadian versions. A built-in scheduler allows you to easily configure how frequently the database is synchronized with changes in QuickBooks. In addition, a built-in report tool enables you to export standard QuickBooks reports into database tables. AccessBooks RT also supports the export of custom field data, command line support and the ability to filter the exported QuickBooks data.

Additional Information

Supported QuickBooks Versions

QuickBooks 2004-2014 Pro, Premiere, and Enterprise

Requirements

Microsoft Access for Standard versions or an instance of Microsoft SQL Server, MySQL, or Oracle database server for Plus versions.

FAQ


AccessBooks RT version 7 provides access to all of the features supported by the QuickBooks 2011 programming interface. AccessBooks RealTime 7.0 also supports Oracle database servers.


You can choose minimize AccessBooks RT to the System Tray in the Options tab of Configure AccessBooks RT. To then minimize AccessBooks RT, you must click the red X in the upper right corner. To close the program, click Close AccessBooks RT.


As long as the path name and access permission is correct, you can run AccessBooks RT from a terminal server and access any QuickBooks company file on the network; however, you must have QuickBooks installed on the same workstation running AccessBooks RT.


No, because ListIDs aren’t unique over multiple company files, AccessBooks RT is restricted to one.


Synergration currently offers AccessBooks Updater, the complementary program to AccessBooks RT, which takes your AccessBooks database and imports it back into QuickBooks. A free 15-day trial is available for download.


Your install is most likely corrupted. Please reinstall AccessBooks RT. In addition, please ensure that you’re using a US, UK or Canadian version of QuickBooks Pro/Premier/Enterprise 2003 or later and the appropriate database software.


Either your path name to the specified database is incorrect or you need to install the appropriate database software. If you’re using MySQL, please ensure that your MySQL Connector/ODBC is up to date.


In order to access Accounts, you must have Allow this application to access Social Security Numbers, customer credit card information and other personal data selected for RT’s access permission. To change RTs access permission in QuickBooks go to Edit -> Preferences -> Integrated Applications -> Company Preferences, select AccessBooks RT and click Properties.


AccessBooks RT creates the entire qbXML structure for the databaase. Some of these vestigial tables, such as the Deleted tables, have negligible use, while others are only used by certain versions of QuickBooks, and as such, are not populated by RT.


Due to security changes in the latest version of the qbSDK, full credit card numbers can no longer be exported from QuickBooks 2008. If you choose to export credit cards to the AccessBooks database, only the last four digits will be exported with all other numbers being X’d out i.e. xxxxxxxxxxxx1234.

5.00 out of 5

4 reviews for AccessBooks RealTime

Add Review  If you leave a review we will send you a 5% off coupon. We love feedback.


  1. support
    5 out of 5

    :

    We’re using ABRT since 2005. We were looking for tool allowing export QB data to MS SQL Server, so we can provide custom complicated reporting to our clients online. Command line support was another requirement, so synchronization can be scheduled without user interaction and with multiple QB files. We found ABRT as perfect match. Over past 9 years of using ABRT we have no problems with it. Currently we’re maintaining multiple MS SQL Server databases with ABRT scheduled daily synchronizations plus manual updates as needed. Our QB files are large and transactions to be updated are big as well and ABRT handles it nicely. In our perspective, the best feature of the product is managing Database connection failure during synchronization. We don’t have to worry about missing/partial data in Database. If connection drops, ABRT synchronizes everything properly (no duplication, no corrupted data, etc) on next run. Overall, great product. Thank you!

  2. Tiffany
    5 out of 5

    (verified owner):

    We are performing a data migration from QuickBooks to another system and there is some information in QuickBooks that simply cannot be shown in a report through QuickBooks, such as which bills or invoices a payment was applied to. This product solved our problem by allowing us to directly access the data, including relationships, so we could create our own reports with no limitation. It’s great having this much access to the behind the scenes data.

  3. Bernie Lutz
    5 out of 5

    (verified owner):

    I have been using AccessBooks RealTime for many years assisting other QuickBooks customers with application and report development. AccessBooks RealTime drastically reduces development time due to a very efficient and fast transfer from QuickBooks into the AccessBooks RealTime database. Besides great products, Synergration has top notch customer service and support. Keep up the great work and thank you!!

    Bernie Lutz

  4. Nick Hopper
    5 out of 5

    (verified owner):

    We are using the pro version and installing and configuring the software was really easy. The software does exactly what is says with no issues. Having Quickbooks tables available in an SQL database made integration with our other internal systems a breeze.

Add a review