A Sample of ADF Connecting to Oracle Database

Currently I’m working on BDC in SharePoint 2007. I’m trying to create a BDC Application Definition File (ADF) which connects to an Oracle database, and I didn’t know how to fill the connection properties. I did a search from Google and couldn’t find a sample. So I post the piece of xml which contains connection part here.

<Properties>
<Property Name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">Oracle</Property>
<Property Name="AuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">RevertToSelf</Property>
<Property Name="RdbConnection Data Source" Type="System.String">tnsDBname</Property>
<Property Name="RdbConnection Pooling" Type="System.String">false</Property>
<Property Name="RdbConnection User ID" Type="System.String">rouser</Property>
<Property Name="RdbConnection Password" Type="System.String">rouser</Property>
<Property Name="RdbConnection Integrated Security" Type="System.String"></Property>
<Property Name="WildcardCharacter" Type="System.String">%</Property>
</Properties>

The tnsDBname is the data source name I defined in tnsname.ora (Of course you should have Oracle client installed in your SharePoint server). “rouser” is my read-only account to that database.

A good choice is to use Microsoft BDC Generator, but it asks you to enter the connection string. A better choice is to use BDCMetaMan. When connecting to Oracle database, in Server Name in the popup window, remember to input the tnsname, not the physical server name.