On
There are many posts describes how to connect to Oracle DB database using .NET assembly Type of BCS, it requires writing codes and install the Oracle Client or OLEDB on every App and WFE server.

I was going through the same road when it hits me , I can use Database Link to connect to the remote oracle table by installing OLEDB client on the SQL server only. Afterwards, I can easily create the BCS model by using SharePoint Designer.


  1. After creating the database link create a view to use it when creating the BCS let's name it MyTestView
  2. Open SharePoint Designers and connect to your site collection
  3. Click on create new External content type
  4. Name the external content type and click on the "Click here to discover external data sources and define operations" link
  5. Click on Add connection then Choose SQL server and click ok
  6. Enter the server details and database name
  7. Browse to the views and expand them you will see the view which we created (retrieve records from remote oracle DB)
  8. right click the view and generate both ReadItem and ReadList operations
  9. Make sure to map the identifier in both operations
  10. Save the External Content Type
  11. Create External List

Additional Information: 
In order to impersonate the user identity you need to create a secure store application and update the External Content type External System 

following this blog steps you can connect to remote oracle DB without writing a single line of Code.
Happy SharePointing