Skip to main content
Meritide Logo

  more.blog

more.meritide
more.blog
more.feeds
more.partners
more.jobs
  

more.meritide.com > more.blog
Blogging from Meritide Consultants.
SharePoint Integration to Proprietary Systems

Meritide presented the value of SharePoint integration to proprietary help desk systems at the last itSMF Minnesota conference.

Neil Otto – Solution Manager
neil.otto@meritide.com

Meritide has been delivering SharePoint integrations to proprietary help desk systems and this delivery provides a good case study for SharePoint integrations with any backend system.

By integrating applications into the SharePoint interface an organization benefits by reduced training costs and increased usage because SharePoint can present various application functionality in a consistent interface that leverages a users comfort with other Microsoft products.

Additionally, users can access information and functionality more conveniently than logging into several other applications so they are more likely to use the information or functionality and use it when they should.  This reduces latency in business process and can also reduce the amount of email or phone calls used to circumvent the use of an application to support the business functionality. 

Users are kept up to date.  Users can execute what they need to easily.  Users can be more efficient.

Please feel free to review the presentation that was used to present this to the itSMF.  You can download the PDF here.  If you have any questions or would like to discuss how you can do the same type of integration with any of your applications, send me an email at neil.otto@meritide.com.

About Neil Otto -- As the Meritide Solution Manager and CTO, Neil Otto provides strategy and guidance to the Meritide organization and its clients.  His area of expertise and experience relates to applying software and technology to address and solve business issues and create new business opportunities.  He has worked within Meritide's Web Enablement, Open Source, and Microsoft Stack practices and provides senior business and technology architecture consulting for our clients.

Crystal Killer – A look at Microsoft Report Builder 2.0

Microsoft’s Reporting Services 2008 combined with Report Builder 2.0 promises to put comprehensive ad-hoc reporting capabilities into the hands of end users in an easy to use tool that leverages users familiarity with Microsoft Office Suite products.

Neil Otto – Solution Manager
neil.otto@meritide.com

If your organization has introduced SQL Server 2008 through upgrades of existing products or databases or with the introduction of new products, the latest Reporting Services products from Microsoft are supported in your environment.  Report Builder 2.0 is part of that offering.

When combined with an implementation of Reporting Services, Report Builder 2.0 puts the following capabilities in the hands of end users.

  • Ad-Hoc reporting against defined report models, SQL Server, ODBC, XML, Oracle, or Hyperion.
  • Combine multiple tables, charts, images, text, and gauges in a single report.
  • Download the completed report as a PDF, Excel, Image, or HTML page.
  • Publish completed reports to a report server for others to use.
  • Embed sub reports and related reports with the same parent report.

They say that a picture is worth a thousand words so here are a few to peak your interest.

Report Builder 2.0 uses the familiar ribbon interface and allows uses to add and format text, graphics, and layout elements to their report.

image

image 

Users can select from built in fields and available data sources.

image

Uses can add visuals from a number of gauge and chart options.

image image

Generated reports can be viewed, saved, or printed from within the tool or through the web interface of Reporting Services

image

Report Builder 2.0 can be downloaded from here.

You can read more about Reporting Services 2008 and Report Builder here.

About Neil Otto -- As the Meritide Solution Manager and CTO, Neil Otto provides strategy and guidance to the Meritide organization and its clients.  His area of expertise and experience relates to applying software and technology to address and solve business issues and create new business opportunities.  He has worked within Meritide's Web Enablement, Open Source, and Microsoft Stack practices and provides senior business and technology architecture consulting for our clients.

Good Enough For Government Work

Cloud application providers are tailoring their offerings to meet the needs of government and private sector compliance, privacy, and security requirements. This article is a quick look at the current state on the heels of Microsoft’s announcement of their Business Productivity Online Suite for Federal agencies and contractors.

Neil Otto – Solution Manager
neil.otto@meritide.com

Microsoft has released details about the new features and improvements of their Business Productivity Online Suite (BPOS) for federal agencies. 

Some highlights include:

  • Harder encryption of data
  • Multi-faceted authentication
  • Trusted Internet Connection compliance
  • FISMA and ITAR compliance

For BPOS-Federal, all customer data will be stored within the United States in dedicated infrastructure which is logically and physically separated from the commercial Dedicated offering and which is secured via a set of security controls including cameras and biometric devices.

Additional security features of the BPOS offering can be found here.

Google Apps also has specific government offerings that address FISMA.  Google specifically targets the government sector with its offerings and is working on a Government Cloud for 2010.

Today, we're excited to announce our intent to create a government cloud, which we expect to become operational in 2010. Offering the same services and features as our existing commercial cloud (such as Google Apps), this dedicated environment within existing Google facilities in the US will serve the unique needs of US federal, state, and local governments. It is similar to a "Community Cloud" as defined by the National Institute for Science and Technology. The government cloud will allow Google to manage and meet additional government policy requirements beyond FISMA.

Salesforce.com offers public sector applications and offerings through its development partners and core products.

The General Services Administration (GSA) has a dedicated site for government agencies to obtain cloud based computing applications and services.  Apps.gov provided by the GSA as a way for agencies to purchase these cloud applications and a coordination point for vendors to offer their services.    Microsoft, Google, and Salesforce.com provide offerings through this service.

From the FAQ:

What is the Federal Cloud Computing Initiative?

Cloud computing plays a key role in the President's initiative to modernize Information Technology (IT) by identifying enterprise-wide common services and solutions and adopting a new cloud-computing business model. The Federal CIO Council under the guidance of the Office of Management and Budget (OMB) and the Federal Chief Information Officer (CIO), Vivek Kundra, established the Cloud Computing Initiative to fulfill the President's objectives for cloud computing.

The willingness of government agencies to use cloud based applications, processing power, and data storage will only advance the security and compliance of these applications and should remove obstacles and hesitations from the private sector related to compliance and security of cloud hosted data.

About Neil Otto -- As the Meritide Solution Manager and CTO, Neil Otto provides strategy and guidance to the Meritide organization and its clients.  His area of expertise and experience relates to applying software and technology to address and solve business issues and create new business opportunities.  He has worked within Meritide's Web Enablement, Open Source, and Microsoft Stack practices and provides senior business and technology architecture consulting for our clients.

Why Windows 7?

Windows 7 upgrades can extend the life of your current hardware and increase user satisfaction while reducing maintenance time and cost.

Neil Otto – Solution Manager
neil.otto@meritide.com

There are lots of features being discussed related to Windows 7 (especially in the commercials) but how can Windows 7 help your business and provide an identifiable return on investment for an upgrade?

Over the past several months we have done some informal testing and the results have led us to choose to upgrade to Windows 7.  This wasn’t the result of any newly introduced feature but was the result of the overall experience with upgrade and what it means for our hardware investment.

We believe the upgrade will allow us to get another 8 months to a year out of hardware that we were set to replace and may even let us bring some older mothballed hardware off the shelf for a new life.

What We Did

I wanted to try out Windows 7 first hand so I asked our keeper of all that is IT to provide me with a laptop that had been decommissioned and that we would not be planning to redeploy.  I installed Windows 7 on this laptop and was immediately impressed with how this older hardware acted with the new Operating System (OS).  Like many companies, we had never made the full jump to Windows Vista.  Windows 7 OS was clearly faster and more fluid than Windows XP on the same machine.  The laptop that was written off is now is now a performer that will be redeployed when needed.

Based on this experience and the experience of a few other early adopters in our organization who had switched, we have decided that getting Windows 7 on all of our computers will dramatically improve their user experience and reduce the number of issues and complaints we get. 

Additional Measures

A few additional things we will be doing to revamp our hardware/software to extend the lifetime of our current machines includes:

Our Hope

It is our hope that this combination of software upgrades, moving internal systems and client software to the cloud, increasing access to our systems for users outside the office, and the use of integrated Windows 7 and Microsoft tools will give our users a new computing experience without a new computer.

By putting off new hardware purchases just to replace existing ones, (because we’re able to extend the useful life) our budget will go further to provide new services to our users and customers.

A Few More Things

  1. If you are a Tablet PC user (like me), move now to Windows 7 if you can.  The Tablet experience is much improved in Windows 7.
  2. You can download the Windows 7 for Business whitepaper for additional information on ROI and planning for a Windows 7 upgrade.
  3. If you want to upgrade your home machine, here is a good reference that will walk you through the steps (this will not work with corporate Domain users).  You can get another year out of your home hardware too!

About Neil Otto -- As the Meritide Solution Manager and CTO, Neil Otto provides strategy and guidance to the Meritide organization and its clients.  His area of expertise and experience relates to applying software and technology to address and solve business issues and create new business opportunities.  He has worked within Meritide's Web Enablement, Open Source, and Microsoft Stack practices and provides senior business and technology architecture consulting for our clients.

Meritide is a Microsoft Gold Certified Partner and a BMC Premier Partner. 

Starting a Cloud Roadmap

Identifying the applications you use that may be suitable to move to the cloud.

Neil Otto – Solution Manager
neil.otto@meritide.com

The Promise of Cloud Applications

The promise of Cloud Computing, Software as a Service, and On Demand Services is that you can move your in house application platforms to an outside vendor or service and increase availability of the applications while at the same time reducing the total cost of ownership and maintenance of those applications.

This strategy can be applied to several of the standard systems an organization may use to manage their business and can eliminate the cost and concerns related to maintaining these systems through hardware and software upgrades.

Application Areas Ready for the Cloud

There are several application areas that you can target right now to lighten your internal software and hardware footprint and reduce maintenance cost.

Communications and Collaboration

Your email system may be one of the biggest consumer of maintenance time and hardware resources in your infrastructure.  Storage space, software and hardware upgrades, user issues, and remote access needs lead to a system that needs attention.  Although the email system is mission critical, the services it provides are typically not proprietary to any business and can be addressed with any one of the many cloud and on demand offerings (Exchange Online, Microsoft BPOS, Google GMail for Business).  By using pay as you go user based licensing, your costs are directly associated with the number of users and the amount of space you use.  Upgrades and provisioning are handled by the provider and a first line of disaster protection is provided.  Constant virus and SPAM protection at the server level are also part of the services. The system will also be available remotely without the need to configure firewalls, VPN, or mobile phone access.

You might also look at the way you are using your email system in your processes.  You can evaluate if there are more effective ways to communicate and collaborate, such as using SharePoint for business processing and notification.  You might look at replacing marketing email communications with your customers with more web based RSS feeds or blogs.  If you are using email as a way to deliver content and marketing information you might benefit from more automation instead of developing complete systems of communication and collaboration based on email sends and replies. 

Website, Intranet, and Extranets

If you are hosting your website, intranet, or a customer portal or extranet internally you can look at moving those out to the cloud and at the same time reduce bottlenecks associated with web publishing.  If your website is not currently using a Content Management System (CMS) you can use the opportunity to re-evaluate and get your website into a managed CMS that will give you more control over adding and editing content.  A few good options include DotNetNuke (DNN) which we have discussed in past blogs, which can be provided by hosting partners such as PowerDNN.  There are also systems such as SquareSpace that provide a hosted CMS that can be used to build websites. 

You can provide SharePoint based sales support or product support websites that include things like ticket tracking, document downloads, surveys, and event information using affordable hosting providers like Apps4Rent.  The SharePoint collaboration features and built in templates can let you build a subsite for your customers to interact with you on product information like forms, product documentation, and FAQs in a way that is intuitive and easy to support.

These providers and options might also be a good solution to start websites (separate from your corporate website) that are used to promote specific product lines (microsites) or for your social networking or web communications strategies like blogging.

If you want to provide your own employee collaboration capabilities through SharePoint without the cost and maintenance requirements of hosting your own, you can use hosting options like SharePoint Online or Microsoft BPOS.  

Customer Relationship Management

Customer Relationship Management (CRM) products are a big hit in the cloud application space.  Salesforce.com and Microsoft Dynamics CRM Online have allowed organizations to implement CRM based on a per user licensing model with no infrastructure investment.   The applications can be customized to suit your business and they avoid becoming monolithic customized on premise applications.  This eliminates many of the aspects of CRM implementations that lead to failures in CRM implementations of the past.  The cloud based applications also make information available to a mobile sales force through a web interface that is available from public internet access or through mobile clients and devices like IPhones.

Ready by 2011

Within a year there will be additional application areas that you can target to continue a cloud strategy.

IT and Desktop Maintenance and Help Desk

Both Microsoft and BMC Software are working on systems that will provide IT with the capability to delivery software patches, virus protection, and help desk support through cloud based systems.  These client management capabilities have the benefits of access from anywhere for clients and administrators and the lower cost of ownership through a client license model without the need for internal services and infrastructure. If you are looking to implement a more sophisticated help desk, client management process, or managed virus protection, these options should be considered before you look at on premise deployment and buildout.

Accounting and ERP

Accounting and ERP packages are moving to the cloud as well, following the success of the CRM on demand market.  Microsoft has offerings through its partners and venders like NetSuite provide hosted ERP applications.

 

What’s Left?

After the application areas already listed are addressed, what is left will be custom applications or legacy applications that you have built or modified to the point where they cannot be replaced with off the shelf packages available in the cloud.  You might also have business critical Access or Excel applications that fill in the gaps between your packaged applications.

For custom applications, you might consider hosting them or if you plan on replatforming or refactoring them, make sure you consider cloud base development platforms like Microsoft’s Azure, Amazon’s EC2, Google App Engine.

You can also look to reimagining these custom applications into SharePoint or xRM applications as we have discussed in two previous blogs - Is xRM Your Next Move from Access or Filemaker?  and Say Goodbye to some Old Friends.

 

About Neil Otto -- As the Meritide Solution Manager and CTO, Neil Otto provides strategy and guidance to the Meritide organization and its clients.  His area of expertise and experience relates to applying software and technology to address and solve business issues and create new business opportunities.  He has worked within Meritide's Web Enablement, Open Source, and Microsoft Stack practices and provides senior business and technology architecture consulting for our clients.

1 - 5 Next

 ‭(Hidden)‬ Admin Links