SharePoint challenges IT as the Excel, Access of the day

Forrester says IT developers must prepare to support SharePoint apps built secretly by users

Just as the use of Microsoft Excel and Access grew at unfettered rates in the 1990s - often under IT's radar - the vendor's Office SharePoint Server is spreading quickly through large companies as a development platform for users, according to a new study from Forrester Research.

As the Web sites, workflows, electronic forms and dashboards built using SharePoint tools mature, users are turning to surprised IT operations for support, said Forrester analyst John Rymer, who wrote the report. Oftentimes, the requests for support are the first time IT officials learn of the applications, he said.

"This research resulted from inquiries from clients - expressions of pain and concern," he noted. "We started to get questions late last year from application development groups suddenly being asked to support this new platform - SharePoint. They were being asked to provide custom applications [and] to support applications that were built by power users."

The report compares the spread of SharePoint to that of the Access and Lotus Notes databases in the 1990s. Departmental users used those tools to build applications that collect and manage data because they couldn't quickly get the projects onto IT's development schedule.

And SharePoint ups the application development ante by allowing users to add workflows to business processes and build their own collaboration sites, Rymer noted. "It's the same idea that drove the Access and Excel phenomenon but users have more rope to hang themselves with."

For example, one large industrial conglomerate, which Forrester did not name, has for the past three years provided a Windows SharePoint Services site all of its 140,000 employees. Some employees have administrative privileges, allowing them to customize Web sites, while others developed applications using SharePoint Services. The result: employees created thousands of SharePoint sites, making useful information hard to find, the report said.

At another company, a single user at an unnamed large financial services company built several popular custom applications using SharePoint and assumed that the application development group would support them. However, that support required specialized skills that neither the company's application development group nor its operations group had, the report added.

The problems can be exacerbated by multiple major gaps in SharePoint's application development capabilities, the report said. First and foremost, the Application Lifecycle Management (ALM) features in SharePoint are incomplete. It does not provide source control and other ALM tools, and its content database not compatible with popular source management products, Forrester said. Users interviewed for the report noted that all they can do to tackle the lack of ALM in SharePoint is create custom policies and approaches to ALM using Visual Studio extension for SharePoint or third party approaches.

"To really embrace this as a platform, [development groups] are going to have to cobble together something on their own," Rymer said. "The nature of the beast is that SharePoint allows for pretty rapid changes to applications. That really puts a lot of pressure on ALM to maintain control. Don't underestimate that."

Join the newsletter!

Error: Please check your email address.

More about ExcelForrester ResearchMicrosoft

Show Comments
[]