Stump the Panel » SharePoint Workflow for All Users

WSS 3.0 & SQL Database

(7 posts)
  • Started 5 days ago by erugalatha
  • Latest reply from Greg.Osimowicz

  1. erugalatha
    Member

    Hi,

    In MOSS Enterprise we have BDC to allow us to look out to external datasources from lists.

    Is there anything available for WSS 3.0 to allow me to expose data from a SQL Database in a SharePoint List?

    Posted 5 days ago #

  2. Eric Truchon
    Moderator

    Hi,

    You can use PowerShell to fill your WSS List, but you will need to develop some scripts and create a Windows task calling your scripts every x times.

    SQL retrieve data exemple : http://www.leeholmes.com/blog/InteractingWithSQLDatabasesInPowerShellInvokeSqlCommand.aspx

    WSS Add item to a list :
    http://blogs.flexnetconsult.co.uk/colinbyrne/2008/02/26/PowerShellSharePointAddAListItem.aspx

    Eric

    Posted 5 days ago #

  3. pagalvin
    Moderator

    You should also be able to use data view web part for this.

    This article seems to show a good approach (you have to slog through a lot in the front to get to the good part).

    Posted 5 days ago #

  4. erugalatha
    Member

    Hi Paul,

    Did you mean to post a link there?

    Posted 4 days ago #

  5. pagalvin
    Moderator

    Darn, I did. I can't find the link now... sorry!

    Posted 4 days ago #

  6. erugalatha
    Member

    aww ... you get my hopes up and dash them in one-fell-swoop. :P

    Posted 3 days ago #

  7. Greg.Osimowicz
    Moderator

    Sharepoint designer allows you to connect to SQL or other OLE DB-compliant data sources. The MS article Add a database as a data source article (http://office.microsoft.com/en-us/sharepointdesigner/HA101009081033.aspx) should point you in the right direction. Build a datasource, use it with data view web part and you should be good to go.

    Regards,
    Greg Osimowicz
    http://Sharepointapplied.com

    Posted 3 days ago #

RSS feed for this topic

Reply

You must log in to post.