How to configure Business Data Catalog to get data from Oracle
Few weeks ago I used Business Data Catalog to get data from oracle database into MOSS 2007 lists \ Document Libraries \ BDC web parts.
To achieve that goal you should to implement some basic steps:
· Install oracle client on the moss machine and configure the TNS names file to access the server.
· Setup the MOSS 2007 SSO service. You should use MOSS 2007 SSO feature because this is the simple way to pass the U\P to the oracle against the Windows account.
· Create SSO application that will store the user\password to access the Oracle Database. I preferred to use the SSO for Group and to map AD group to SSO group so the users shouldn't enter any U\P and I can do it for them in advance.
· Create BDC xml File that use the SSO application. I attached sample file so you can change your connection and entities to your needs.