Firstly I'm open to suggestions if people have better solutions or ideas. I want to create a Dashboard with CRUD operations from the Oracle data and planning on using SPD External Content Types.
I've installed BCS on the server 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 at the moment.
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. https://msdn.microsoft.com/en-us/library/office/ff464424(v=office.14).aspx
Do I need to ONLY 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?
Thanks