Lightning Tools Data Viewer Web Part

230998 Resource 214788 216331 216331 1240339663268 1240339663268 Controlled Surfacing Data in Microsoft SharePoint | Tools for Integration

Tools for a Dynamic Data Driven SharePoint Site

Here are a couple tools that I have had the chance to play with and have found to be useful for surfacing external data into SharePoint. The first tool I want to mention is the Data Viewer Web Part from Lightning Tools.  If there was such a thing as a "magic bullet" for delivering line of business data from a given database to a SharePoint page, this web part is that magic bullet.  What makes this tool so powerful is that it can be implemented without creating a business data catalog, and it does not require the "developer" to use SharePoint Designer or Visual Studio for implementation.  The web part can be configured through the SharePoint web interface.  There are a great deal of different features, you can read about them on the Lightning Tools website - link is provided below. As good as the Lightning Tools Data Viewer Web Part is, there are some things it does not do.  For example not all data bases are supported, and my experience is that connecting several different datasources (an oracle and mssql) into a single table can be difficult.  For these more complex problems you'll need to develop a business data catalog.  This can be very complex if you choose to manually edit XML files, and this is where BDC MetaMan (also produced by Lighting Tools) comes in.  This application takes the brain damage out of implementing a business data catalog in your SharePoint environment. iTechnology Design offers SharePoint development and implementation services on hourly, contract, and project basis.  We can assist you in developing a comprehensive SharePoint application. 9 application/xml false BDC BDC meta man business data catalog data data viewer web part development sharepoint sharepoint installation sharepoint programming surfacing Lightning Tools Data Viewer Web Part Fast and simple surfacing of external data. http://www.lightningtools.com/pages/lt%20data%20viewer%20web%20part.aspx BDC MetaMan Takes the brain damage out of the business data catalog. http://www.lightningtools.com/bdc-meta-man/default.aspx?gclid=CMKkodvPgpoCFRAMDQodvDpXFA Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.0.8) Gecko/2009032608 Firefox/3.0.8 127.0.0.1 127.0.0.1 itechnologydesign 64.91.4.74 false true false false true 214788 blog blogsite/ITechnologyDesign/web