BCS connecting to Oracle Database with BDC Model RRS feed

  • Question

  • Hi

    I've installed BCS and need to make a connection to Oracle. In SPD > External Content Type  I get options for .NET, SQL Server, WCF Service and no Oracle. In SPD I want to create a Dashboard with CRUD operations from the Oracle data.

    I've seen some 3rd part tools to do this but want to know if I can create my own XML file and add it to the BCS section in Central Admin. This link on the Microsoft site shows a sample of the xml file but not sure if it will work the way I intend.
    Do I need to copy the code on the linked page into notepad and make a few adjustments and add into BCS (Import BDC Model) ?

    Do I need to use Visual Studio as mentioned in several articles?


    Thursday, July 7, 2016 3:20 PM