SPD and external content type for Oracle

I'm trying BCS in SharePoint designer 2010. Is it possible to create 开发者_开发百科external content type for Oracle ? In the data source drop down I can see only ".NET Type" , "SQL Server" and "WCF Service" .

You could create a Web Service yourself which connects to your External System and use that using SharePoint Designer:

The company I work for has a tool called BCS Meta Man which will generate a .Net or Database model for you, it's a Visual Studio Extension:

BCS Meta Man BCS Meta Man + Oracle walkthrough

You can use just the normal Visual Studio BCS Model Project to make the Model manually, but you'll probably notice very quickly that it's quite a steep learning curve:

http://msdn.microsoft.com/en-us/library/ff464424(office.14).aspx