Can you link SQL 2005 DB to query Sharepoint?

20 Dec 2006 7:44 AM

Jason

looking for a solution to be able to query a sharepoint DB from a SQL 2005
Database very much like the access Linked Table but using SQL 2005.

I've been asked to develop a web application with a SQL back end and to join
the Application SQL DB with a SharePoint List. I can certainly do this in
Access but need a more robust solution. Is it possible? now or in the future?
Plans to add??

Thanks
Jason

20 Dec 2006 9:35 AM

Wei Lu [MSFT]

Hello Jason,

I would like to know more detailed information.

1. Why you wants to query the sharepoint database in SQL 2005? Since the
sharepoint database is a sql server database, you could query the
information but will not friendly interface.

2. In Access 2007, you could access the lists in the sharepoint and have
the linked table in it.

3. And I would like to suggest you to use the CLR stored procedure in the
SQL Server 2005 to access the sharepoint list information.

Here are some information for you:

Getting Started with CLR Integration
http://msdn2.microsoft.com/en-us/library/ms131052.aspx

Sincerely,

Wei Lu

Microsoft Online Community Support

==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

20 Dec 2006 3:16 PM

Jason

Wei Lu,

Thanks for your quick response.

1. You wanted more info, I understand how to create a linked server but what
I was looking for is access to Sharepoint lists so I can write regular SQL
queries against these lists to validate data and build lookup tables via a
SQL server connected with a web application I am building. This will make the
connection to sharepoint invisible to the application runing.
2. I'm looking for the type of access Access 2003/2007 has (Linked Tables)
using SQL Server.

I will look into CLR Stored Procedures. Is there any sample code to query
Sharepoint Lists with CLR??

Thanks, if nothing else I have some pointers.. :)

Jason

Show quoteHide quote

"Wei Lu [MSFT]" wrote:

> Hello Jason,
>
> I would like to know more detailed information.
>
> 1. Why you wants to query the sharepoint database in SQL 2005? Since the
> sharepoint database is a sql server database, you could query the
> information but will not friendly interface.
>
> 2. In Access 2007, you could access the lists in the sharepoint and have
> the linked table in it.
>
> 3. And I would like to suggest you to use the CLR stored procedure in the
> SQL Server 2005 to access the sharepoint list information.
>
> Here are some information for you:
>
> Getting Started with CLR Integration
> http://msdn2.microsoft.com/en-us/library/ms131052.aspx
>
> Sincerely,
>
> Wei Lu
>
> Microsoft Online Community Support
>
> ==================================================
>
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
>
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
>
> ==================================================
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
>

22 Dec 2006 5:35 AM

Wei Lu [MSFT]

Hello Jason,

Actually, you could use the the Sharepoint Object Model to access the
Sharepoint List in the .NET code.

Here is the article for you:

Programming in Windows SharePoint Services
http://msdn2.microsoft.com/en-us/library/ms430674.aspx

Hope this will be helpful.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

22 Dec 2006 5:01 PM

Jason

Many Thanks Wei Lu...

Not exactly what I was looking for but this will allow me to get the
information I need from the Sharepoint Site..

Thanks Again!! Happy Holidays!!!
Jason

Show quoteHide quote

"Wei Lu [MSFT]" wrote:

> Hello Jason,
>
> Actually, you could use the the Sharepoint Object Model to access the
> Sharepoint List in the .NET code.
>
> Here is the article for you:
>
> Programming in Windows SharePoint Services
> http://msdn2.microsoft.com/en-us/library/ms430674.aspx
>
> Hope this will be helpful.
>
> Sincerely,
>
> Wei Lu
> Microsoft Online Community Support
>
> ==================================================
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>

20 Dec 2006 9:38 AM

Tibor Karaszi

Since sharepoint (as I understand) store its data in SQL server, you can create a linked server to
the sharepoint server/database. Read about "linked servers" in Books Online. You then refer to the
sharepoint table/view/procedure using 4-part naming:

SELECT ...
FROM servername.dbname.shema.tblname

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quoteHide quote

"Jason" <JRawlins@noemail.nospam> wrote in message
news:A15F1507-381A-450B-89D5-F21DE7A083CE@microsoft.com...
> looking for a solution to be able to query a sharepoint DB from a SQL 2005
> Database very much like the access Linked Table but using SQL 2005.
>
> I've been asked to develop a web application with a SQL back end and to join
> the Application SQL DB with a SharePoint List. I can certainly do this in
> Access but need a more robust solution. Is it possible? now or in the future?
> Plans to add??
>
> Thanks
> Jason
>

Thread options