Monday, June 21, 2010

Sync data using SSIS

If you aren't aware of the power of SharePoint custom lists yet, the topic is worth investigating. SharePoint custom lists combine the ease-of-use that has made Excel Spreadsheets and Access databases so successful among "knowledge workers" in many organizations with the benefits of traditional databases. They offer Access-like simplicity of both administration (creating and modifying lists) and data access, while overcoming one of Access' biggest challenges: decentralization.

In addition to centralizing data on a server, SharePoint lists benefit from other traditional database features such as referential integrity, indexes, and views. They also benefit from SharePoint-provided features such as native support for workflows and automatic versioning.

And if that isn't enough to convince you of the likelihood that you'll interact with them in the near future, consider how seriously Microsoft is pushing the technology by integrating SharePoint and Microsoft Office 2007. Even if you aren't using lists today, the chances are good you will be before long.

No comments:

Post a Comment

Flipkart.com

  Flipkart, founded by the Bansals in 2007 is now being headed by Kalyan Krishnamurthy since 2016. A Billion dollar firm with more than 70 m...