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.