MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Sharepoint 2007 db design

  Asked By: Elton    Date: Jun 09    Category: MOSS    Views: 815

if i have many list defintions created in sharepoint to mapout a business
datbase model, will that cause problems later when other apps (custom,
accounting, sql reporting services, etc..) need to access this data. there is no
clean db model right, so are we going to have problems down the road if all our
"important" data is stored in sharepoint db?

any info?



4 Answers Found

Answer #1    Answered By: Ian Davis     Answered On: Jun 09

There are many ways to integrate with SharePoint from either home
grown or 3rd party products. From SharePoint's perspective, you can
use SharePoint Object Model, ie SharePoint API to do integration, or
you can use SharePoint web services to do the integration. There are
many ways available at your disposal.

Answer #2    Answered By: Jagjit Hui     Answered On: Jun 09

thanks, but what about using sql reporting services also? must we first export
the data out of sharepoint  into a relationaldb to utilize the full potential of
sql reporting services?

Answer #3    Answered By: Joanne Greer     Answered On: Jun 09

I know you can integrate sql reporting services with SharePoint which
I have done in my test env.

Also you can dashboarding based on SharePoint lists, Back to your
question, I don't have much knowledge about sql reporting services so
I don't have a definitive answer.

Answer #4    Answered By: Cathy Cameron     Answered On: Jun 09

I, too, have installed SQL Reporting Service in my test MOSS servers.
You can create reports using ReportBuilder with SharePoint. You need to run SQL
integration mode (not SQL Native mode).

Didn't find what you were looking for? Find more on Sharepoint 2007 db design Or get search suggestion and latest updates.