SharePoint challenges IT as the Excel, Access of the day

Computerworld - Just as the use 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 Inc.

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," he said.

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 that group nor the company's 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 life-cycle management (ALM) features in SharePoint are incomplete. It does not provide source control and other ALM tools, and its content database is 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.