Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

Accessing Oracle Database Data

  Asked By: Lauren Albert         Date: Nov 02, 2008      Category: Sharepoint      Views: 412
 

Can anyone guide me step-by-step how can i access oracle table's data as a webpart in a sharepoint site.

The specified (BDC) webpart need to display all the table's data by default, and it should also support searching, example display all emp table data and also support search by employee job.

Tagged:        

 

1 Answer Found

 
Answer #1       Answered By: Linsey Bauer          Answered On: Nov 02, 2008       

You can retrieve data  from a remote Oracle database  by using Business Data List Web Part. First you need to create an bdc  definition
file. Then you need to import this definition file into the Shared Services, finally create a Business Data List Web Part.

For more information about how to create a Business Data List Web Part, please refer to the following article:
Create a Business Data List Web Part
msdn.microsoft.com/en-us/library/ms493107.aspx

For more information about BDC List Web Part, you can refer to the following articles:
BDC Error Messages
blogs.msdn.com/.../bdc-error-messages.aspx

sharepointmagazine.net/.../everything-you-need-to-know-about-bdc-part-1-of-8

 
Didn't find what you were looking for? Find more on Accessing Oracle Database Data Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].