legacy applications – Page 2 – Cooper Mann Consulting

May 14, 2013March 26, 2019

Hosting All My Applications in the Cloud

Many business owners will recall when their first in-house computer networks were installed. When the PCs were networked together in an office, it made file sharing and collaboration among team members easier and more efficient. Installing additional applications on the PC was a relatively simple process, and when the new application came with the ability to integrate with another app already on the PC, it was often a fairly simple process to get the two “talking” together. But installing and integrating applications on your personal computer is a bit different from getting multiple applications installed and integrated with a cloud hosting service provider.

In almost all cases, integrating multiple desktop software solutions requires installing those solutions on the same computer so that they can share certain program elements or, at least, share .ini or data files. Application integration is important because it allows different software solutions to work together, communicating data from one application to the other so the information may be used in different ways or for different purposes.

An example of this might be a Microsoft Office integration with QuickBooks, which allows the user to perform a one-click export of QB financial data to an Excel spreadsheet. Another example is the integration between QuickBooks and Fishbowl Inventory, which synchronizes information from the Fishbowl inventory system into the QuickBooks financial software.

In nearly every case where a software program has a software-based integration with another solution, the integration must be installed in the same system as the core solution. In the QuickBooks world, this means that the programs which integrate with QuickBooks must be installed on the same computer as QuickBooks.

In a conventional PC network, the necessity of installing the various software solutions on the same machine is not a big problem as PC software and integrations have been implemented in this manner for years. On the other hand, when the business is considering the option of moving desktop applications to the cloud, it is important to make sure the provider and service will allow all of your products to be hosted. In most cases, this requirement highlights the main difference between a shared service versus a dedicated or server-based solution.

With shared services, the servers are generally configured to offer a strict and limited set of applications to be hosted. The applications on the servers are used by subscribers of the service, and users are limited to accessing only those applications available in the environment. The shared approach is popular with some application hosting providers as it creates an economy of scale which helps providers to earn more revenue on their infrastructure. The trade-off is that a shared hosting solution only works well for businesses with a limited application requirement, and is generally fairly expensive when more users are added to the service.

The need for diversity in hosted application choices, coupled with the need for businesses to keep costs down even as the number of business users increases, are the primary drivers for adoption of dedicated and server-based cloud hosting solutions. When the solution is managed as an entire environment rather than on an exclusively per-user basis, an economy of scale is developed within the organizational IT infrastructure. As the business grows and adds more users and applications, the incremental costs to bring each user or application onto the platform is often far less than a user subscription in a shared solution.

For any business planning to migrate their server and systems to the cloud, the first step is to have a thorough understanding of the applications and integrations the business needs in the host environment, and then to find a hosting provider that can deliver the infrastructure and baseline system administration required. It is unreasonable to expect a hosting provider to be an expert with every software product available, but skilled and experienced hosting providers understand how to generally install and implement most standard business applications and will rise to meet the customer demand.

While no business can guess what their future software needs may be, decisions can be reasonably made based on the solutions currently in use. Finding a provider with a service to meet immediate needs is useful, but businesses change and therefore business requirements change, and it is good to know that the hosting infrastructure and IT services supporting the business can adjust to those changing needs. After all, cloud hosting of applications and data just means the servers and infrastructure are with the service provider and not in the office, but it doesn’t mean businesses can’t have the feature-rich and functional applications their businesses have come to rely on.

Make sense?

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.

January 23, 2013

Licensing and Virtualization: Changes to SPLA May Impact Provider Cost Models

In many application hosting environments, machine and operating system virtualization provide the only realistic means for delivering services for applications which were never designed for high-volume multitenant implementation. In these environments, providers rely upon technologies from Microsoft, VMWare, Citrix and Parallels to provide containment of application environments, creating frameworks where single-tenant applications and hosted infrastructure may be affordably offered to subscribing business customers. Because many of the applications being hosted today do not conform to the various standards which exist for high-volume and multitenant delivery, providers have taken what we’ll call “creative” approaches to virtualized application and environment implementations. Under certain licensing models, these approaches may be sustainable for a period of time. However, recent adjustments to core licensing components and pricing from key providers, Microsoft in particular, may significantly impact the cost of service delivery for providers with less than optimized infrastructure.

One of the notable changes in the Microsoft SPLA (Service Provider License Agreement) is the treatment of Windows and RDS users in the “desktop as a service” model. In previous editions of the SPLA, as was offered with 2008/R2 licensing and prior, providers could select from two different models when implementing service: the SAL-only (server access license) model, which applies on a per concurrent user basis to the infrastructure, or the PL (processor license) model, which applied to the processors installed in systems with Windows operating system and SQL server instances.

For high-density and multitenant environments, the per-processor approach is far more cost efficient to implement, as it allows the provider to create a scale economy with the infrastructure, leveraging hardware and resources across many subscribing tenants. Reducing the cost model to a base infrastructure rate also introduced predictability and stability in recurring costs for the provider, even as subscriber numbers and subscription revenues increase.

The problem reveals itself with the providers deploying “not optimal” infrastructure, whether by design or due to legacy application requirements. These providers rely upon the per-user pricing models to support access and usage to the infrastructure, largely due to the fact that the infrastructure has grown “out” and not “up”. Deploying more servers and more VM instances allowed these providers to present legacy applications as part of a managed application service model. While the management of the infrastructure is greatly complicated with this approach, it is often the only means to addressing the needs of popular “noncompliant” applications (such as Intuit QuickBooks and Sage 50). With the SPLA changes introduced for Windows 2012, these service providers may be in a bit of a tough spot. You see, the per-user option for licensing Windows server access is gone, and only the per-processor licensing model remains.

Microsoft is wisely addressing the needs of the market which is demanding more capability and affordability in terms of cloud-based access to applications. These pricing adjustments are necessary to support the needs of service providers who are increasingly stretching their infrastructure investments to deliver higher user density at a lower per-user cost. Further, application developers seeking new markets and delivery models are taking advantage of these virtualization approaches, creating hybrid and hosted solution models around their legacy application products. The licensing approaches which support these higher density application deliveries introduce options for developers to optimize their applications for the hosted model rather than dealing with immediate comprehensive re-development (which isn’t an option for many ISVs – independent software vendors).

The IT world is forging ahead with cloud computing, high-capacity infrastructure, and heavily virtualized environments supporting larger numbers of users. Software developers must take heed, and embrace these deployment models (or at least adjust to the point of supporting them) in order to have a chance at keeping pace in the anytime, anywhere world of today’s business technology. This means working collaboratively with hosting service and infrastructure providers, crafting services which have the required scalability and incorporating a deployment model agile enough to take advantage of infrastructure licensing benefits as they are introduced.

What was a serviceable pricing structure yesterday may be an anchor holding your profitability down tomorrow. Service providers – make sure you’re keeping a close eye on licensing requirements and delivery cost models, and consider that building up your infrastructure capability is often more cost efficient than building out.

Make sense?

BuildingUP.biz | CooperMann.com

Licensing for Hosted Application Services: Why it costs what it costs

read more about the confusion over hosted licensing on The Progressive Accountant http://www.theprogressiveaccountant.com/tech-tips/confusion-over-hosted-licensing.html

December 12, 2012

The True Cost of the Cloud

Excerpt from article on Intuit Accountants News Central: The True Cost of the Cloud

“Accounting professionals are strongly encouraged to adopt cloud computing models in their practices, and there can be little argument that mobility and access are driving the need. In concert with the messages supporting mobile access to business information – and the value of anytime, anywhere access – cloud service providers are strongly suggesting that the overall cost of purchasing and maintaining information technology (IT) in the business is much lower when a cloud computing approach is used.

Arguments over the total cost of IT and related services become somewhat subjective. Many business owners and managers fail to consider the value of their own time spent dealing with business technology issues, much less the time spent by in-house employees and remote workers. To further complicate the issue, dramatic changes in process support and delivery, connected service and cloud computing approaches are impacting business productivity and profitability in new and dramatic ways. As a result, every business should consider the costs and the benefits of this new connected and collaborative working model.

At the core, cloud computing is really just an outsourced IT service that addresses the various levels of application and computing infrastructure. From IaaS (infrastructure as a service) to SaaS (software as a service) and all things in between, a viable cloud computing approach for a business may encompass little more than co-location of physical server and network resources with a third-infrastructure provider to something much larger scale, such as offloading virtually every aspect of application management and delivery to a SaaS solution.

Because there is no single, correct definition of what makes up a “cloud” service model, attempting to compare costs directly to a more traditional IT approach is quite complicated.”

Read the entire article at Intuit Accountants News Central

http://blog.accountants.intuit.com/ways-to-grow-your-business/the-true-cost-of-the-cloud/

November 20, 2012January 26, 2016

QuickBooks SDK Integrations, Cloud Hosting, and the Customer Relationship

Intuit QuickBooks desktop editions are the most popular small business accounting software products on the market, boasting somewhere in the neighborhood of 3.5M users. In contrast to the QuickBooks Online Edition, which has approximately 300,000, desktop QuickBooks still reigns supreme with small business.

While QuickBooks satisfies most of the general business functionality required from a general accounting product, it doesn’t address much else. For this reason, numerous software developers have created the software products – the extensions, integrations, widgets, and tools – that make QuickBooks more useful to the business.

The sheer popularity of the QuickBooks product line has supported the creation of a very large and diverse community of developers who make things that work with QuickBooks. However, as with any attempt to bring like-minded people together, the QuickBooks developer “community” is not all-inclusive, and there are lots of ISVs (independent software developers) out there who aren’t communicating with Intuit frequently, and who aren’t necessarily exposing their solutions through the Intuit marketplace and other Intuit-branded venues. In many cases, these are developers who have line-of-business solutions that represent the operational priority for their business clients, and where the integration to QuickBooks financial is somewhat of an after-thought. In many cases, these solutions rely on QuickBooks only for general back-office account functions, where the GL, AR and AP are all that really matter. The “tough stuff” is done in the line-of-business application.

Most of these types of solutions, as well as many with more complicated functionality or data integration requirements, utilize a method of communicating with QuickBooks developed using the QuickBooks SDK, or software development kit. This SDK was originally introduced as a means to replace the clumsy IIF import facility, an early way to get data into QuickBooks from other systems. The SDK is really a tool kit designed to facilitate desktop application integrations, which is why so many developers use this method. Particularly when an application is intended to be used on the desktop in conjunction with QuickBooks, it makes sense for developers to use an integration method that will allow them to produce the rich experience and seamless re-use of data that the desktop environment allows. The SDK requires that the QuickBooks program be present, and QuickBooks controls access to the data file rather than allowing the 3^rd party application to have direct data access.

The new method for integrating with a QuickBooks application is by using the IPP (Intuit Partner Platform) method, which is essentially an API (application programming interface) which simplifies the creation of data streams to and from the QuickBooks database. This method of integration is intended to be serviced by the Intuit Sync Manager (included with QuickBooks), where your data first syncs to Intuit servers, and then connected apps sync from that source. In this case, Intuit acts as the intermediary, hosting the synchronized data and controlling the sync with the QuickBooks database. While this may be much easier in terms of offering stricter standards for QuickBooks data integration, it is not a method which addresses the needs of those solutions requiring an integrated experience involving QuickBooks programs and data, or which have more complex data integration requirements than may be served through the IPP.

Because the QuickBooks SDK has been around for many years, it allowed for very stable QuickBooks-integrated solutions to be developed. In comparison, the IPP is pretty new and has taken Intuit a few tries to get working. For this reason, there is a limited catalogue of solutions available in the Intuit App Center, which is where IPP solutions are promoted. Moving forward, Intuit has stated that the focus will remain on the IPP, with the SDK no longer being a preferred (or supported) method.

The method of integrating with QuickBooks desktop editions matters, especially if you’re looking to bring your business applications to the cloud. Application hosting services is the way to “cloud-enable” desktop solutions, yet not all hosting providers recognize or understand the differences in how applications might integrate with QuickBooks, and what that means to the technical and user environments. Not all applications are created equal, and not all QuickBooks integrations are, either. Some integrations sound simple enough to implement, yet have hidden requirements that make deployment with a host or outsourced infrastructure provider an interesting endeavor to say the least.

Developers using SDK integrations with QuickBooks should make certain that they have thoroughly discussed their solution requirements prior to deploying their applications with any host, particularly with a client-selected provider. Companies experienced in hosting QuickBooks are not necessarily adept at understanding the nuances of SDK-developed integrations, and may minimize the technical requirement to the point of leaving your company and your customer with a bad feeling about hosting. In worst-case scenarios, the software developer loses their customer altogether due to a poor experience with the solution in a hosted environment.

Cooper Mann Consulting is working to help developers and commercial ISVs with QuickBooks-connected solutions get their products to the cloud, and in a way that they can influence and help control the all-important customer experience. Rather than being just one of a few hundred hosted products customers can select from the provider menu of offerings, we believe your solution should be delivered with your values, your message, and your unique service approach. Doing so allows you to keep your arms firmly wrapped around your customers and users, working closely with them as you develop your solutions towards a true SaaS or cloud application model, and easing the transition from desktop to web application delivery and subscription service.

Intuit believes they own the relationship to all QuickBooks customers, and they’re right to the extent that the user relies on QuickBooks for some business functionality. Hosting service providers think they own the customer relationship because they have significant influence over the products accessed from their servers.

Operational support solutions go deeper into the business than any high-level accounting product, and the method of deploying the solution (locally installed or hosted) is an IT issue and nothing more. As a developer or provider of essential solutions which address specific vertical industry or line-of-business needs, and as the company who understands the business of your customer and supplies those solutions that help them perform, don’t you really think you should own that customer relationship? We do.

Make Sense?

Want to know more about how Intuit is changing their approach to QuickBooks integration? Read Charlie Russell’s rant: Is Intuit Abandoning QuickBooks SDK Developers?

Read more about QuickBooks cloud hosting: Cloud Hold-Out No More: QuickBooks Desktop Editions in the Cloud

Read more about cloud development: Lessons Learned (or Not): Development and the Cloud

November 19, 2012

Simultaneous Syncing Sinks Solution: Extend Access but Control Integrations

Accounts and ProAdvisors: Make sure you “enable” only those who need it

In this wonderfully interconnected world of hosted and online applications and the integrations which complement them, it is important to not let the excitement of connectivity and collaboration replace reasonable control. While there is much conversation on this topic when it involves file sharing and similar services, the discussion of data synchronization and data integration doesn’t often come up. However, it has been my experience that there is usually a misunderstanding in how, exactly, a particular sync or integration should be applied and who should have access to the functionality when it is deployed as an extension of the QuickBooks desktop financial software.

An example of the problem might be seen when QuickBooks desktop editions are set to integrate or sync data with a web-based solution such as Method Integration or Santrio Open for Business Order Bridge. Solutions like these, which extend the functionality of QuickBooks through extending access and integrating data, rely upon QuickBooks integration functionality move data between their solutions and the QuickBooks database. These solutions are quite beneficial for businesses because they can affordably deliver support for various business functions via a true web application and incorporate QuickBooks data in those application views. Additionally, this type of solution is able to push information from the web application to QuickBooks, allowing for complete integration of financial and other relevant data.

While having this type of integrated service is beneficial, there are a lot of businesses who don’t fully understand how to appropriately implement the solution and end up creating a great deal of difficulty for themselves. One of the most frequent failures I have seen when implementing this type of solution is where the customer doesn’t really understand who should or should not have the integration.

When a web-based solution exchanges data or syncs with QuickBooks, a path is created to communicate between the two systems – the web solution and the QuickBooks application and data file. This path must be open, and both sides of the communication identified, in order for data to sync. The most important thing to remember is that there should be only one controlling entity on each side handling the integration. What this means for QuickBooks users is that only one installation – one PC accessing QuickBooks – should be configured to facilitate the primary integration with the QuickBooks company file.

To illustrate, consider an implementation of Method Integration and QuickBooks that was done for a business some time ago. This business used Method-based applications for a variety of business functions, and those applications used data sync’d from QuickBooks desktop. Just after implementation, it was discovered that system sync’s were not happening as they should, and sometimes when they went to sync data, it would take a huge amount of time (which was not supposed to be normal behavior). In short, the system proved to be problematic and, at times, unusable. But the problem didn’t have anything to do with the Method Integration system, nor the technology.

The problem was that all workstations in the office were set up to sync data between QuickBooks and Method. QuickBooks was installed on all the PC’s, even though most of the users did not use QuickBooks (they used the Method Integration system to do their jobs), and each PC had the Method Integration sync engine installed and set up to run. This caused the system to be frequently overloaded with sync requests and caused QuickBooks to behave erratically or crash. In addition, users who did not need (and should not have had) access to QuickBooks financial information were starting up QuickBooks and opening the company file every day because they thought it was required to allow them to access or use QuickBooks data in the Method Integration system.

The benefits of using web applications which can connect to and integrate data with QuickBooks is that a business can give users functionality and data access required to get the job done, but not expose those users to more software or data than they need. In most cases, if not all, QuickBooks is not necessary for users of the web application (saving you the cost of purchasing and installing QuickBooks for these users). Further, to ensure proper functionality and to remove any possible conflict or confusion in the sync process, only one workstation with QuickBooks should be set up to sync data to/from the web solution. While it makes sense to have a “backup” PC setup with the ability, syncing should remain inactive on this machine unless the primary “sync machine” is out of service. The key element to remember here is that the data coming from the web application is being added to the QuickBooks company file. Once the data is in QuickBooks, QuickBooks users may access the data from QuickBooks and do not need the connection to the web application.

When deploying this combination of solutions with a hosting service provider, the same rules will apply. Only users who need the sync capability require service with both QuickBooks and the integration installed. In some cases, this may make selection of host services more affordable, as only those who need the “additional application” (being the sync solution or integration tool) require customized service, and the rest of the QuickBooks-only users need standard QuickBooks service. *It might also be worth noting that many hosting providers do not support “persistent” connections – sync connections which continue to run even when you are not logged in), so syncing of data would only be able to occur if the primary user was logged in to QuickBooks and had the sync integration active on the host solution.

Accounting professionals, QuickBooks ProAdvisors, and small business consultants can help their clients understand the value and potential of extending QuickBooks desktop editions with connected web-based solutions. The additional value these professionals bring to the conversation is the understanding of the need for structure and control of the data flowing into and out of the financial systems, offering their expertise to ensure that the accountability and appropriate treatment of the information exists throughout the business.

Make Sense?