MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Accessing Sharepoint Data From Other apps and vice versa

  Asked By: Carmen    Date: Nov 11    Category: MOSS    Views: 1485

Using Sharepoint 2007 Moss, if i have several data constructs created within
sharepoint that all represent business entities/domains of the company
(customer/product/line item details/invoices/etc..). When we then want to do
things like run sql reporting services against this data, or possibly expose via
webservices or wcf enabled objects so that we can us this data from other
applications outside of sharepoint, or just hit this data directly for read
access, is this going to be a problem? I know that there is the sp-api, is that
what we need to use, and if so how will sql reporting fit into that if we want
to create reports, metrics/kpis against the data in sharepoint?Lastly, if we
have other appplications that will have sepreate data in its own db, and then
want sp to use that data to create lists, link to, etc... will that be a
problem? or do we need to import that data into the sp db and have a 2 way
repliation process running, or use the BDC, and if the BDC can you have hard
relations between a local sp entity using a "fk" to the record in the external
db?thanks, and i am new to this list and only have a good conceptual
understanding of sharepoint so any feedback is appreciated.



1 Answer Found

Answer #1    Answered By: Marshall Castro     Answered On: Nov 11

In order to access SharePoint lists data  from Reporting Services, you may want to have a look at our product "Enesys RS Data Extension": http://www.enesyssoftware.com.

Didn't find what you were looking for? Find more on Accessing Sharepoint Data From Other apps and vice versa Or get search suggestion and latest updates.