0

I want to create an External content type by connecting to an Oracle database using VS or SP designer,to show data in an external list?

I am a bit new to BCS model so a little background will be helpful.

Any help is welcomed ! Thank You.

1 Answer 1

0

You can achieve this via SharePoint designer by

  • Creating a database Link to connect to the remote Oracle table by installing OLEDB client on the SQL server only.

  • Then use SharePoint designer to build your external content type from SQL Server.

For more detail steps check SharePoint 2013:BCS Connect To Oracle DB No Code

If you need to build BCS via Visual studio check How to connect to the Oracle database using Business Connectivity Services (BCS)

Also, you can use Meta Man to Build External Content Types for Oracle, ODBC, WCF, Salesforce, Dynamics CRM, OData and Microsoft SQL without code. But unfortunately it requires a license

2
  • Is it possible to do the same with Visual Studio?Actually while making BDC model i am not able to save External content types and it is not appearing when clicking on external list. Also i am doing it in sandbox VM SP2013 where oracle client site is blocked.so effectively i cannot download anything.
    – Ahmed
    Oct 17, 2016 at 6:40
  • I have attached a link to can create this via visual studio, but at any case you will need to use oracle client.if you can't use oracle client you can build a web service at oracle server side and consume it at SharePoint side ! Oct 17, 2016 at 10:08

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.