Accessing External Database From SharePoint 2007

Question

 

Hi!,

 

How can i access data from external database from example i would like to access data from [Northwind.Product] table and this data should be populated in list and the consistency of the data in this list should always be the latest as the end user are using 3rd party application to update/add new data in [Northwind.Product] table. Besides that this list would also be used in other forms in SharePoint as a lookup control.

 

 

Im currently using SharePoint 2007, VS 2005, .net 2.0 and .net 3.5 installed.

 

 

thank you

Answer 1

Good question..let me know when you have an answer!

---

-Raph

Answer 2

Hi,

I would suggest you put this question on the Business Data Catalog forum.

Please paste the link here afterwards if you get a nice reply/explanation.

From what I know so far, it is the only way to interact with other apps, but how do you get it completely to work, I cannot help you.

I have started doing something like that to connect to a MySQL DB, and using the BDC I got a table displayed on my site, reading from the DB, but I still couldn't figure out how to use this data for lookup from other tables.

Good luck,
JC

Answer 3

I think BDC works only for MOSS and it looks the originator of this case has only WSS.

Answer 4

The original post mentioned Sharepoint 2007, so I assume it to be MOSS unless otherwise stated.

As replied by other poster, BDC is the best way to display data from the third party database especially if its read only.

Or Otherwise, you can always write standard web part to incorporate ADO.NET code.
--
Madhur

---

http://blogs.msdn.com/mahuja | Please mark the replies as answers if they help

Answer 5

I wrote a web part fpr a client running WSS 3.0 that queries a database. I captured the basic steps on my blog; http://joeshepherd.spaces.live.com/Blog/cns!9AE2097A4A610B63!127.entry. This might help you get started.

---

j

Answer 6

 Does it need MOSS?

I am using just wss 3.0 SP1.

Please let me know.

Thanks

Answer 7

If you ever decide to go for a custom approach , pure ADO.NET way , here is one supprted way that works in both WSS and MOSS :

http://www.codeplex.com/threetierwss

---

Reza Alirezaei,MOSS 2007 MVP
http://blogs.devhorizon.com/reza