25 Juli 2012 18:16
I got a task to fetch data from external database.I created a list with my required columns.
This is OOTB newform for sharepoint list.On click of search button it should fetch data from external database on basic of Project ID and it should populate all the fields of the form.Suppose database table is having same column as of sharepoint list.
Thanks in anticipation!!!
25 Juli 2012 18:37If you have MOSS 2007 Enterprise License, you can do this using the Business Data Connnectivity features
Dean MCTS-SQL 2005 Business Intelligence, SharePoint 2010, Configuration
26 Juli 2012 9:48Penjawab Pertanyaan
To add on Dean's answer, you'd be looking at using SharePoint to surface the data. SharePoint 2007 only pulls this as READ-ONLY data, with no easy way to make this a two way connection.
If you need to just make this available within searches, you might want to consider either federated search or adding the database as a content source.
Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
26 Juli 2012 13:33
To fetch data from external database you need to use BDC/BCS -
- BDC if SP 2007 - Read Only
- BCS if SP 2010 - Read/Write
For BCS read :
For BDC read:
Ashish Mishra|MCTS,MCPD in SharePoint 2010| Twitter:https://twitter.com/#!/707Mishra| Blog: http://www.sharepointblog.co.uk/author/ashishmishra/
13 Agustus 2012 1:04
For to get the data from the External database then you can follow the following approaches:
For SharePoint 2007: You can use Business Data Catalog ( BDC) to get data. More info you can get from the link below
For SharePoint 2010: You can use BCS ( Business Connectivity Services) to get data. There is a concept of External Content types and lists in SharePoint 2010. More info you can get from the link given below:
Hope this will work.
21 Agustus 2012 15:27
Hi Folks ,
Thanks for your response.I have used external list and got database records as a list.But,problem is with auto populating fields.For this i used CAML Query but it didn't work.Same CAML Query works fine for normal list but when i am applying this to External list it is not fetching data.
Hope for further guidance!!!!