locked
Sharepoint 2007 and Data Manipulation RRS feed

  • Question

  • I am just getting into Sharepoint Designer, trying to learn what it can do and how I can utilize Sharepoint for my company.

    My question is:  Is Sharepoint able to import data, manipulate it (data compare) and spit out an answer?  I've been messing around with Dataview trying to understand its capabilities, but was hoping it could import data from an .xml file and sort/compare it based on predefined constraints.

    Ultimately, I am trying to see if I can move information from an Access database into Sharepoint and have Sharepoint do the data manipulation that Access is doing now.

    Thanks

    Wednesday, August 24, 2011 11:06 AM

Answers

  • There are a few options here, so I'd expect different answers from those that have experience in each field.  I'll try and offer generally.  I'm taking these off the top of my head, so I'll correct this post if I'm wrong.

    • You can use BDC to import data from data sources, includiing XML files (I believe), but it's a read only operations
    • You can add data sources to some manipulations (such as data grid) and use thier values bypassing BDC.
    • You can also use web services
    • In regards to Access, you can publish Access data to SharePoint lists, but I don't think it retains its full functionality

    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/

    Wednesday, August 24, 2011 11:36 AM
    Answerer
  • Ok, I generally tend to think most things posted in the forums will motivate the OP to Google some leads but in this instance, a brief overview of BDC: -

    BDC is the abbreviation for Business Data Catalog (always prefered Connectivity myself) and in essence provides a way tpo integrate back end data into SharePoint.  There are further BDC web parts that'll allow you to present and manipulate the information pulled in.  The SharePoint 2007 specific version is a read only implementation.  You write an XML file that is known as an application file, which will, upon upload, allow SharePoint to intepret the data from the back end source.  A good introductory article is here: -

    http://msdn.microsoft.com/en-us/library/ms563661(v=office.12).aspx

    A tool that I've found useful when working with this offered by a firm called LightningTools and is known as BDC MetaMan.  Please note that I'm NOT affiliated with the firm or the guys that run it.  Check this link for more information.  The White Paper is also quite good.


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/

    Wednesday, August 24, 2011 12:14 PM
    Answerer

All replies

  • There are a few options here, so I'd expect different answers from those that have experience in each field.  I'll try and offer generally.  I'm taking these off the top of my head, so I'll correct this post if I'm wrong.

    • You can use BDC to import data from data sources, includiing XML files (I believe), but it's a read only operations
    • You can add data sources to some manipulations (such as data grid) and use thier values bypassing BDC.
    • You can also use web services
    • In regards to Access, you can publish Access data to SharePoint lists, but I don't think it retains its full functionality

    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/

    Wednesday, August 24, 2011 11:36 AM
    Answerer
  • BCS is SP 2010 only - do you mean BDC ?


      BCS and BDC, I have no idea what you are talking about.  


    • Edited by Mike Walsh FIN Wednesday, August 24, 2011 12:04 PM Please don't use full-quote. It wastes screen space for nothing.
    Wednesday, August 24, 2011 11:48 AM
  • Ok, I generally tend to think most things posted in the forums will motivate the OP to Google some leads but in this instance, a brief overview of BDC: -

    BDC is the abbreviation for Business Data Catalog (always prefered Connectivity myself) and in essence provides a way tpo integrate back end data into SharePoint.  There are further BDC web parts that'll allow you to present and manipulate the information pulled in.  The SharePoint 2007 specific version is a read only implementation.  You write an XML file that is known as an application file, which will, upon upload, allow SharePoint to intepret the data from the back end source.  A good introductory article is here: -

    http://msdn.microsoft.com/en-us/library/ms563661(v=office.12).aspx

    A tool that I've found useful when working with this offered by a firm called LightningTools and is known as BDC MetaMan.  Please note that I'm NOT affiliated with the firm or the guys that run it.  Check this link for more information.  The White Paper is also quite good.


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/

    Wednesday, August 24, 2011 12:14 PM
    Answerer
  • Thanks Steven for the explanation
    Wednesday, August 24, 2011 12:16 PM