2

Using SharePoint 2010, how can you connect to Oracle db to query a view and display the table in SharePoint?

1 Answer 1

2

You have to configure a custom BDC model, external content type, and then an external list. There is a really good article at C# Corner on the topic.

Here are the steps at a high level:

  1. Using VisualStudio create new Project of type SharePoint 2010 > Business Data Connectivity Model.
  2. Modify the default Entity from the BDC Model to fit your view.
  3. Build the Read Operations.
  4. Configure Business Data Connectivity access rights in Central Admin.
  5. Build/Deploy the solution
  6. Creating the External List.

Here are two MSDN articles on the topic as well.

How to: Connect to an Oracle Database Using Business Connectivity Services

Sample BDC Model: Connecting to an Oracle Database

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.