Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Accessing Oracle Database Data

  Asked By: Lauren    Date: Nov 02    Category: Sharepoint    Views: 3176

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.

Share: 

 

1 Answer Found

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

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.




Tagged: