Archive for the ‘Data Integration’ Category

Cloud Computing Benefits for Accounting Firms

August 19th, 2012
Posted by: Julia Uglietta


By Julia Uglietta
Associate, Marketing and Sales

Accounting firms deal with data day in and day out. The volume of numbers that go through an accounting office each day is unimaginable. The number of emails that go in and out of the offices is inundating.

It’s not only the size issue that challenges accounting offices every day.  Rather, it’s also the need to work faster while remaining efficient – in addition to improving better client and interoffice communications. These goals sound fairly standard for a successful business, right?  But in fields such as accounting, where large amounts of data are being received and stored, achieving these goals can be onerous.  The good news is, however, that new technology known as cloud computing is helping accounting firms attain these goals and save money too.

AIS Network accounting

Taking business to the cloud allows accountants to work from anywhere, at any time.

Taking accounting firms to the cloud is a way to reduce costs, improve efficiency and make data more accessible.  Throughout the industry, the discussions about cloud computing and how many accounting practices are moving to an outsourced cloud computing model has people thinking.  Accountants can see clearly that cloud computing is moving up and moving fast.  Now, more firms are looking into cloud solutions before they buy that next new sever.  They’re performing a cost benefit analysis, and in the process, they’re discovering that the operational expenditure associated with implementing an outsourced model is more desirable than the large capital expenditure associated with buying and maintaining all those new servers.

Not only does migrating to a cloud-based, paperless environment cut costs for accounting firms, but it also introduces new efficiencies.  When you put your data and applications in the cloud and entrust a cloud provider to care for them round-the-clock, you’re achieving IT efficiencies such as:

  • Eliminating the need for physical storage (throw out those old filing cabinets!)
  • Upgrading to industrial strength physical security (including partial or full fault tolerance, fire protection, etc.)
  • Improving backup and disaster recovery processes
  • Enhancing data security
  • Increasing availability (through improved power redundancy,  etc.)
  • Extending IT resources with a 24x7x365 team of hosting experts

For many accounting firms, this makes the decision to switch to the cloud even easier.

The most brilliant feature of the cloud is, in my opinion, its “anywhere” accessibility – which is an aspect that most accounting firms will find appealing.  When your data and your applications are in the cloud, they are accessible via any Internet-enabled device whenever you need them and wherever you are.  It just makes life easier.  Allowing the staff to work faster (and, I might add, without necessarily increasing billable rates) allows them more time to focus on the clients’ needs.

Most customers prefer communicating with their accountant via the Internet, and in many ways, the new cloud-based dashboards, reporting applications and unified communications systems that are now available only make this easier.  By enabling better collaboration and communication among geographically diverse staff and clients, accounting firms’ processes and workflows are vastly improved and the work gets done much faster – often with greatly reduced travel costs.

Life in the cloud has changed many industries’ ways of operating.  Slowly but surely, accounting firms will ease into cloud computing and reap benefits that were previously unachievable any other way.

 

 

TAGS:

CATEGORIES:

Examining SharePoint Data Integration

August 18th, 2011
Posted by: admin

By Terry Engelstad
MCP, MCSE, CCNA, MCDBA, MCTS, MCITP
AIS Network Operations Manager

This week, we were contacted by a vendor for a new software product that claims to connect almost any on-premise data source (e.g., databases, ERP/CRM) to Microsoft SharePoint 2010 and Microsoft Office 365.

I’m not sure of the value of this to a SharePoint hosting provider per se.  I’ll need to digest some different scenarios in order to understand how AISN would use this, but it gave me the idea for this blog.  Here’s a little background about data integration with Microsoft Office 365 (SharePoint), and probably, why this type of product evolved.

SharePoint MOSS 2007 introduced a new service called Business Connectivity Service (BCS). It allowed users to access external data in a variety of forms (databases, spreadsheets, files, etc.) from inside SharePoint. SharePoint 2010 renamed it “Business Data Connectivity” (BDC) and embellished the feature-set, including the ability to Search the external data. BCS and BDC do not copy data into SharePoint. They set up virtual connections to the data and allow other components within SharePoint to see and touch the data. At no point is data copied into SharePoint. Connections to external data are not persistent. This means they will exist for as long as necessary, then dissolve, then re-connect as necessary. This is not too efficient for large volumes of data.

When a connection is set up to an external source, there is a requirement to provide credentials in order to access the external data. SharePoint allows only three ways to provide credentials:

1) the Windows account of the logged on user running the SharePoint BCS/BDC process,

2) the operating system account of the service running the BCS/BDC process, or

3) a customized set of credentials.

MOSS only allows types 1 or 2.  On the other hand, SharePoint Foundation 2010 only allows types 1 or 2, and SharePoint Server 2010 allows all three types but needs to retain credentials for type 3 in a service called Secure Store. This service is available only in SharePoint Server – not MOSS and not Foundation.

Office 365 is built on the foundation of SharePoint Foundation (and so is our Shared SharePoint environment). Microsoft has stated that Office 365 does not allow accessing external data through BDC. I haven’t seen a document stating the reasons for this, but I can draw conclusions from the statements above.

First, since data is not actually copied into Office 365 SharePoint, there is no consumption of space, only consumption of network bandwidth and CPU. Since the pricing model for Office 365 is built around space consumption, Microsoft would not make any money if clients used, for example, only external data. Picture a SharePoint environment where there is no data stored locally, only accessed through BCS/BDC. Not too profitable.

Second, Office 365 does not allow access to external data because of credentials. In Office 365, Windows accounts and Operating System service accounts will have no meaning outside of Office 365. Therefore, a user could not authenticate with those credentials to any data source outside of Office 365. And again, since Office365 does not use the Secure Store feature found in Server, special/unique credentials cannot be stored.

So, long story short, there is still a need to get data into Office 365. The method proposed by this new software is to copy data from external data sources into SharePoint Lists. This is an OK way of getting data into SharePoint. I’m just not sure how many people would want to take advantage of it. We’ve had only one client in our Shared environment ask about BDC capabilities, and my research/response to that client has led to the above discovery. We do have one MOSS client using BCS to access several spreadsheets which they periodically refresh on their dedicated server.  None of our dedicated SharePoint 2010 clients are currently using BDC.

I’d be interested in any comments that readers of this blog may have.  What are your thoughts?

TAGS:

CATEGORIES: