Display SQL Data on a SharePoint site

Had this question today from my good friend Cedric. He needed a way to display non-SharePoint SQL data on a SharePoint site. Well, looking around on the net I found these options:


A. You can off course use the built-in Business Data catalog for this, which may be a little bit of overkill if all you want to do is display a simple table.

 

B. You can buy a SQL Data Viewer Web Part:

Bamboo solutions has one: http://store.bamboosolutions.com/pc-71-1-data-viewer-web-part.aspx  (500$ / server licence)

 

Lightning Tools has one: http://www.lightningtools.com/pages/lt%20data%20viewer%20web%20part.aspx (400$ / web frontend server)

 

C. You can or develop you own data viewer web part using this post:


 

D. You can use the Data View Web part in SharePoint Designer:

This web part is configured with SharePoint Designer. It can use a wide range of data sources including XML files, web services, SQL and Oracle databases and SharePoint list/library content. The rendering is XSLT driven with SharePoint Designer providing a drag-and-drop interface to generate the XSL.

 

 

Visio Stencils for SharePoint 2007 Site Structures documentation (by Maxime Bombardier and Mart Muller)

Please have a look at Maxime Bombardier’s Blog  on MSDN Blogs for his article on Visio Stencils for SharePoint 2007. You can download them directly from his blog and is a great addition if you are busy documenting SharePoint sites and structures. His stencil is for SharePoint objects such as sites, document libraries, site collections, surveys, etc. Maxime also has a link in his article for a stencil that with SharePoint Servers for documenting SharePoint architectures. This stencil can be found on the Blog of Mart Muller here


For your convenience I have downloaded the files to my blogsite here:


MOSS_servers.zip


MOSS_Site_Structure_v0.2.zip


Of Course check the blogs of Maxime and Mart for updates [:D]

How to display Visio file in SharePoint web part by Elton

Just talked with my colleague Marijn Somers about viewing documents directly on SharePoint sites, when this came up. I remember having done this before for displaying infrastructure Visio drawings on the homesite of the Infrastructure Team SharePoint site using the trick below. I thought to put it on my blog as well (don’t know why I didn’t before, but….) 


So here it is. I found it in an article on Elton’s Ark MSDN blog


 


I have an idea recently that I want our project web site could display Office Visio file and Office Project .mpp file.


Visio attract me very much for its powerful diagram elements, it could centralize my thinking in a diagram and it is so easy understanding and abstractive in every phase of project life cycle.


For .mpp file I want to replace normal list web part with gantt diagram. Normally we maintain a task list in SharePoint account for the project schedule, but I’d rather to use project file to plan and monitor the project status, because task list is not straitforward for task dependency and task hierarchy, but gantt diagram is a good choice to me.


I found a method to display visio file in SharePoint web part and I don’t know if it is the only solution or not now.


Visio 2003 Viwer active-x control must be installed in client machine even if it has office 2003 installed, before client user browse the sharepoint web page containing visio web part (I don’t like this, but in vain). This active-x control is an add-in of IE to display visio diagram. It could be found at http://www.microsoft.com/downloads/details.aspx?FamilyId=3FB3BD5C-FED1-46CF-BD53-DA23635AB2DF&displaylang=en.


In SharePoint you could drag & drop a Content Editor web part onto a web part page, then click “Source Editor” button to imput following:


<OBJECT classid=”CLSID:279D6C9A-652E-4833-BEFC-312CA8887857″
codebase=”http://download.microsoft.com/download/4/5/2/452f8090-413f-408f-83c0-edd66db786ee/vviewer.exe”
id=”viewer1″ width=”100%” height=”100″>
<param name=”BackColor” value=”16777120″>
<param name=”AlertsEnabled” value=”1″>
<param name=”ContextMenuEnabled” value=”1″>
<param name=”GridVisible” value=”0″>
<param name=”HighQualityRender” value=”1″>
<param name=”PageColor” value=”16777215″>
<param name=”PageVisible” value=”1″>
<param name=”PropertyDialogEnabled” value=”1″>
<param name=”ScrollbarsVisible” value=”1″>
<param name=”ToolbarVisible” value=”1″>
<param name=”SRC” value=http://wssxxxx/Shared%20Documents/Yukon%20Timeline.vsd>
<param name=”CurrentPageIndex” value=”0″>
<param name=”Zoom” value=”-1″>
</object>


Red color string indicates the visio file’s location in SharePoint. Other parameters could be set according to its effect in IE visio viewer.


The result doesn’t meet my idea completely, anyway it is a solution for displaying the visio file in SharePoint.


Useful link: http://www.wssdemo.com/Pages/visio.aspx?menu=Articles.

Save Adobe Acrobat documents to SharePoint using Save As… directly in Adobe

Ever wanted to save your documents directly into a SharePoint document library as you would for saving the document to a local folder or network share from within your Acrobat software? Well apparently, when you try to save a newly created pdf file, you cannot browse to a SharePoint site.


The Adobe website does offer you a solution to do that exactly. They allow you to install a free DMS Integration Plug-in for Acrobat from Omtool, called the SwiftWriter Plugin for Adobe


This plugin will give you the following option in Acrobat:



I just went through the Adobe website for the new Adobe Acrobat 9 Family products and there is some mentionning of built-in SharePoint integration into the new versions. I downloaded a trial to check this out, but the new version still will not enable you to save directly to SharePoint without the plugin.


What it does allo you to do is use a SharePoint Workspace for reviewing comments:



Forms Based Authentication ( FBA) in WSS 3.0 / MOSS 2007 (by MeySun)

I had an issue this week that I was unable to sign in to my personal WSS site. for some reason the popup login screen never showed. I know that my company laptop is heavily secured as well as the network. So if it was a firewall blocking or my IE settings that did not allow the logon, I didn’t care. All I needed was being able to logon to my site.


This brought me to the idea of implementing FBA for my site. I didn’t want to manage users in a SQL database etc. I just needed FBA to authenticato to Active Directory. I stumbled upon a great blog post by meysun (aka Meyyappan Meenakshisundaram).


Here is what he wrote:


1. Configure SharePoint Central Admin 



  • Login to SharePoint Central Admin
  • Go to Application Management / Application Security / Authentication Providers and Change the Web Application to the one which needs to be configured for Forms Based Authentication
  • Click zone / default, change authentication type to forms and enter ActiveDirectoryMembershipProvider under membership provider name ( for example , “ADMembershipProvider”) and save this change

2.Update the web.config of SharePoint Central admin site
 


under <configuration> node


<connectionStrings>
<add name=”ADConnectionString” connectionString=”LDAP://DynamicsAX.local/CN=Users,DC=DynamicsAX,DC=local” />
</connectionStrings>


under <system.web> node


<membership defaultProvider=”ADMembershipProvider”>
<providers>
<add name=”ADMembershipProvider”
type=”System.Web.Security.ActiveDirectoryMembershipProvider,System.Web,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a” connectionStringName=”ADConnectionString”
connectionUsername=”xxx” connectionPassword=”yyy”
enableSearchMethods=”true”
attributeMapUsername=”sAMAccountName”/>
</providers>
</membership>


replace the connectionstring to the one matching your encvironment and replace”xxx” with domainname\username and “yyy” with password


 


3.Update the web.config of SharePoint Web application



  •  Repeat step 2 for the web.config of the SharePoint webapplication to be configured for Forms Based Authentication
  •  Change the authentication in web.config to
    <authentication mode=”Forms”>
        <forms loginUrl=”/_layouts/login.aspx”></forms>
    </authentication>

For more details
http://technet2.microsoft.com/Office/en-us/library/23b837d1-15d9-4621-aa0b-9ce3f1c7153e1033.mspx?mfr=true
http://msdn2.microsoft.com/en-us/library/ms998360.aspx


So, Thanks meysun for your post. It really helped me out !