Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS 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:accessing oracle database data

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.