Provide Read and Write access to your Line of Business Applications through SharePoint with BCS (Business Connectivity Services)

What do you think of when you hear the word SharePoint? Usually the answer to this question is: Collaboration. Which is correct! However, SharePoint is so much more than a group/team of people collaborating on their intranet. Today, I want to take a few minutes to describe how an organization can expose their line of business application data in SharePoint.

Here's a common scenario:
A business currently has a home-grown system that they use. The interface has gotten outdated, but the information interfaced is still valuable to the organization and its employees. All the data is stored in databases (either SQL, Oracle, DB2 etc.). The question now is whether to build another home grown system from scratch?

A possible solution:
Use SharePoint as it was meant to be used – serving as the main presentation layer that interfaces data from various sources in the organization. All you need is SharePoint Server 2010 and SharePoint Designer 2010 and you're ready to define your data sources using a functionality called Business Connectivity Services (BCS) – no programming required!

I have to tell you that one of the most frustrating things to office workers is having to remember which application to use for which purpose. It doesn't have to be that way. If you have invested in SharePoint already (or planning to), make that a one stop shop for your end users by presenting and interfacing all line of business application data (such as SAP, Siebel, custom databases). It's all possible with the power of BCS.