application development – Cooper Mann Consulting

January 26, 2016February 3, 2016

No REST for QuickBooks Desktop Integration Developers

Intuit, the maker of QuickBooks small business accounting software (among other things), is discontinuing service for the REST API and the Sync Manager on March 1, 2016 [1]. Developers with applications which integrate with the desktop editions of QuickBooks using this method must change their approach right away or risk having their integrations simply stop functioning. It’s not that Intuit will DO something on March 1^st. Rather, they’ll stop doing something – like handling Sync Manager integrations.

There are a lot of different types of businesses in the world, and each of them produces and consumes a lot of information. From sales to human resources; from operations to finance – every business generates and manages information to support the various processes which make up the business activities. Computer systems and software represent the tools businesses use to develop and manage information, and often become foundations for structuring the information which flows through the organization. Just as there may be different people in the business, each with their own responsibilities and job functions, there are likely software applications which are similarly oriented to support different processes within the business. Integrating or connecting different applications and processes within the business helps the organization be more efficient with information usage, generally increasing the quality of access and reporting throughout the business while at the same time reducing or eliminating redundant data entry and the potential for errors. Software integrations are a big thing to many businesses, which is why the discontinuation of Intuit’s Sync Manager for QuickBooks Desktop editions is a big deal.

Intuit’s Sync Manager was the big thing just a few short years ago. Providing developers with a seamless method for accessing QuickBooks company data and passing it to/from web-based and other applications was a boon to the online application model and paved the way for many disk-based integrated solutions to migrate to SaaS offerings instead. Developers who saw success operating in Intuit’s QuickBooks marketplace as recognized add-ons were encouraged to use Sync Manager so that they would be able to seamlessly market to, subscribe and onboard new users who purchased QuickBooks products. Whether or not the developer participated in Intuit’s application marketplace, the Sync Manager and the REST API provided them with some very important capabilities and supported new methods now recognized as “standards” for development of web-based solutions and services.

The World Wide Web has succeeded in large part because its software architecture has been designed to meet the needs of an Internet-scale distributed hypermedia system. The modern Web architecture emphasizes scalability of component interactions, generality of interfaces, independent deployment of components, and intermediary components to reduce interaction latency, enforce security, and encapsulate legacy systems. http://dl.acm.org/citation.cfm?doid=337180.337228

In order to integrate a solution with QuickBooks desktop products, there are two essential problems to solve. First, there must be access to the QuickBooks data. Few products are able to directly access the data in a QuickBooks data file; generally, the QuickBooks program itself is used to ‘broker’ access to the company file. So, developers need a way to work inside of QuickBooks to use it to access the data their applications need. Second, the data must be transported (via the Internet) to allow for data to come from QuickBooks into another app, or to allow data from the other app to come to QuickBooks. The REST API and the Sync Manager addressed both of those problems and provided developers with the mechanisms required to facilitate the data integration as well as transport the data.

REST (representational state transfer) is “the software architectural style of the World Wide Web [2]” and represents a standard for creating scalable, distributed system interactions. Using this method, developers were able to make their online solutions access, read and write data in QuickBooks desktop products because Intuit had first sync’d the data to its servers, so developers needed only to reach the Intuit servers to reach the data. The Sync Manager provided the transport, carrying the data to/from the desktop installation where the Sync Manager service was running. And, because the Sync Manager was basically built-in to QuickBooks, there was no additional software to install and maintain on the computer because it was all part of the QuickBooks installation.

Intuit did a fantastic job of getting developers to move to the API integration method, positioning all those lovely 3^rd party solutions for linkage via an Intuit.com account and, now, to QuickBooks Online. Intuit is clearly favoring the QuickBooks Online edition and the API integration method available with that platform, and is telling developers that they must convert their customers to QBO in order to retain the easy connective ability they had with the desktop editions via Sync Manager.

Now that Intuit has announced the discontinuation of the REST API and the Sync Manager, what options do QuickBooks integration developers have, and how can customers using 3^rd party integrations keep using them? Options do remain, and they aren’t all that bad. In fact, the options which remain continue to be the methods of choice for certain developers. These developers recognized early on that Intuit’s somewhat “lightweight” methods couldn’t handle the complexity or full functionality of their integrations facilitated their solutions using the SDK and never looked back (and still don’t). For this community of developers – many of whom likely never considered trying to market their solutions in the Intuit app marketplace – the elimination of the REST API and Sync Manager don’t really matter. They didn’t bother with them in the first place, just as they aren’t bothering with QBO. Those solutions don’t fit their customers, anyway.

The QuickBooks desktop SDK (Software Development Kit) has been around for years, and using the SDK developers have been able to craft tight integrations between their solutions and the QuickBooks desktop products. From payment plug-ins to fully integrated sales, customer relationship, inventory and manufacturing solutions – a broad range of integrated applications built with the SDK have been successfully deployed to QuickBooks customers all over the world. Many applications which integrate with QuickBooks desktop solutions are desktop products themselves and are designed to work within the same desktop and network environment as QuickBooks, so there is no need to worry about “transport” of the data over the Internet.

For other solutions, such as online applications and services, there may be a need to exchange data via the Web. The QuickBooks Web Connector has also been a very popular solution for developers of applications that integrate data with QuickBooks. The Web Connector is just what its name implies: it is a way to connect QuickBooks to the web and vice versa. With the Web Connector application and a web connector configuration file, developers could provide a method of exchanging data between QuickBooks desktop and another solution fairly simply. While the Web Connector is quite useful in providing a means to transport integrated data to/from the QuickBooks desktop to an external system (like an online application), it only allows access to whatever data Intuit decides. For this reason, many developers use both an SDK application and the Web Connector so their applications can access all data required and also have a web service available to transport it.

There are numerous implications relating to the sunset of QuickBooks REST API and Sync Manager, and another among them is the impact in hosted environments. For customers who are (or might) benefit from hosted QuickBooks delivery models, what does the end-of-life of the Sync Manager mean? Since the Sync Manager was basically built into QuickBooks desktop editions, it meant that there wasn’t any extra software to install or manage when a company wanted to adopt a Sync Manager-based 3^rd party integrated solution. In a hosting environment, this means that the customer could easily add integrated applications to work with their hosted QuickBooks and the service provider might never even know it was being done. There would be no additional software to install on the host servers; so many providers would simply be unaware that their customers were using these other solutions.

As developers return to SDK and Web Connector implementations in order to integrate with QuickBooks desktop, customers will ask their hosting providers to install the QWC (QuickBooks Web Connector) and/or integration software in their service. In shared service delivery models, this may be virtually impossible to do without potential compromise to existing customers using those servers or other applications resident on the systems. Hosting customers will not always understand that a “simple plug-in” actually represents installable software that must be secured, maintained, managed, and kept from improperly interacting with other software in the environment. Some providers may not even be willing to work with the new integration software, while others may allow it but will not take adequate precautions to ensure proper and secure function.

Intuit has said to many constituent groups that its focus on desktop editions of QuickBooks will continue, and new certifications and benefits for desktop ProAdvisors (and continued development of interoperability with other solutions, like the Revel POS integration for QuickBooks desktop) give support to those statements. Yet developers who support integrations with QuickBooks desktop are once again adjusting to the not infrequent changes Intuit makes to developer programs and philosophies. The push to QBO and connected apps may be the focus for QuickBooks marketing dollars, but there are still quite a number of (very busy!) developers supplying solutions to businesses who don’t shop inside their QuickBooks software.

Joanie Mann Bunny Feet Make Sense?

[1] https://developer.intuit.com/blog/2014/09/08/timeline-to-discontinue-the-quickbooks-desktop-rest-api

[2] https://en.wikipedia.org/wiki/Representational_state_transfer

February 14, 2013

Getting out of IT Jail

I have a friend in the accounting/technology industry that spends way too much time on his business in-house IT. He’s always futzing around with servers and workstations, fixing corrupted data files or PCs that won’t launch applications, and setting up remote access so he can work at home (which he never actually does because he’s at the office fixing IT issues). More often than not, when I try to get time to chat with the guy, his response is “I’ll have to call you later; I’m in IT jail”. As a side note, my friend is Doug Sleeter, a recognized leader in the world of small business accounting and among QuickBooks accountants, consultants and advisors.

My friend works a lot with different solutions and technologies designed to make it easier and more effective to get accounting and business information collected, processed, stored, and reported. He reviews tons of different solutions each year, and looks for those he believes can truly make a positive impact in the life of a business owner. My friend also, as he puts it, “eats his own dog food”, meaning that he actually puts into place many of the solutions which he finds to be beneficial so that he can experience their benefit in his own business. His proven experiences then translate to support for the solution in the market. People need to know that a solution will actually do what it is supposed to do, and many wait for someone else (someone they trust) to go first so they can use the customer feedback to help them make a decision.

My friend clearly recognized the growing value of cloud solutions and how implementing cloud-based services to solve specific business problems might be a more effective and affordable way to address growing business needs than with traditional ERP models or installed software approaches. Using different tools that work together (his term for this is “chunkify” 🙂 ), even very small businesses could now affordably address the various operational and financial information management needs which exist at some level in all businesses. Following along with his previous commitment to use and not just talk about these things, he began the process of selection and implementation of various cloud-based applications, tools and integrations for his desktop QuickBooks software.

No battle plan ever survives contact with the enemy. thesis on Military Strategy, German Field Marshal Helmuth Karl Bernhard Graf von Moltke

It was going great. Application services subscribed to were working as expected, and all sorts of information was fairly seamlessly flowing to and from QuickBooks. And then, it happened – his bookkeeper moved away and wasn’t able to work in the office where the accounting software and data were housed. Take a deep breath. Okay, so back to the remote access thing, and more IT jail.

He worked diligently to create remote access for the now-remote bookkeeper, and remote desktop service worked OK, but it was “a pain to keep working, and it never could give the type of performance we were trying to give her”. Go figure, the one piece of the puzzle left in the office was the one making everything else more difficult and costly. He was in IT jail once again.

The final step was to get the QuickBooks software and company data out of the local network and in a safe and secure and fully-managed environment. Particularly since QuickBooks is (in this case) the centerpiece of the business accounting system, it became essential to place it in an environment where it would be maintained, monitored, and protected by people who specialize in that sort of thing. My friend, like most business owners, just didn’t have the time and resources to have the level of IT and management that an outsourced commercial service provider could offer.

See The Sleeter Group’s QuickBooks and Beyond article Still Addicted to Desktop Software? Get it Hosted in the Cloud

Intuit even recognized that businesses needed a better way to run and manage their QuickBooks desktop software, so they created an accredited hosting program to allow service providers to offer application hosting and license management services to QuickBooks users. My friend now uses one of these providers to host his QuickBooks and other desktop applications. He still has all the integrations and features he had before, but isn’t required to spend time and productivity fixing hardware issues or software installation problems. His software is installed, maintained, and actively supported by IT professionals who are focusing on nothing more than keeping his systems up and running.

In his own words, “the hosting move offloaded us from having to mess with providing access, and at the same time it improved performance and delegated the IT management”.

For a time my friend and his business went without a high level of IT management and support, but now he completely recognizes that he needs it and is finding it to be well worth the cost. Now he’s got his own “get out of jail” card.

Make sense?

In case you didn’t know it, both Intuit and Sage have programs for service providers, providing authorization to host and deliver small business financial software products to direct customers.

Get information on Intuit’s Authorized Commercial Hosts for QuickBooks here, Get information on Sage hosting partners here.

If you need assistance deciding how to get your applications and business online, or selecting and implementing with a service provider, we can help.

October 11, 2012March 28, 2018

Knowing Your Options: Hosting QuickBooks for Shared and Remote Access

Intuit’s QuickBooks financial applications, the desktop editions in particular, are the most popular small business accounting solutions on the market. The QuickBooks Online Edition, Intuit’s cloud-based contender, is not quite as accepted among accountants and advisors for a variety of reasons. Being in the cloud isn’t necessarily one of those reasons, if you consider the growing demand for access to multi-user cloud-hosted QuickBooks desktop editions. Mostly it comes down to functionality and how the application operates. QBO just isn’t like good old desktop QuickBooks and isn’t the preferred solution for many financial professionals or their clients. Yet these users still want and need remote access and mobility. This is where hosting comes in.

QuickBooks hosting and creating the ability to access QuickBooks applications and data remotely is something that a lot of businesses can benefit from. Whether it’s to outsource the management and maintenance of servers and systems to a 3^rd party, or to create the ability for remote workers or contractors to collaborate with real-time applications and data, there may be a need for a hosted application approach. Business owners and IT managers need to give consideration to the level of service and support they and their users will need before selecting their provider. Knowing what the provider will handle and what the subscribers are responsible for might make all the difference in determining the right approach.

In-House DIY Hosting

Local networks and PCs allow users in the same location to share resources, like printers and data storage locations. Typically, desktop computers have application software installed on them, and use the network to access shared data. When users work outside of the network, getting access to applications and data might not be so easy. Even extending the network via VPN access doesn’t solve the problem when the desktop applications are not designed to access data over remote connections (desktop applications like QuickBooks). It used to be that the only reasonable way to allow remote users to access and run QuickBooks as if they were inside the LAN was to set up remote desktop or application servers (terminal servers). MyQuickCloud is a product that addresses this need very gracefully, providing in-house personnel with the tools necessary to establish a secure cloud for QuickBooks access directly from existing on-premises systems.

Co-location and Outsourced Infrastructure (IaaS)

Instead of setting up remote access solutions in the office, many IT departments find that co-location with a 3^rd party addresses a number of issues. Leasing equipment, operating system and virtualization tools may be more cost-efficient than purchasing them directly, and the security and redundancy in most hosting facilities far exceeds what most businesses are able to afford to implement by themselves. Co-location provides managed service for infrastructure elements, but doesn’t necessarily address business needs in terms of user security or application and data management. These elements are traditionally left up to the subscriber; installing and configuring software applications, establishing user and application permissions, and managing updates and software upgrades. For this reason, co-location may be a good option for a business with internal IT staff, but not necessarily for businesses seeking “full service” application hosting.

Application Service Providers (ASP) and Managed Application Hosting

Application hosting service providers handle software installation and management, user and security administration, and ongoing technical support as part of the subscription service. Customers need only to provide their software licenses, name users and upload data in order to use the service. The service provider does the software installation and configuration, sets up the users and establishes permissions, and connects users and applications to managed data storage. This model allows businesses to enjoy many of the benefits of a cloud-based or SaaS solution model while also allowing them to continue to use software solutions they are already invested in, in terms of both software licensing and process development. On the other hand, these models can be extremely restrictive in terms of the applications or integrations they will support, and can be quite costly as the number of users or applications hosted increase.

Whether you roll your own (DIY hosting) or work with a full service QuickBooks host, accessing business applications and data from anywhere is an option every business can take advantage of.

Make sense?

Read about the race to find the secret sauce of hosted application services for small businesses

October 8, 2012March 26, 2019

Cloud Hold-Out No More: QuickBooks Desktop Editions in the Cloud

When most people hear the words “QuickBooks” and “online” together, they think of the web-based solution from Intuit called QuickBooks Online Edition. And why wouldn’t they? With the media, industry talking heads, and everyone in information technology discussing cloud this and cloud that, all the attention is going to web-based applications, Software-as-a-Service models, and cloud platforms. While these approaches to business software distribution and delivery are working for a lot of software vendors and their customers, there are a few hold-outs that may be keeping a lot of folks from considering that move to running their businesses “in the cloud”. Intuit QuickBooks desktop editions used to be among this list of applications securely anchored to your local PC, but not anymore.

The desire to have remote and mobile access to business applications and data goes beyond simply getting email or syncing contacts to a mobile phone these days. Business people in all industries are seeing the benefits of using wireless and mobile laptops, tablet computers and smartphones to handle tasks in real-time rather than accumulating paperwork, spending a bunch of time organizing and keying in data, and then submitting the information for batch-processing after the fact. And, with services being seamlessly connected and information being shared and integrated for a variety of reasons, internet connectivity has become almost as essential to most businesses as telephone service. (Actually, in many cases, telephone service IS delivered via the IP network, so maybe that statement doesn’t make as much sense as it used to.) Payroll isn’t calculated in the software, it’s calculated by a service online and delivered through your software. Same with banking, accepting payments, and paying bills – many are processes handled through the software but perhaps not actually happening WITHIN the software on your PC.

As users have begun to realize that, whether they mean to or not, they are essentially “on line” with their business applications and data at some level, the consideration for outsourcing more of their IT operations and working more fully in an online model might not be so bad as long as they don’t have to give up the functionality, usability, and cost-efficiency they have come to expect with their beloved business applications – like QuickBooks.

Service providers recognized this opportunity and developed business models which would give users their desired desktop applications (like QuickBooks!), but in way that seems more like a cloud service. As platform and virtualization technologies have evolved, businesses are finding that there are numerous options, and numerous providers, for getting their desktop and network applications installed in the “cloud”, and delivered back to them as a managed subscription service. It is a model which is growing in popularity and demand, and it makes sense.

Small businesses in particular are moving to the cloud not because they are generally dissatisfied with the products they currently have (there’s a reason Intuit has market share with QuickBooks; there are a LOT of QuickBooks desktop lovers out there). Small businesses are making the move to online and “cloud” models because of the business benefits of getting information when and where they need it. Mobility is driving the cloud, and the cloud is driving software makers to change how they do things.

It will be a while before all the investments are made and man-hours are spent to rewrite or redevelop applications to run on these new platforms and in this new cloud-based service model. In the meantime, ISVs will look to hosting providers of various sorts to help breathe longevity into their solutions while securely embracing their customers and market in preparation for a cloud-based service delivery, and customers will engage with service providers who can supply them with the legacy application hosting and management they require to achieve the level of freedom, access, and mobility they demand.

Make sense?